select distinct p.products_id, p.products_last_modified from products p , products_to_categories p2c ,cyo_search_index csi where csi.= '' AND p.products_id = csi.products_id AND csi.languages_id=1 AND p.products_status = '1' and p.virtual_product=1 and p.products_id = p2c.products_id and p.products_quantity > 0 and p.typeProduit in ('PRO') and p2c.categories_id= 124880 order by p.ordre_tri desc , p.ordre_tri desc
[TEP STOP]
