SELECT `products`.*
FROM `products`
INNER JOIN (SELECT `product_id`
FROM `products`
WHERE `del_flg` = 0
AND `exposure` = 0
AND `part_category2` LIKE '%034010%' ESCAPE '!'
ORDER BY `qty` DESC) b ON `products`.`product_id` = `b`.`product_id`
LIMIT 20
CHIPDIRECT :: 전자부품 전문몰 칩다이렉트
