SELECT product_id FROM products where 1=1 and status=1 and is_sold=0 and FIND_IN_SET(:category_id, category_id) and FIND_IN_SET(:domain_ids, domain_ids)-49

SOLD Articles

Machining Center Double Column-Vert MITSUBISHI M-VB16A V163
Sold

Machining Center Double Column-Vert MITSUBISHI M-VB16A V163
Machining Center Double Column-Vert SZIM K223
Sold

Machining Center Double Column-Vert SZIM K223
Machining Center Horizontal DAEWOO ACE 100 H196
Sold

Machining Center Horizontal DAEWOO ACE 100 H196
Machining Center Horizontal DAEWOO ACE H63 E198
Sold

Machining Center Horizontal DAEWOO ACE H63 E198
Machining Center Horizontal DAEWOO ACE H80 H165
Sold

Machining Center Horizontal DAEWOO ACE H80 H165
Machining Center Horizontal DAEWOO HM 63-M E182
Sold

Machining Center Horizontal DAEWOO HM 63-M E182
Machining Center Horizontal DMG (DECKEL-MAHO-GILDEMEISTER) DMU 80H E179
Sold

Machining Center Horizontal DMG (DECKEL-MAHO-GILDEMEISTER) DMU 80H E179
Machining Center Horizontal FEELER FMH-500 E178
Sold

Machining Center Horizontal FEELER FMH-500 E178
Machining Center Horizontal HELLER BEA 3 E194
Sold

Machining Center Horizontal HELLER BEA 3 E194
Machining Center Horizontal HELLER BEA 3 H150
Sold

Machining Center Horizontal HELLER BEA 3 H150
Machining Center Horizontal HELLER MC 12 H197
Sold

Machining Center Horizontal HELLER MC 12 H197
Machining Center Horizontal HELLER MCP-H 250-HS E181
Sold

Machining Center Horizontal HELLER MCP-H 250-HS E181
Machining Center Horizontal HITACHI HG 500 E175
Sold

Machining Center Horizontal HITACHI HG 500 E175
Machining Center Horizontal HITACHI SEIKI HG 630 E176
Sold

Machining Center Horizontal HITACHI SEIKI HG 630 E176
Machining Center Horizontal HITACHI SEIKI HG 630 H206
Sold

Machining Center Horizontal HITACHI SEIKI HG 630 H206