|
0 - select el.*,ex.*, pd.property_id, pd.property_status,pd.feature_status from enter_location el LEFT OUTER JOIN property_description pd on el.property_id=pd.property_id LEFT OUTER JOIN extra_order_data ex ON pd.property_id=ex.property_id where pd.property_status='3' and ex.order_status=3 and ex.extra_order_type='feature' and el.location_id IN ( ) and el.item_type='rental' OR (pd.feature_status='3' and pd.item_type='rental' and el.location_id IN ( )) GROUP BY el.location_id order by rand() [TEP STOP] |