SELECT title,main_divider_class,is_admin_form,is_trash FROM vwr1_listing_forms WHERE id IN ('4')

SELECT caption,property_type,property_category,property_status,id FROM vwr1_listing_forms_tabs WHERE form_id='4'

SELECT FF.*,LF.title,LF.field_name,LF.slug FROM vwr1_listing_forms_fields AS FF LEFT JOIN vwr1_listing_fields AS LF ON FF.field_id = LF.id WHERE LF.is_trash = 'No' AND (FF.form_id='4' AND FF.tab_id='608') OR (FF.form_id='4' AND FF.tab_id='608' AND FF.field_id=0) ORDER BY FF.position_y,FF.position_x

SELECT * FROM vwr1_listing_fields WHERE id IN ('0')

SELECT * FROM vwr1_listing_fields WHERE id IN ('22')

SELECT val_type FROM vwr1_listing_fields WHERE id IN ('22')

SELECT DISTINCT * FROM vwr1_listing_meta_general WHERE type = 'property_type' AND meta_rets != '' AND is_trash='No' AND is_visible = 'Yes' ORDER BY display_order, title

SELECT * FROM vwr1_listing_fields WHERE id IN ('26')

SELECT val_type FROM vwr1_listing_fields WHERE id IN ('26')

SELECT DISTINCT * FROM vwr1_listing_meta_geo WHERE type = 'city' AND city_visible = 'Yes' AND city != '' AND state_rets != '' AND is_trash='No' ORDER BY is_popular DESC, display_order, city

SELECT * FROM vwr1_listing_fields WHERE id IN ('25')

SELECT val_type FROM vwr1_listing_fields WHERE id IN ('25')

SELECT DISTINCT * FROM vwr1_listing_meta_geo WHERE type = 'area' AND area_visible = 'Yes' AND area != '' AND state_rets != '' AND is_trash='No' ORDER BY is_popular DESC, display_order, area

SELECT * FROM vwr1_listing_fields WHERE id IN ('0')

SELECT * FROM vwr1_listing_fields WHERE id IN ('0')

SELECT * FROM vwr1_listing_fields WHERE id IN ('0')

SELECT * FROM vwr1_listing_fields WHERE id IN ('13')

SELECT * FROM vwr1_listing_fields WHERE id IN ('14')

SELECT * FROM vwr1_listing_fields WHERE id IN ('20')

SELECT * FROM vwr1_listing_fields WHERE id IN ('19')

SELECT * FROM vwr1_listing_fields WHERE id IN ('16')

SELECT * FROM vwr1_listing_fields WHERE id IN ('23')

SELECT val_type FROM vwr1_listing_fields WHERE id IN ('23')

SELECT DISTINCT * FROM vwr1_listing_meta_general WHERE type = 'sub_type' AND meta_rets != '' AND is_trash='No' AND is_visible = 'Yes' ORDER BY display_order, title

SELECT * FROM vwr1_listing_fields WHERE id IN ('18')

SELECT * FROM vwr1_listing_fields WHERE id IN ('43')

SELECT * FROM vwr1_listing_fields WHERE id IN ('17')

SELECT * FROM vwr1_listing_fields WHERE id IN ('12')

SELECT * FROM vwr1_listing_fields WHERE id IN ('24')

SELECT val_type FROM vwr1_listing_fields WHERE id IN ('24')

SELECT DISTINCT year_built FROM vwr1_listing_master WHERE is_mark_for_deletion = 'N' AND is_trash='No' ORDER BY year_built

SELECT * FROM vwr1_listing_fields WHERE id IN ('67')

SELECT * FROM vwr1_listing_fields WHERE id IN ('0')

SELECT DISTINCT * FROM vwr1_listing_meta_general WHERE type = 'property_type' AND meta_rets != '' AND is_trash='No' AND is_visible = 'Yes' ORDER BY display_order, title

SELECT * FROM vwr1_listing_fields WHERE id IN ('0')

SELECT * FROM vwr1_listing_fields WHERE id IN ('0')

SELECT * FROM vwr1_listing_fields WHERE id IN ('0')

SELECT DISTINCT * FROM vwr1_listing_meta_general WHERE type = 'status' AND meta_rets != '' AND is_trash='No' AND is_visible = 'Yes' ORDER BY display_order, title

SELECT * FROM vwr1_listing_fields WHERE id IN ('0')

SELECT * FROM vwr1_listing_fields WHERE id IN ('0')