Premar Atlantique
: SELECT * FROM atlantique_configs WHERE code = 'BLOCKPORTAILS' : SELECT * FROM atlantique_categories WHERE id_parent= '0' ORDER BY id ASC : SELECT * FROM atlantique_pages WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT * FROM atlantique_news WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT arretes.* FROM atlantique_arretes as arretes
INNER JOIN atlantique_arretes_tab as tab ON tab.id_arretes=arretes.id
INNER JOIN atlantique_arretes_dep as departement ON departement.id=tab.id_departement
WHERE arretes.status=1
AND departement.status=1
AND arretes.id_categorie IN (0)
ORDER BY arretes.date_debut DESC LIMIT 10 : SELECT * FROM atlantique_avurnav WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT * FROM atlantique_recueil WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT * FROM atlantique_dossiers WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT * FROM atlantique_categories WHERE id = 0 AND status=1
Premar Manche et Mer du Nord
: SELECT * FROM manche_configs WHERE code = 'BLOCKPORTAILS' : SELECT * FROM manche_categories WHERE id_parent= '0' ORDER BY id ASC : SELECT * FROM manche_pages WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT * FROM manche_news WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT arretes.* FROM manche_arretes as arretes
INNER JOIN manche_arretes_tab as tab ON tab.id_arretes=arretes.id
INNER JOIN manche_arretes_dep as departement ON departement.id=tab.id_departement
WHERE arretes.status=1
AND departement.status=1
AND arretes.id_categorie IN (0)
ORDER BY arretes.date_debut DESC LIMIT 10 : SELECT * FROM manche_avurnav WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT * FROM manche_recueil WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT * FROM manche_dossiers WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT * FROM manche_categories WHERE id = 0 AND status=1
Premar Méditerranée
: SELECT * FROM mediterranee_configs WHERE code = 'BLOCKPORTAILS' : SELECT * FROM mediterranee_categories WHERE id_parent= '0' ORDER BY id ASC : SELECT * FROM mediterranee_pages WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT * FROM mediterranee_news WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT arretes.* FROM mediterranee_arretes as arretes
INNER JOIN mediterranee_arretes_tab as tab ON tab.id_arretes=arretes.id
INNER JOIN mediterranee_arretes_dep as departement ON departement.id=tab.id_departement
WHERE arretes.status=1
AND departement.status=1
AND arretes.id_categorie IN (0)
ORDER BY arretes.date_debut DESC LIMIT 10 : SELECT * FROM mediterranee_avurnav WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT * FROM mediterranee_recueil WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT * FROM mediterranee_dossiers WHERE status=1 AND id_categorie IN (0) ORDER BY date DESC LIMIT 10 : SELECT * FROM mediterranee_categories WHERE id = 0 AND status=1