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=2 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 = 'PRO' and p2c.categories_id= 124773 order by p.ordre_tri desc , p.ordre_tri desc
[TEP STOP]


