Code: Select all
2011-10-08 16:05:08 - PHP Notice: Error: Unknown column 'accessoryimages' in 'IN/ALL/ANY subquery'<br />Error No: 1054<br />SELECT count(*) as qty, m.manufacturer_id, m.name FROM manufacturer m LEFT JOIN manufacturer_to_store m2s ON m2s.manufacturer_id = m.manufacturer_id LEFT JOIN product p ON p.manufacturer_id = m.manufacturer_id AND p.status = '1' LEFT JOIN product_discount pdis ON pdis.product_id = p.product_id AND pdis.customer_group_id = '8' and pdis.quantity <= '1' AND pdis.date_start <= NOW() AND pdis.date_end >= NOW() LEFT JOIN product_special ps ON ps.product_id = p.product_id AND ps.customer_group_id = '8' AND ps.date_start <= NOW() AND ps.date_end >= NOW() LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p2s.store_id = '0' AND m2s.store_id = '0' AND (accessoryimages/pythonfoldingmrc-hi.jpg IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 60 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 61 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 71 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 82 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 62 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 63 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 76 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 78 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 81 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 64 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 65 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 66 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 67 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 83 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 84 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 85 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 68 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 86 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 87 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 88 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 89 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 90 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 92 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 99 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 69 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 91 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 93 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 101 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 103 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 104 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 70 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 72 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 95 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 96 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 97 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 100 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 73 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 94 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 98 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 74 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 59 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id) OR 102 IN (SELECT category_id FROM product_to_category WHERE product_id = p.product_id)) GROUP BY m.manufacturer_id ORDER BY m.sort_order, m.name in /var/www/vhosts/my_live_site.co.uk/httpdocs/system/database/mysql.php on line 49