papacico Posted June 20, 2014 Share Posted June 20, 2014 Hi, is there a way to get a products list of products with no picture trough a sql query? Thanks Link to comment Share on other sites More sharing options...
webdev0008 Posted June 20, 2014 Share Posted June 20, 2014 Hi Use this SELECT id_product FROM `ps_product` WHERE id_product not in (select id_product from ps_image) Link to comment Share on other sites More sharing options...
papacico Posted June 20, 2014 Author Share Posted June 20, 2014 thank webdev it works, great ! Link to comment Share on other sites More sharing options...
vekia Posted June 22, 2014 Share Posted June 22, 2014 than kyou for sharing this nie sql snippet i marked your answer as a solution and also whole topic as solved with regards, Milos Link to comment Share on other sites More sharing options...
Recommended Posts