SELECT properties.*, (SELECT vidove.ime FROM vidove WHERE kade='listing_types' AND vidove.code=properties.listing_type ORDER by id LIMIT 1) as listing_type, (SELECT vidove.ime FROM vidove WHERE kade='estate_types' AND vidove.code=properties.estate_type ORDER by id LIMIT 1) as estate_type, (SELECT vidove.ime FROM vidove WHERE kade='furnishing_types' AND vidove.code=properties.furnishing ORDER by id LIMIT 1) as furnishing, (SELECT vidove.ime FROM vidove WHERE kade='address' AND vidove.code=properties.region ORDER by id LIMIT 1) as Region, (SELECT vidove.ime FROM vidove WHERE kade='address' AND vidove.code=properties.subregion ORDER by id LIMIT 1) as SubRegion, (SELECT vidove.ime FROM vidove WHERE kade='currency' AND vidove.code=properties.currency ORDER by id LIMIT 1) as Currency FROM properties WHERE kade='Нормално' AND (listing_type = 1) ORDER by estate_type, subregion, price