Home Page

Out of stock products

Category NameProduct NameQuantity Per Unit
CondimentsChef Anton's Gumbo Mix36 boxes
Meat/PoultryAlice Mutton20 - 1 kg tins
Meat/PoultryThüringer Rostbratwurst50 bags x 30 sausgs.
Dairy ProductsGorgonzola Telino12 - 100 g pkgs
Meat/PoultryPerth Pasties48 pieces

Discontinued products

Category NameProduct NameQuantity Per UnitUnits In Stock
CondimentsChef Anton's Gumbo Mix36 boxes0
Meat/PoultryMishi Kobe Niku18 - 500 g pkgs.29
Meat/PoultryAlice Mutton20 - 1 kg tins0
BeveragesGuaraná Fantástica12 - 355 ml cans20
ProduceRössle Sauerkraut25 - 825 g cans26
Meat/PoultryThüringer Rostbratwurst50 bags x 30 sausgs.0
Grains/CerealsSingaporean Hokkien Fried Mee32 - 1 kg pkgs.26
Meat/PoultryPerth Pasties48 pieces0

Debug

sql: SELECT COUNT(*) FROM userlevels WHERE userlevelid = -2, executionMS: 0.00049209594726562

sql: SELECT userlevelid, userlevelname FROM userlevels, executionMS: 0.00017499923706055

sql: SELECT COUNT(*) FROM userlevelpermissions WHERE userlevelid = -2, executionMS: 0.0002140998840332

sql: SELECT tablename, userlevelid, permission FROM userlevelpermissions WHERE userlevelid IN (-2), executionMS: 0.00034999847412109

sql: SHOW TABLE STATUS WHERE Engine = 'MyISAM' AND Name = 'employees', executionMS: 0.0012760162353516

sql: SELECT DISTINCT `categories`.`CategoryName` AS `CategoryName`,`products`.`ProductName` AS `ProductName`,`products`.`QuantityPerUnit` AS `QuantityPerUnit` FROM `categories` JOIN `products` ON (`categories`.`CategoryID` = `products`.`CategoryID`) WHERE `products`.`UnitsInStock` <= 0, executionMS: 0.00068807601928711

sql: SELECT DISTINCT `categories`.`CategoryName` AS `CategoryName`,`products`.`ProductName` AS `ProductName`,`products`.`QuantityPerUnit` AS `QuantityPerUnit` FROM `categories` JOIN `products` ON (`categories`.`CategoryID` = `products`.`CategoryID`) WHERE `products`.`UnitsInStock` <= 0, executionMS: 0.00040316581726074

sql: SELECT DISTINCT `categories`.`CategoryName` AS `CategoryName`,`products`.`ProductName` AS `ProductName`,`products`.`QuantityPerUnit` AS `QuantityPerUnit`,`products`.`UnitsInStock` AS `UnitsInStock` FROM `categories` JOIN `products` ON (`categories`.`CategoryID` = `products`.`CategoryID`) WHERE `products`.`Discontinued` = '1', executionMS: 0.00040388107299805

sql: SELECT DISTINCT `categories`.`CategoryName` AS `CategoryName`,`products`.`ProductName` AS `ProductName`,`products`.`QuantityPerUnit` AS `QuantityPerUnit`,`products`.`UnitsInStock` AS `UnitsInStock` FROM `categories` JOIN `products` ON (`categories`.`CategoryID` = `products`.`CategoryID`) WHERE `products`.`Discontinued` = '1', executionMS: 0.00039386749267578

Page processing time: 0.024776 seconds