SELECT *, p.id as pid FROM products p, products_categories pc WHERE
pc.productid = p.id AND pc.categoryid = '1243' AND
p.valid=1 and ((p.display='Y') OR ((p.display='schedule') AND (p.scheduledate < NOW() ))) AND
((p.expires='N') OR ((p.expires='Y') AND (p.expiredate > NOW() ))) ORDER BY important,p.s_name LIMIT -8, 10