SELECT p.*, p.id AS id, p.title AS title, p.street_num, p.street, p.surface_area_terrace, p.street2, p.description as description, p.created as created, p.sea_view, p.golf_close, p.beds, p.province, p.alias as alias, p.listing_info, pm.cat_id FROM psi48_iproperty AS p LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id WHERE pm.cat_id != 0 AND `p`.`id` IN ('342539') AND p.approved = 1 AND GROUP BY p.id ORDER BY p.street ASC