Criteria: SQL (may not be complete): SELECT product.id_product, product.id_product_template, product.internal_sku, product.id_software, product.qty, product.price, product.discount, product.etat, product.has_color_image, product.ext_color_image, product.slug_tmp, product.id_couleur, product.id_grandeur, product.id_largeur, product.date_creation, product.date_modification, product.id_group_creation, product.id_creation, product.id_modification, product_template.id_product_template, product_template.id_product_matrix, product_template.id_product_section, product_template.id_product_category, product_template.id_product_sub_category, product_template.id_brand, product_template.software, product_template.internal_sku, product_template.id_software, product_template.prix_ship_sup, product_template.etat, product_template.has_image, product_template.ext_image, product_template.mag_image, product_template.mja, product_template.slug_tmp, product_template.desc_eng_tmp, product_template.desc_fr_tmp, product_template.date_creation, product_template.date_modification, product_template.id_group_creation, product_template.id_creation, product_template.id_modification FROM `product` INNER JOIN `product_template` ON (product.id_product_template=product_template.id_product_template) LEFT JOIN `product_i18n` ON (product.id_product=product_i18n.id_product) LEFT JOIN `product_template_i18n` ON (product_template.id_product_template=product_template_i18n.id_product_template) WHERE product_i18n.locale=:p1 AND product_i18n.slug=:p2 AND product_template_i18n.locale=:p3 AND product_template_i18n.slug=:p4 Params: product_i18n.locale => 'fr_CA', product_i18n.slug => '2-noir-bleu--acton--botte-hiver-grand', product_template_i18n.locale => 'fr_CA', product_template_i18n.slug => 'nordik1203'../store/catalog/product