SELECT products.ID, products.INV_NUMBER as TITLE,products.FAKE_URL FROM products, cat_prod WHERE cat_prod.CAT_ID='10' AND products.ID=cat_prod.PROD_ID ORDER BY INV_NUMBER