Database Queries

SELECT * FROM `lang` WHERE url = 'en'

SHOW FULL COLUMNS FROM `lang`

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` = 'lang' AND `kcu`.`TABLE_NAME` = 'lang'

(SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `translate_source_message` `t1`, `translate_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='shop') AND (`t2`.`language`='en_EN')) UNION ALL ( SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `translate_source_message` `t1`, `translate_message` `t2` WHERE ((`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='shop') AND (`t2`.`language`='en')) AND (`t2`.`id` NOT IN (SELECT `id` FROM `translate_message` WHERE `language`='en_EN')) )

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `company_contacts`

SHOW FULL COLUMNS FROM `company_contacts`

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` = 'company_contacts' AND `kcu`.`TABLE_NAME` = 'company_contacts'

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE id != 9

SELECT * FROM `currencies` WHERE `exchange_rate` IS NOT NULL

SHOW FULL COLUMNS FROM `currencies`

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` = 'currencies' AND `kcu`.`TABLE_NAME` = 'currencies'

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `file_storage` WHERE `id`='2b752f3d7aab4c4f71ecc6d4226fc3e7-1653937858.8962'

SHOW FULL COLUMNS FROM `file_storage`

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` = 'file_storage' AND `kcu`.`TABLE_NAME` = 'file_storage'

(SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `translate_source_message` `t1`, `translate_message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='app') AND (`t2`.`language`='en_EN')) UNION ALL ( SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `translate_source_message` `t1`, `translate_message` `t2` WHERE ((`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='app') AND (`t2`.`language`='en')) AND (`t2`.`id` NOT IN (SELECT `id` FROM `translate_message` WHERE `language`='en_EN')) )

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `currencies` WHERE `is_default`=1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `menus` WHERE `code`='top_menu'

SHOW FULL COLUMNS FROM `menus`

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` = 'menus' AND `kcu`.`TABLE_NAME` = 'menus'

SELECT * FROM `menu_items` WHERE `menu_id`=3

SHOW FULL COLUMNS FROM `menu_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` = 'menu_items' AND `kcu`.`TABLE_NAME` = 'menu_items'

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=6

SHOW FULL COLUMNS FROM `menu_item_langs`

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` = 'menu_item_langs' AND `kcu`.`TABLE_NAME` = 'menu_item_langs'

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=7

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=8

SELECT * FROM `top_banners` WHERE `status`=1 ORDER BY `sort` DESC

SHOW FULL COLUMNS FROM `top_banners`

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` = 'top_banners' AND `kcu`.`TABLE_NAME` = 'top_banners'

SELECT * FROM `file_storage` WHERE `id`='c36a3007d51e8c79288c37fa3c53cc3b-1653651632.9782'

SELECT * FROM `file_storage` WHERE `id`='f05b3ccb0ea7fbbb14c4c073da54b67d-1654001571.0239'

SELECT * FROM `top_banner_langs` WHERE `top_banner_id`=8

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `manufacturer`

SHOW FULL COLUMNS FROM `manufacturer`

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` = 'manufacturer' AND `kcu`.`TABLE_NAME` = 'manufacturer'

SELECT * FROM `file_storage` WHERE `id`='ab3f1d647cc645522e1a4eb12bb61598-1592550824.8948'

SELECT * FROM `file_storage` WHERE `id`='a416fbbcd135d6ecb55c2efd9ab2dcbb-1592550872.4732'

SELECT * FROM `file_storage` WHERE `id`='6c0b4eaeee5fbd396a094f33bf16cf29-1592550908.5516'

SELECT * FROM `file_storage` WHERE `id`='92f8835bb6d8aab017ebb17d434d428d-1592552095.2681'

SELECT * FROM `file_storage` WHERE `id`='0683a4e96e9b8ffb110cd7f69ad2a3c3-1592552167.2648'

SELECT * FROM `file_storage` WHERE `id`=''

SELECT * FROM `file_storage` WHERE `id`='99b0ab22b9506c6c4d17da1950649d6a-1586594818.2509'

SELECT * FROM `file_storage` WHERE `id`='1372586e304cb328af8ef43ccb54b6a5-1586594789.657'

SELECT * FROM `file_storage` WHERE `id`='60de62ed877be54e300168ed8e2aea64-1603624974.6457'

SELECT * FROM `company_contacts`

SELECT * FROM `company_contacts_langs` WHERE `company_contact_id`=1

SHOW FULL COLUMNS FROM `company_contacts_langs`

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` = 'company_contacts_langs' AND `kcu`.`TABLE_NAME` = 'company_contacts_langs'

SELECT * FROM `company_contacts_social_networks`

SHOW FULL COLUMNS FROM `company_contacts_social_networks`

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` = 'company_contacts_social_networks' AND `kcu`.`TABLE_NAME` = 'company_contacts_social_networks'

SELECT * FROM `file_storage` WHERE `id`='2b752f3d7aab4c4f71ecc6d4226fc3e7-1653937858.8962'

SELECT * FROM `menus` WHERE `code`='bottom_left_menu'

SELECT * FROM `menu_items` WHERE `menu_id`=2

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=3

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=4

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=5

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=14

SELECT * FROM `menu_langs` WHERE `menu_id`=2

SHOW FULL COLUMNS FROM `menu_langs`

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` = 'menu_langs' AND `kcu`.`TABLE_NAME` = 'menu_langs'

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `menus` WHERE `code`='bottom_right_menu'

SELECT * FROM `menu_items` WHERE `menu_id`=4

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=10

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=11

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=12

SELECT * FROM `menu_item_langs` WHERE `menu_item_id`=13

SELECT * FROM `menu_langs` WHERE `menu_id`=4

SELECT * FROM `company_contacts`

SELECT * FROM `company_contacts_langs` WHERE `company_contact_id`=1

SELECT * FROM `lang` WHERE `default` = 1

SELECT * FROM `lang` WHERE `default` = 1