SELECT t.id, title,hasimage, shorttitle,company, localthumb,Price,link,company,item_id,frontpageview,substring(body,1,65) as bod,url FROM Webcam as t LEFT JOIN usercompares as c ON c.item_id = t.id AND c.section='Webcam' AND c.user_id = '0' WHERE live = 1 AND Megapixels = '1.3' AND Megapixelstype = 'megapixel' ORDER BY t.added DESC LIMIT 20 My Next - Megapixels 1.3megapixel