Code: Select all
SELECT inventory.store_name, inventory.product_name, inventory.upload_date, uploads.thumb_path, SUM(products.search_hits) as search_hits, SUM(products.hits) as hits FROM inventory, uploads, products WHERE inventory.store_name = 'Steve''s Store' AND products.product_name = uploads.product_name GROUP BY products.product_name ORDER BY inventory.upload_date DESCCode: Select all
Steve's Store Car 2005-01-04 14:11:34 members/Steveo31/toaster_thumb.jpg 0 9
Steve's Store Car 2005-01-04 14:11:34 members/Steveo31/modelt_thumb.jpg 0 9
Steve's Store Car 2005-01-04 14:11:34 members/Steveo31/tools_thumb.jpg 0 33Code: Select all
Steve's Store Toaster 2005-01-04 14:11:34 members/Steveo31/toaster_thumb.jpg 0 9
Steve's Store Car 2005-01-04 14:11:34 members/Steveo31/modelt_thumb.jpg 0 9
Steve's Store Tools 2005-01-04 14:11:34 members/Steveo31/tools_thumb.jpg 0 33