Designed to hold large quantities of post, large letters and catalogues
The postbox D500 in matt steel is a large capacity post box which is ideal for home or the office. It has a secure element too which prevents the post from falling out when the post box is opened, also has a slot opening at the top.
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 '%|243|%'