SELECT pe.record_id as id,pe.alias,pe.category_alias,pe.title,pe.summary AS summary,pe.summary_auto,p.image,pe.price,pe.price_sale AS price_sale,p.currency,p.total,p.kiotviet_time,pe.discount,pe.manufactory_image,pe.manufactory_name,pe.manufactory_alias,p.is_new,p.is_sale,p.is_hot,p.status,p.is_super_sale, p.vote_score, pe.category_id_wrapper FROM fs_products AS p INNER JOIN fs_products_tui_tennis AS pe ON p.id = pe.record_id
WHERE p.published = 1 AND pe.is_lang=1 AND pe.category_id_wrapper LIKE "%,53,%" ORDER BY pe.is_new DESC