SELECT "products".*
FROM "products"
INNER JOIN (SELECT "product_id"
FROM "products"
WHERE "del_flg" = 'f'
AND "exposure" = 'f'
AND "part_category" LIKE '%004%' ESCAPE '!'
ORDER BY "qty" DESC) b ON "products"."product_id" = "b"."product_id"
LIMIT 20
ICPLUG
