Exception: Error: Unknown column 'pt.image' in 'field list'
Error No: 1054
SELECT pt.*,p.*,pd.name,p.length as lengther,pt.length as length,p.price as default_price,pt.price as stock_price, pt.markup as markuper, pt.discount as discounter, pt.image as `stock_image` FROM dd_stock_product pt LEFT JOIN dd_product p ON pt.product_id = p.product_id LEFT JOIN dd_product_description pd ON p.product_id = pd.product_id WHERE p.status = '1' AND pt.status = '1' AND pt.price > 0 AND p.date_available <= NOW() AND pd.language_id = '1' AND pt.type IN ('Studded Jewellery','Mounts') AND pt.certificate !='' AND pt.price between 0.97087378640777 AND 48543.689320388 GROUP BY pt.product_id,pt.stone,pt.shape,pt.carat,pt.color,pt.clarity,pt.cut,pt.certificate,pt.metal,pt.ring_size ORDER BY p.sold DESC LIMIT 0,24 in /var/www/html/vernive.com/system/library/db/mysqli.php on line 48