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 Horizontal MORI SEIKI MH40 H184
Sold

Machining Center Horizontal MORI SEIKI MH40 H184
Machining Center Horizontal MORI SEIKI MH40 H198
Sold

Machining Center Horizontal MORI SEIKI MH40 H198
Machining Center Horizontal MORI SEIKI SH-400 H202
Sold

Machining Center Horizontal MORI SEIKI SH-400 H202
Machining Center Horizontal MSZ MC 1250 P H200
Sold

Machining Center Horizontal MSZ MC 1250 P H200
Machining Center Horizontal OKK MCH 450 E185
Sold

Machining Center Horizontal OKK MCH 450 E185
Machining Center Horizontal OKUMA MA-60HB H192
Sold

Machining Center Horizontal OKUMA MA-60HB H192
Machining Center Horizontal OKUMA MA-60HB H193
Sold

Machining Center Horizontal OKUMA MA-60HB H193
Machining Center Horizontal OKUMA MILLAC MH40 E195
Sold

Machining Center Horizontal OKUMA MILLAC MH40 E195
Machining Center Horizontal SCHARMANN Solon 2 H199
Sold

Machining Center Horizontal SCHARMANN Solon 2 H199
Machining Center Horizontal TOYODA MITSUI SEIKI FH63-S H194
Sold

Machining Center Horizontal TOYODA MITSUI SEIKI FH63-S H194
Machining Center Horizontal TSUGAMI MA3 H119
Sold

Machining Center Horizontal TSUGAMI MA3 H119
Machining Center Horizontal WMW- FRITZ HECKERT CW 630 E196
Sold

Machining Center Horizontal WMW- FRITZ HECKERT CW 630 E196
Machining Center Horizontal WMW-HECKERT CW 100 E180
Sold

Machining Center Horizontal WMW-HECKERT CW 100 E180
Machining Center Vertical ANAYAK Anayakmatic 9 E119
Sold

Machining Center Vertical ANAYAK Anayakmatic 9 E119
Machining Center Vertical DECKEL MAHO DMC 63 V V208
Sold

Machining Center Vertical DECKEL MAHO DMC 63 V V208