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

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

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

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

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

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

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

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

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

Page processing time: 0.019577 seconds