Unknown column 'cc.picture' in 'field list' SQL query : SELECT p.*, cc.picture `brand_logo`, cc.name `brand_name`, c.picture, c.season_type, c.disc_type, c.url as cat_url FROM (SELECT * FROM ss_products WHERE product_type in (1) and categoryID is not null and categoryID != 1) p LEFT JOIN ss_categories c ON (c.categoryID = p.categoryID) WHERE p.special_price='1' ORDER BY p.special_price DESC LIMIT 0, 9