Code: Select all
SELECT inventory.store_name, inventory.product_name, inventory.upload_date, uploads.thumb_path, products.search_hits, products.hits
FROM inventory, uploads, products
WHERE CAST(inventory.store_name AS CHAR CHARSET utf8) = 'My Store''s $tuff!'
AND products.product_name = uploads.product_name
AND products.id = uploads.id
ORDER BY inventory.upload_date DESCCode: Select all
store_name product_name upload_date thumb_path search_hits hits
>My Store's $tuff! Car 2004-12-25 12:07:42 members/Steveo31/car_thumb.jpg 2 2
>My Store's $tuff! Tools 2004-12-25 12:06:35 members/Steveo31/tools_thumb.jpg 0 1
>My Store's $tuff! Bread 2004-12-25 12:05:28 members/Steveo31/toaster_thumb.jpg 4 10Code: Select all
>My Store's $tuff! Car 2004-12-25 12:07:42 members/Steveo31/toaster_thumb.jpg 0 2
>My Store's $tuff! Car 2004-12-25 12:07:42 members/Steveo31/modelt_thumb.jpg 0 1
>My Store's $tuff! Car 2004-12-25 12:07:42 members/Steveo31/tools_thumb.jpg 0 1
>My Store's $tuff! Tools 2004-12-25 12:06:35 members/Steveo31/tools_thumb.jpg 0 1
>My Store's $tuff! Tools 2004-12-25 12:06:35 members/Steveo31/toaster_thumb.jpg 0 2
>My Store's $tuff! Tools 2004-12-25 12:06:35 members/Steveo31/modelt_thumb.jpg 0 1
>My Store's $tuff! Bread 2004-12-25 12:05:28 members/Steveo31/toaster_thumb.jpg 0 2
>My Store's $tuff! Bread 2004-12-25 12:05:28 members/Steveo31/modelt_thumb.jpg 0 1
>My Store's $tuff! Bread 2004-12-25 12:05:28 members/Steveo31/tools_thumb.jpg 0 1