SELECT p.*, pfr.* FROM #__virtuemart_products as p LEFT JOIN #__virtuemart_products_fr_fr as pfr on pfr.virtuemart_product_id = p.virtuemart_product_id LEFT JOIN #__virtuemart_product_categories as pc on pc.virtuemart_product_id = p.virtuemart_product_id WHERE p.published = 1 AND p.product_parent_id != 0 AND pc.virtuemart_category_id != 153 AND pc.virtuemart_category_id != 112 AND p.ville like '%CORK (Irlande)%' ORDER BY pfr.product_name LIMIT 0 , 10
