select pm.* from relation_master as rm left join product_master as pm on pm.product_id = rm.product_id where rm.type='subcat' and rm.type_id='350' and pm.product_status = 'publish' order by pm.push_to_top_date desc,product_id desc LIMIT 0, 20