select el.*,ex.*, pd.property_id, pd.property_status, pd.specialoffer_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='special' and el.location_id IN () and el.item_type='rental' OR (pd.specialoffer_status=3 and pd.item_type='rental' and el.location_id IN ()) order by rand()
[TEP STOP]