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.00052499771118164

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

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

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

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

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.00065803527832031

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.00036787986755371

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.00048398971557617

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.00029206275939941

Page processing time: 0.014561 seconds