SELECT g.`url`, g.`country`, g.`nom`, g.`baseline`, g.`logo`, g.`pictogramme`, g.`photo`, g.`description`, g.`fondation`, g.`internet`, g.`facebook`, g.`twitter`, g.`phone`, g.`internet_affiliation`, g.`internet_nofollow`, g.`publicite300x250`, g.`categorie`, g.`categorie2`, g.`categorie3`, g.`type`, g.`important`, g.`infos_total`, g.`infos_employees`, g.`infos_incomes`, g.`infos_superficy`, g.`statut`, g.`date`, g.`twitter`, g.`nom` as `name`, p.`publicite_code`, gv.`video`, g.`nb_shops`, c.`fr` as categorie_nom, c2.`fr` as categorie2_nom, c3.`fr` as categorie3_nom FROM `groupe` g LEFT OUTER JOIN `categorie` c ON g.categorie=c.id LEFT OUTER JOIN `categorie` c2 ON g.categorie2=c2.id LEFT OUTER JOIN `categorie` c3 ON g.categorie3=c3.id LEFT OUTER JOIN `groupe_video` gv ON gv.`group_url`=g.`url` AND gv.`pays`='fr' AND gv.`site`='horairescommerces' LEFT OUTER JOIN `publicite` p ON p.`item_id`=c.`id` AND p.`country`=g.`country` AND p.`type`='category' AND p.`website`='horairescommerces' WHERE g.`country`="fr" AND ( g.`url`=:field1 ) AND g.`statut`="visible" ORDER BY nom ASC

Array
(
    [field1] => grain-de-malice
)
PDO error: 42S22, 42S22, 1054, Unknown column 'gv.group_url' in 'on clause'
pas de réponse