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

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 (378, 379, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437)

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`=378))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM `catalogue_categories`

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