SELECT IFNULL(id_order, 0) FROM PREFIX_orders o LEFT JOIN PREFIX_address a ON o.id_address_delivery = a.id_address LEFT JOIN PREFIX_country c ON c.id_country = a.id_country WHERE o.valid = 1 AND a.id_country != "{config}PS_COUNTRY_DEFAULT{/config}" AND c.iso_code IN (
"BY",
"EE",
"LT",
"LV",
"MD",
"PL",
"UA",
"AL",
"BA",
"BG",
"GR",
"HR",
"MK",
"RO",
"SI",
"YU",
"RU"
)