Database

SELECT * FROM `catalogue_categories` WHERE `slug`='pivobeers'

SHOW FULL COLUMNS FROM `catalogue_categories`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'catalogue_categories' AND `kcu`.`TABLE_NAME` = 'catalogue_categories'

SELECT COUNT(*) FROM `catalogue_items` LEFT JOIN `catalogue_items_to_categories` ON `catalogue_items`.`id` = `catalogue_items_to_categories`.`item_id` LEFT JOIN `catalogue_categories` ON `catalogue_items_to_categories`.`category_id` = `catalogue_categories`.`id` WHERE (`catalogue_items`.`is_active`=1) AND (`slug`='pivobeers')

SELECT `catalogue_items`.* FROM `catalogue_items` LEFT JOIN `catalogue_items_to_categories` ON `catalogue_items`.`id` = `catalogue_items_to_categories`.`item_id` LEFT JOIN `catalogue_categories` ON `catalogue_items_to_categories`.`category_id` = `catalogue_categories`.`id` WHERE (`catalogue_items`.`is_active`=1) AND (`slug`='pivobeers') ORDER BY `catalogue_items`.`id` LIMIT 60 OFFSET 60

SHOW FULL COLUMNS FROM `catalogue_items`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'catalogue_items' AND `kcu`.`TABLE_NAME` = 'catalogue_items'

SELECT `catalogue_items_to_categories`.* FROM `catalogue_items_to_categories` LEFT JOIN `catalogue_categories` ON `catalogue_items_to_categories`.`category_id` = `catalogue_categories`.`id` WHERE `catalogue_items_to_categories`.`item_id` IN (438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497)

SHOW FULL COLUMNS FROM `catalogue_items_to_categories`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'catalogue_items_to_categories' AND `kcu`.`TABLE_NAME` = 'catalogue_items_to_categories'

SELECT * FROM `catalogue_categories` WHERE `id`=9

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=438))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=439))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=440))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=441))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=442))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=443))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=444))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=445))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=446))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=447))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=448))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=449))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=450))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=451))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=452))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=453))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=454))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=455))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=456))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=457))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=458))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=459))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=460))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=461))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=462))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=463))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=464))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=465))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=466))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=467))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=468))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=469))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=470))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=471))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=472))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=473))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=474))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=475))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=476))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=477))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=478))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=479))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=480))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=481))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=482))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=483))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=484))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=485))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=486))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=487))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=488))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=489))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=490))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=491))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=492))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=493))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=494))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=495))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=496))

SELECT EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=497))

SELECT * FROM `catalogue_categories`

SELECT COUNT(*) FROM `carts` WHERE `session_id`=''