2 avenants à la Convention collective nationale des Hôtels Cafés Restaurants (IDCC 1979) ont été signés :
Un compte LégiSocial / LégiFiscal est nécessaire pour lire la suite.
M'inscrire ou me connecterTemps de génération: 0.21799683570862 Nombre requete SQL: 16
| 0 | 1 | |
|---|---|---|
| 0 | SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`ou... | 0.00072407722473145 |
| 1 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_edition t WHERE DAT... | 0.0050749778747559 |
| 2 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_breve t WHERE t.edi... | 0.0021600723266602 |
| 3 | SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`ou... | 0.00065183639526367 |
| 4 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_edition t WHERE DAT... | 0.0042538642883301 |
| 5 | SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`ou... | 0.00053596496582031 |
| 6 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_edition t WHERE DAT... | 0.0032079219818115 |
| 7 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_breve t WHERE t.edi... | 0.0012788772583008 |
| 8 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_jorf t WHERE t.edit... | 0.0017530918121338 |
| 9 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_questionreponse t W... | 0.0011081695556641 |
| 10 | SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`ou... | 0.00049209594726562 |
| 11 | SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`ou... | 0.00055599212646484 |
| 12 | SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`ou... | 0.00043201446533203 |
| 13 | SELECT t.*, tag.label as tag, tag.url as tag_slug, "legisocial" as site FROM ... | 0.033206939697266 |
| 14 | SELECT t.*, tag.label as tag, tag.url as tag_slug, "legisocial" as site FROM ... | 0.0092871189117432 |
| 15 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_cdujour t WHERE t.e... | 0.0010271072387695 |
SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`outil_composition` c INNER JOIN legisocial.`django_content_type` ct ON ct.app_label = :app_label AND ct.model = :model AND ct.id = c.content_type_id INNER JOIN legisocial.`django_content_type` ct2 ON c.parent_content_type_id = ct2.id WHERE c.object_id = :id
SELECT t.*, "legisocial" as site FROM legisocial.matinale_edition t WHERE DATE(t.edition_date) = DATE(:edition_date)
SELECT t.*, "legisocial" as site FROM legisocial.matinale_breve t WHERE t.edition_id = :edition_id ORDER BY ordre ASC
SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`outil_composition` c INNER JOIN legisocial.`django_content_type` ct ON ct.app_label = :app_label AND ct.model = :model AND ct.id = c.content_type_id INNER JOIN legisocial.`django_content_type` ct2 ON c.parent_content_type_id = ct2.id WHERE c.object_id = :id
SELECT t.*, "legisocial" as site FROM legisocial.matinale_edition t WHERE DATE(edition_date) < DATE(:edition_date) AND DATE(edition_date) <= DATE(NOW()) ORDER BY edition_date DESC LIMIT 1
SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`outil_composition` c INNER JOIN legisocial.`django_content_type` ct ON ct.app_label = :app_label AND ct.model = :model AND ct.id = c.content_type_id INNER JOIN legisocial.`django_content_type` ct2 ON c.parent_content_type_id = ct2.id WHERE c.object_id = :id
SELECT t.*, "legisocial" as site FROM legisocial.matinale_edition t WHERE DATE(edition_date) > DATE(:edition_date) AND DATE(edition_date) <= DATE(NOW()) ORDER BY edition_date DESC LIMIT 1
SELECT t.*, "legisocial" as site FROM legisocial.matinale_breve t WHERE t.edition_id = :edition_id ORDER BY ordre ASC
SELECT t.*, "legisocial" as site FROM legisocial.matinale_jorf t WHERE t.edition_id = :edition_id
SELECT t.*, "legisocial" as site FROM legisocial.matinale_questionreponse t WHERE t.edition_id = :edition_id ORDER BY ordre ASC
SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`outil_composition` c INNER JOIN legisocial.`django_content_type` ct ON ct.app_label = :app_label AND ct.model = :model AND ct.id = c.content_type_id INNER JOIN legisocial.`django_content_type` ct2 ON c.parent_content_type_id = ct2.id WHERE c.object_id = :id
SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`outil_composition` c INNER JOIN legisocial.`django_content_type` ct ON ct.app_label = :app_label AND ct.model = :model AND ct.id = c.content_type_id INNER JOIN legisocial.`django_content_type` ct2 ON c.parent_content_type_id = ct2.id WHERE c.object_id = :id
SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`outil_composition` c INNER JOIN legisocial.`django_content_type` ct ON ct.app_label = :app_label AND ct.model = :model AND ct.id = c.content_type_id INNER JOIN legisocial.`django_content_type` ct2 ON c.parent_content_type_id = ct2.id WHERE c.object_id = :id
SELECT t.*, tag.label as tag, tag.url as tag_slug, "legisocial" as site FROM legisocial.contenu_actualite t LEFT JOIN cms_tag tag ON t.tag_id = tag.id WHERE DATE(:date) = DATE(date_publication) AND (DATE(:date) < date_end OR date_end is NULL) ORDER BY date_publication DESC, id DESC
SELECT t.*, tag.label as tag, tag.url as tag_slug, "legisocial" as site FROM legisocial.contenu_fichepratique t LEFT JOIN cms_tag tag ON t.tag_id = tag.id WHERE DATE(:date) = DATE(date_publication) AND (DATE(:date) < date_end OR date_end is NULL) ORDER BY date_publication DESC, id DESC
SELECT t.*, "legisocial" as site FROM legisocial.matinale_cdujour t WHERE t.edition_id = :edition_id