Database

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

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 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 (3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 36, 37, 38, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65)

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` IN (1, 3)

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 EXISTS(SELECT * FROM `carts` WHERE (`session_id`='') AND (`item_id`=3))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM `catalogue_categories`

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