SELECT DISTINCT obituary.obituary_id, obituary.published_day AS 'published_date', website.website_id, people.people_id, people_address.city_id, people_address.address_id, people_address.address_type FROM publication INNER JOIN obituary ON (obituary.obituary_id = publication.item_id AND obituary.is_active = 1) LEFT JOIN website ON website.website_id = obituary.website_id LEFT JOIN website_people_address_type ON (website.website_id = website_people_address_type.website_id AND website_people_address_type.people_address_type_id = 10) LEFT JOIN display_subscription ON display_subscription.website_id = obituary.website_id LEFT JOIN people_obituary ON obituary.obituary_id = people_obituary.obituary_id LEFT JOIN people ON people.people_id = people_obituary.people_id LEFT JOIN people_address ON (people_address.people_id = people.people_id AND people_address.default ) WHERE ( publication.related_item_type_id = 2 OR display_subscription.is_active = 1 OR ( publication.related_item_type_id !=2 AND published_date < '2025-09-01') ) AND (website.active = 1 OR website.website_id IS null ) AND ( ( website_people_address_type.action_city IS NULL OR website_people_address_type.action_city = 'hide' ) AND people_address.address_type <> 'Robot' ) AND people_address.city_id = 381 ORDER BY obituary.published_day DESC, publication.related_item_type_id DESC, display_subscription.is_active DESC, obituary.obituary_id DESC LIMIT 36, 12
Résultats 37-48 sur un total de 360
Depuis le 1er septembre 2025, les avis de décès sur Le Nécrologue, une entreprise informatique privée, dépendent d’un abonnement payé par les maisons funéraires.
Ceci peut expliquer pourquoi certains avis sont temporairement absents.
👉Vous pouvez aussi exprimer à votre maison funéraire l’importance de ce service pour vous.
Merci de votre compréhension.
Voir plus d’informations à ce sujet sur cette page
