The query needed for 4.1 is probably
Code:
SELECT xcart_products.productid, xcart_products.product
FROM xcart_products
LEFT OUTER JOIN xcart_images_T ON xcart_products.productid = xcart_images_T.id
WHERE xcart_images_T.id IS NULL
ORDER BY add_date DESC
looks like xcart_thumbnails is an old table no longer used,
__________________
X-Cart version 5 (Previously 3.5-4)
Previous Versions included
BCSE Reward Points Mod
Altered Cart On Sale Mod
Wordpress Plugin
Please don't PM me for support. I help where I can on the forum and your question will more likely be answered there.
Shout me a Coffee!