Les partenaires sociaux de la branche des grands magasins et magasins populaires ont conclu un accord le 28 mai 2024 afin de donner la faculté aux entreprises de rattacher certains salariés non-cadres aux régimes des garanties collectives de protection sociale complémentaire des cadres.
Un compte LégiSocial / LégiFiscal est nécessaire pour lire la suite.
M'inscrire ou me connecterTemps de génération: 0.35150718688965 Nombre requete SQL: 16
| 0 | 1 | |
|---|---|---|
| 0 | SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`ou... | 0.00090503692626953 |
| 1 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_edition t WHERE DAT... | 0.0061089992523193 |
| 2 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_breve t WHERE t.edi... | 0.0024259090423584 |
| 3 | SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`ou... | 0.00069189071655273 |
| 4 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_edition t WHERE DAT... | 0.0058879852294922 |
| 5 | SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`ou... | 0.0010721683502197 |
| 6 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_edition t WHERE DAT... | 0.0056760311126709 |
| 7 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_breve t WHERE t.edi... | 0.001384973526001 |
| 8 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_jorf t WHERE t.edit... | 0.0019779205322266 |
| 9 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_questionreponse t W... | 0.0018858909606934 |
| 10 | SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`ou... | 0.00093412399291992 |
| 11 | SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`ou... | 0.00087094306945801 |
| 12 | SELECT ct2.app_label, ct2.model, c.parent_object_id as id FROM legisocial.`ou... | 0.00082802772521973 |
| 13 | SELECT t.*, tag.label as tag, tag.url as tag_slug, "legisocial" as site FROM ... | 0.10250020027161 |
| 14 | SELECT t.*, tag.label as tag, tag.url as tag_slug, "legisocial" as site FROM ... | 0.056396961212158 |
| 15 | SELECT t.*, "legisocial" as site FROM legisocial.matinale_cdujour t WHERE t.e... | 0.0019829273223877 |
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