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 OFFSET 600

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 (761, 762, 763, 764, 765, 766, 767, 768, 769, 770, 771, 772, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782)

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`=10

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM `catalogue_categories`

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