

BYTY

DOMY

POZEMKY

KANCELÁRIE, KOMERČNÉ OBJEKTY

NOVOSTAVBY

REKREAČNÉ NEHNUTEĽNOSTI

SELECT module, right_id FROM user_rights WHERE type = 'group' AND id = 1
SELECT * FROM categories WHERE category_id_1 != 0 AND category_id_2 = 0 AND lang = 'sk' 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 = 'sk' ORDER BY title
SELECT content_id, parent_id, menu, visible, link, title, alias, published FROM content WHERE lang = 'sk' AND (revision_type IS NULL OR revision_type = 'active') ORDER BY weight
SELECT * FROM locations WHERE alias = '' AND lang = 'sk'
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 = 'sk' 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 = 'sk' ORDER BY title
SELECT * FROM categories WHERE alias IN ('') AND lang = 'sk'
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 = 'sk' AND visible = 1
SELECT * FROM blocks WHERE lang = 'sk' AND visible = 1
SELECT * FROM blocks WHERE lang = 'sk' AND visible = 1
SELECT * FROM blocks WHERE lang = 'sk' AND visible = 1