Mysql Error(Unknown column 'p.fromDate' in 'field list')
Query:
SELECT p.id,
p.status_id,
p.agent,
p.ref,
p.newDev,
p.newdevRef,
t.property_type_es as property_type,
r.region_es as region,
r.region_es as region,
p.summary_es as summary,
p.price,
p.name,
p.rent_price,
p.discountFrom,
p.discountTo,
a.area_es as area,
p.beds,
p.rental_type,
p.fromDate,
p.fromMonth,
p.fromYear,
p.toDate,
p.toMonth,
p.toYear,
p.baths,
p.propm2,
p.plotm2,
p.description
FROM properties as p
INNER JOIN property_type as t ON p.type_id = t.id
LEFT JOIN region as r ON p.region_id = r.id
LEFT JOIN area as a ON p.area_id = a.id
WHERE p.status_id != 2 AND p.status_id != 6 AND p.module = 'Sale' AND p.region_id = 29 AND p.area_id = 118