Home
In Stock at Bearhills
Did not retrieve rows. SELECT
CASE
WHEN categories_description.categories_name LIKE '%Cake%' THEN '1Cake'
WHEN categories_description.categories_name LIKE '%Smoke%' THEN '2Smoke'
WHEN categories_description.categories_name LIKE '%Sky%' THEN '3Sky'
WHEN categories_description.categories_name LIKE '%Spark%' THEN '4Sparks'
WHEN categories_description.categories_name LIKE '%Barr%' THEN '5Barrage'
WHEN categories_description.categories_name LIKE '%Bang%' THEN '6Bangers'
WHEN categories_description.categories_name LIKE '%Kit%' THEN '7Kits'
ELSE '99'
END catsort,
products.products_price,
products_description.products_name name,
FORMAT(products.products_price, 2) price,
CASE
WHEN categories_description.categories_name LIKE '%Cake%' THEN 'Cakes'
WHEN categories_description.categories_name LIKE '%Sky%' THEN 'SkyShells'
WHEN categories_description.categories_name LIKE '%Spark%' THEN 'Sparks'
WHEN categories_description.categories_name LIKE '%Barr%' THEN 'Barrages'
WHEN categories_description.categories_name LIKE '%Bang%' THEN 'Bangers'
WHEN categories_description.categories_name LIKE '%Smoke%' THEN 'Smoke'
WHEN categories_description.categories_name LIKE '%Kit%' THEN 'Kits'
ELSE '99'
END category,
products_description.products_url url,
products.products_image 'image',
products.products_id,
products.products_quantity/OrderParameters.desired ratio
FROM
products,
products_description,
categories_description,
manufacturers,
OrderParameters
WHERE
products.products_id = products_description.products_id
AND products.manufacturers_id = manufacturers.manufacturers_id
AND products.products_quantity >= 1
AND OrderParameters.desired >= 0
AND products.master_categories_id = categories_description.categories_id
AND products.products_id = OrderParameters.products_id
AND (categories_description.categories_name LIKE '%Cake%'
OR categories_description.categories_name LIKE '%Spark%'
OR categories_description.categories_name LIKE '%Barr%'
OR categories_description.categories_name LIKE '%Bang%'
OR categories_description.categories_name LIKE '%Smoke%'
OR categories_description.categories_name LIKE '%Kit%'
OR categories_description.categories_name LIKE '%Sky%')
AND products.products_id NOT IN (SELECT products_id from NotThese)
AND products_description.products_name NOT LIKE '%Goggles%'
ORDER BY
1, 2 DESC, 3
;