

FLATS

HOUSES

LAND

COMMERCIALS

NEW+BUILDS

HOLIDAY PROPERTIES

SELECT * FROM categories WHERE category_id_1 != 0 AND category_id_2 = 0 AND lang = 'en' ORDER BY weight
SELECT * FROM locations WHERE location_id_1 != 0 AND location_id_2 = 0 AND location_id_3 = 0 AND location_id_4 = 0 AND lang = 'en' ORDER BY title
SELECT content_id, parent_id, menu, visible, link, title, alias, published FROM content WHERE lang = 'en' AND (revision_type IS NULL OR revision_type = 'active') ORDER BY weight
SELECT * FROM locations WHERE alias = '' AND lang = 'en'
SELECT * FROM locations WHERE location_id_1 != 0 AND location_id_2 = 0 AND location_id_3 = 0 AND location_id_4 = 0 AND lang = 'en' ORDER BY title
SELECT * FROM locations WHERE location_id_1 = 1 AND location_id_2 != 0 AND location_id_3 = 0 AND location_id_4 = 0 AND lang = 'en' ORDER BY title
SELECT * FROM categories WHERE alias IN ('') AND lang = 'en'
SELECT DISTINCT agency_id FROM realties WHERE status = 'active' AND agency_id != 1
SELECT COUNT(realty_id) FROM realties WHERE status = 'active'
SELECT COUNT(realty_id) FROM realties WHERE status = 'active' AND agency_id = 1
SELECT * FROM realties WHERE status = 'active' AND featured = 1 ORDER BY RANDOM() LIMIT 3
SELECT * FROM news ORDER BY date DESC LIMIT 3
SELECT * FROM blocks WHERE lang = 'en' AND visible = 1
SELECT * FROM blocks WHERE lang = 'en' AND visible = 1
SELECT * FROM blocks WHERE lang = 'en' AND visible = 1
SELECT * FROM blocks WHERE lang = 'en' AND visible = 1