SELECT publ_id, publ_anno_id, publ_libelle, publ_site_id, publ_form_id, publ_position, publ_nb_print, publ_nb_clic, publ_priorite, publ_actif, publ_date_debut, publ_date_fin, publ_url_image, publ_url_redirect, publ_html, publ_autopromo, publ_archive, publ_date_crea FROM Lariviere_Publicite.publicite INNER JOIN Lariviere_Publicite.format ON form_id=publ_form_id INNER JOIN Lariviere_Publicite.format ON form_id=publ_form_id INNER JOIN Lariviere_Publicite.groupe_format ON grfo_form_id=form_id publ_actif=1 AND publ_position=1 AND publ_date_debut<='2010-03-13' AND publ_date_fin>='2010-03-13' AND publ_site_id=9 AND publ_autopromo=1 AND grfo_sigf_id=0 ORDER BY Lariviere_Publicite.publicite.publ_id<br />