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

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

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

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

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

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

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

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

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

Page processing time: 0.024456 seconds