SELECT record_id as id,alias,category_alias,category_id, name ,summary_auto, image,promotion_info, price,price_old,discount,types,manufactory_image,manufactory_name,manufactory_alias,published_double,warranty ,image_double,summary,is_hotdeal,date_end,date_start,promotion_price FROM fs_products_sua_chua_sony AS a
WHERE published = 1 AND( dong_sony like '%,17,%' OR dong_sony like '%,9,%' OR dong_sony like '%,6,%' OR dong_sony like '%,1,%' ) AND( loai_kinh like '%,2,%' )AND category_id_wrapper like "%,30,%" ORDER BY created_time DESC, ABS(price) DESC,ordering DESC