Array ( [code] => 1 [value] => Resource id #518 [numrows] => [sql] => SELECT ptt.* FROM propertytype AS pt LEFT JOIN propertytypetype AS ptt USING(propertytypetypeid) LEFT JOIN property AS p USING(propertyid) LEFT JOIN client_prop_room AS cpr USING (propertyid) WHERE p.cityid='' AND cpr.client_id = '5000' AND cpr.prop_disabled = 0 AND cpr.prop_inactive = 0 AND cpr.room_disabled = 0 AND cpr.room_inactive = 0 GROUP BY ptt.propertytypetypeid; )