<p>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</p><pre>Array
(
    [field1] => au-bureau
)
</pre><div class="alert alert-warning">PDO error: 42S22, 42S22, 1054, Unknown column 'gv.group_url' in 'on clause'</div>pas de réponse