Warning: session_start(): open(/hermes/phpsessions/8/9/f/e/sess_89fe12b81fd796af25d5eb558224f46c, O_RDWR) failed: Permission denied (13) in /hermes/bosnacweb04/bosnacweb04bj/b576/nf.webvraccom/public_html/webvrac_com/protected/config.php on line 33
Warning: session_write_close(): open(/hermes/phpsessions/8/9/f/e/sess_89fe12b81fd796af25d5eb558224f46c, O_RDWR) failed: Permission denied (13) in /hermes/bosnacweb04/bosnacweb04bj/b576/nf.webvraccom/public_html/webvrac_com/protected/config.php on line 36
Warning: session_write_close(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (4;/hermes/phpsessions) in /hermes/bosnacweb04/bosnacweb04bj/b576/nf.webvraccom/public_html/webvrac_com/protected/config.php on line 36
Laitue Black Seeded Simpson, semences biologiques, jardin
Membre de l'Organisme de certification Québec Vrai depuis 2002, Les Jardins de l'Écoumène propose uniquement des produits biologiques certifiés.
Valeur nutritive Nutrion Facts
Par 1 morceau (50 g)
Teneur Amount% valeur quotidienne % daily value
Calories 0
Lipides 0 g
Saturés 0 g
+ Trans 0 g
Cholestérol 0 mg
Sodium 0 mg
Glucides 0 g
Fibres 0 g
Sucres 0 g
Protéines 0 g
Vitamine A
0%
Vitamine C
0%
Calcium
0%
Fer
0%
SELECT
*,
P.id as id,
P.id as idproduit,
CGL.title as titregroupe,
CL.seo_permalink as uricategorie,
PL.title as nomproduit,
CL.title as titrecategorie,
C.id as idcategorie,
CL.seo_title as seo_title_category,
CL.seo_meta_description as seo_meta_description_category,
CL.text as textcategorie,
PCL.title as titrecategorieproduit
FROM
smtbl_categories_multilingual CL
LEFT JOIN smtbl_categories C ON C.id = CL.id_category
LEFT JOIN smtbl_categories_groups CG ON CG.id = C.id_category_group
LEFT JOIN smtbl_categories_groups_multilingual CGL ON CGL.id_category_group = C.id_category_group
LEFT JOIN smtbl_products_categories PC ON PC.id_category = C.id
LEFT JOIN smtbl_categories CP ON CP.id = PC.id_category
LEFT JOIN smtbl_categories_multilingual PCL ON PCL.id_category = CP.id
LEFT JOIN smtbl_categories_groups CG2 ON CG2.id = CP.id_category_group
LEFT JOIN smtbl_products P ON P.id = PC.id_product
LEFT JOIN smtbl_products_multilingual PL ON PL.id_product = P.id
LEFT JOIN smtbl_images_relations IR ON IR.id_item = P.id AND IR.id_module =3 AND IR.id_image = P.couverture
LEFT JOIN smtbl_images I ON I.id = IR.id_image
LEFT JOIN smtbl_pdj pdj ON pdj.product_id = P.id AND pdj.date = CURDATE()
WHERE
C.id IN (272)
AND
PL.id_language='1'
AND
C.id_category_group != 17 AND
C.id_category_group != 15
GROUP BY P.id
ORDER BY rand()
LIMIT 3
