Database

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

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`='parts')

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`='parts') 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 (732, 733, 734, 735, 736, 737, 738, 739, 740, 741, 742, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 753, 754, 755, 756, 757, 758, 759, 760, 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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