SELECT customers.*, customers_images.image_id, customers_localizations1.description as description_it, customers_localizations2.description as description_en FROM customers LEFT JOIN customers_images ON customers.customer_id = customers_images.customer_id LEFT JOIN customers_localizations as customers_localizations1 ON (customers.customer_id = customers_localizations1.customer_id AND customers_localizations1.lang = 'it') LEFT JOIN customers_localizations as customers_localizations2 ON (customers.customer_id = customers_localizations2.customer_id AND customers_localizations2.lang = 'en') WHERE 1=1 AND customers.customer_id = 9 ORDER BY customers.customer_id DESC