Opens at the top - ideal for large items of post like mail-order catalogues etc. Mail receptacle - letters cannot fall out when the postbox is opened. Suitable for wall and post mounting, matching newspaper holder available separately.
SELECT COUNT(*) AS TOTAL
FROM entries
INNER JOIN p_individualMailboxAccessories
ON p_individualMailboxAccessories.`productID` = entries.`ID`
INNER JOIN products_tr
ON products_tr.`productID` = entries.`ID`
WHERE products_tr.`language` LIKE 'EN'
AND p_individualMailboxAccessories.`compatibleProducts` LIKE '%|246|%'