SQL : SELECT mod609_product.id_product, mod609_product_lang.name FROM mod609_product, mod609_product_lang WHERE mod609_product.id_product = mod609_product_lang.id_product and mod609_product.spareparts = 1 and mod609_product_lang.id_lang = 1 and mod609_product.active = 1 order by mod609_product_lang.name