Weekly Special


SELECT * FROM catalogue,newcat WHERE newcat.newtype = 'Weekly Special' AND catalogue.cat_id= newcat.cat_id ORDER BY newcat.newnumber ASC