SQL Query:
SELECT master.rowId, master.city_text_location_master, master.total_ratings, master.total_views,
units.property_title, units.property_type, units.price_min, units.price_max, units.bedrooms,
units.total_area, units.area_min, units.area_max
FROM property_list_master master
LEFT JOIN property_list_units units ON master.property_uid = units.property_uid
WHERE master.activestatus = 1 AND master.company_id = 1
ORDER BY master.rowId DESC
LIMIT 12 OFFSET 192
Count Query: SELECT COUNT(*) AS total FROM property_list_master master LEFT JOIN property_list_units units ON master.property_uid = units.property_uid WHERE master.activestatus = 1 AND master.company_id = 1
