SELECT id,name,alias,price,price_old,discount,image,category_alias,created_time FROM fs_products_kr AS a WHERE category_id_wrapper like '%,329,%' AND published = 1 AND ( (price > 0 and price <= 100000) OR (price > 100000 and price <= 300000) OR (price > 300000 and price <= 500000) OR (price > 500000 and price <= 1000000) OR price > 1000000 ) ORDER BY ordering DESC