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

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

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

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

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

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

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

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

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

Page processing time: 0.014593 seconds