SELECT COUNT(*) FROM ps_orders o INNER JOIN ps_address a ON a.id_address = o.id_address_delivery
WHERE reference NOT IN ("XKBKNABJK", "OHSATSERP", "FFATNOMMJ", "UOYEVOLI", "KHWLILZLL") AND a.id_country != "{config}PS_COUNTRY_DEFAULT{/config}"