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 = 2141 ORDER BY obituary.published_day DESC, publication.related_item_type_id DESC, display_subscription.is_active DESC, obituary.obituary_id DESC LIMIT 0, 12
Since September 1, 2025, obituaries on Le Nécrologue, a private technology company, are available through a subscription paid by funeral homes.
This may explain why some obituaries are temporarily missing.
👉 You may also let your funeral home know how important this service is to you.
Thank you for your understanding.
