SELECT p.id AS property_id, p.property_type, p.price, p.price_currency, p.price_time_type, p.nr_rooms, p.nr_bedrooms, p.nr_bathrooms, p.start_date, p.description AS property_description, ad.zone, ad.city, agencies.id AS agency_id, agencies.name AS agency_name, agencies.tel, agents.id AS agent_id FROM properties p JOIN addresses ad ON p.address_id = ad.id JOIN agents ON p.agent_id = agents.id JOIN agencies ON agents.agency_id = agencies.id WHERE p.deleted = 0 AND p.price > 0 AND p.start_date + INTERVAL 6 MONTH > NOW() AND p.active = 1 AND p.buy = 0 ORDER BY p.id DESC
Array ( [0] => Array ( [id] => 54 [name] => Ajer i kondicionuar ) [1] => Array ( [id] => 68 [name] => Ashensor ) [2] => Array ( [id] => 67 [name] => Garazh ) [3] => Array ( [id] => 97 [name] => I mobiluar ) [4] => Array ( [id] => 104 [name] => Instalime elektrike ) [5] => Array ( [id] => 102 [name] => Internet ) [6] => Array ( [id] => 98 [name] => Kopsht ) [7] => Array ( [id] => 92 [name] => Ndertim i ri ) [8] => Array ( [id] => 55 [name] => Ngrohje me gaz ) [9] => Array ( [id] => 99 [name] => Papafingo ) [10] => Array ( [id] => 56 [name] => Parking ) [11] => Array ( [id] => 94 [name] => Pishine ) [12] => Array ( [id] => 91 [name] => Prane Autostrades ) [13] => Array ( [id] => 93 [name] => Prane detit ) [14] => Array ( [id] => 95 [name] => Prane transportit publik ) [15] => Array ( [id] => 101 [name] => Qender komunitare ) [16] => Array ( [id] => 96 [name] => Qender qyteti ) [17] => Array ( [id] => 105 [name] => Satelit ) [18] => Array ( [id] => 106 [name] => Sherbimi shendetesor ) [19] => Array ( [id] => 103 [name] => Telefon ) [20] => Array ( [id] => 100 [name] => Verande ) [21] => Array ( [id] => 53 [name] => Vile ) )

Nuk u gjet asnje prone