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 * FROM `categories` WHERE `slug`='18231-black-star'

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

SELECT * FROM `categories` ORDER BY `parent_id`

SELECT * FROM `prices` WHERE `auth_item_name`=''

SHOW FULL COLUMNS FROM `prices`

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

SELECT `products`.`id`, IF(MAX(products_variants.amount_in_storage) > 0, 1, 0) AS `isAvailableInStorage`, MIN(products_variant_prices.value) AS `price` FROM `products` INNER JOIN `products_variants` ON `products`.`id` = `products_variants`.`product_id` INNER JOIN `products_variant_prices` ON `products_variants`.`id` = `products_variant_prices`.`variant_id` WHERE (`category_id`=51) AND (`products_variants`.`amount_in_storage` > 0) GROUP BY `products`.`id` ORDER BY `price` DESC

SHOW FULL COLUMNS FROM `products`

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

SELECT `products_variants`.* FROM `products_variants` INNER JOIN `products_variant_prices` ON `products_variants`.`id` = `products_variant_prices`.`variant_id` WHERE `products_variants`.`product_id`=180

SHOW FULL COLUMNS FROM `products_variants`

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

SELECT * FROM `products_variant_prices` WHERE `variant_id`=141

SHOW FULL COLUMNS FROM `products_variant_prices`

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

SELECT * FROM `prices` WHERE `auth_item_name`=''

SELECT `products`.`id`, IF(MAX(products_variants.amount_in_storage) > 0, 1, 0) AS `isAvailableInStorage`, MIN(products_variant_prices.value) AS `price` FROM `products` INNER JOIN `products_variants` ON `products`.`id` = `products_variants`.`product_id` INNER JOIN `products_variant_prices` ON `products_variants`.`id` = `products_variant_prices`.`variant_id` WHERE `category_id`=51 GROUP BY `products`.`id` HAVING `isAvailableInStorage` < 1 ORDER BY `price` DESC

SELECT * FROM `prices` WHERE `auth_item_name`=''

SELECT `products`.`id`, IF(MAX(products_variants.amount_in_storage) > 0, 1, 0) AS `isAvailableInStorage`, MIN(products_variant_prices.value) AS `price` FROM `products` INNER JOIN `products_variants` ON `products`.`id` = `products_variants`.`product_id` INNER JOIN `products_variant_prices` ON `products_variants`.`id` = `products_variant_prices`.`variant_id` WHERE (`category_id`=51) AND (`products_variants`.`amount_in_storage` > 0) GROUP BY `products`.`id` ORDER BY `price`

SELECT `products_variants`.* FROM `products_variants` INNER JOIN `products_variant_prices` ON `products_variants`.`id` = `products_variant_prices`.`variant_id` WHERE `products_variants`.`product_id`=180

SELECT * FROM `products_variant_prices` WHERE `variant_id`=141

SELECT * FROM `prices` WHERE `auth_item_name`=''

SELECT `products`.`id`, IF(MAX(products_variants.amount_in_storage) > 0, 1, 0) AS `isAvailableInStorage`, MIN(products_variant_prices.value) AS `price` FROM `products` INNER JOIN `products_variants` ON `products`.`id` = `products_variants`.`product_id` INNER JOIN `products_variant_prices` ON `products_variants`.`id` = `products_variant_prices`.`variant_id` WHERE `category_id`=51 GROUP BY `products`.`id` HAVING `isAvailableInStorage` < 1 ORDER BY `price`

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

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 `currencies` WHERE `is_default`=1

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

SELECT * FROM `prices` WHERE `auth_item_name`=''

SELECT COUNT(*) FROM (SELECT `products`.*, IF(MAX(products_variants.amount_in_storage) > 0, 1, 0) AS `isAvailableInStorage`, IF(MAX(products_variants.amount_in_storage) = 0, MIN(products_variant_prices.value), MIN(CASE WHEN products_variants.amount_in_storage > 0 THEN products_variant_prices.value END)) AS `price`, `product_langs`.`name` AS `name` FROM `products` INNER JOIN `products_variants` ON `products`.`id` = `products_variants`.`product_id` INNER JOIN `products_variant_prices` ON `products_variants`.`id` = `products_variant_prices`.`variant_id` INNER JOIN `product_langs` ON `products`.`id` = `product_langs`.`product_id` WHERE (`category_id`=51) AND (`products_variant_prices`.`price_id`=2) AND (`products_variants`.`is_filled_options`=1) AND (`activity`=1) GROUP BY `products`.`id`, `product_langs`.`name`) `c`

(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 `category_langs` WHERE `category_id`=51

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

SELECT * FROM `countries` WHERE (`id` IS NULL) AND (`exists_tax`=1)

SELECT COUNT(*) FROM (SELECT `products`.*, IF(MAX(products_variants.amount_in_storage) > 0, 1, 0) AS `isAvailableInStorage`, IF(MAX(products_variants.amount_in_storage) = 0, MIN(products_variant_prices.value), MIN(CASE WHEN products_variants.amount_in_storage > 0 THEN products_variant_prices.value END)) AS `price`, `product_langs`.`name` AS `name` FROM `products` INNER JOIN `products_variants` ON `products`.`id` = `products_variants`.`product_id` INNER JOIN `products_variant_prices` ON `products_variants`.`id` = `products_variant_prices`.`variant_id` INNER JOIN `product_langs` ON `products`.`id` = `product_langs`.`product_id` WHERE (`category_id`=51) AND (`products_variant_prices`.`price_id`=2) AND (`products_variants`.`is_filled_options`=1) AND (`activity`=1) GROUP BY `products`.`id`, `product_langs`.`name`) `c`

SELECT `products`.*, IF(MAX(products_variants.amount_in_storage) > 0, 1, 0) AS `isAvailableInStorage`, IF(MAX(products_variants.amount_in_storage) = 0, MIN(products_variant_prices.value), MIN(CASE WHEN products_variants.amount_in_storage > 0 THEN products_variant_prices.value END)) AS `price`, `product_langs`.`name` AS `name` FROM `products` INNER JOIN `products_variants` ON `products`.`id` = `products_variants`.`product_id` INNER JOIN `products_variant_prices` ON `products_variants`.`id` = `products_variant_prices`.`variant_id` INNER JOIN `product_langs` ON `products`.`id` = `product_langs`.`product_id` WHERE (`category_id`=51) AND (`products_variant_prices`.`price_id`=2) AND (`products_variants`.`is_filled_options`=1) AND (`activity`=1) GROUP BY `products`.`id`, `product_langs`.`name` LIMIT 15

SELECT `products_variants`.* FROM `products_variants` INNER JOIN `products_variant_prices` ON `products_variants`.`id` = `products_variant_prices`.`variant_id` WHERE `products_variants`.`product_id`=180

SELECT * FROM `products_variant_prices` WHERE `variant_id`=141

SELECT * FROM `product_langs` WHERE `product_id`=180

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

SELECT * FROM `products_discounts` WHERE `product_id`=180

SELECT * FROM `discounts` WHERE 0=1

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

SELECT `file_storage`.* FROM `file_storage` INNER JOIN `products_filestorage` ON products_filestorage.id_file = file_storage.id WHERE `products_filestorage`.`id_product`=180 ORDER BY `products_filestorage`.`id`

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 * FROM `products_variants` WHERE `product_id`=180

SELECT * FROM `prices` WHERE `auth_item_name`=''

SELECT MIN(value) FROM `products_variant_prices` WHERE (`price_id`=2) AND (`variant_id`=141)

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

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

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

SELECT * FROM `reviews` WHERE `product_id`=180

SELECT * FROM `product_langs` WHERE `product_id`=180

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

SELECT `discount_id` FROM `products_discounts` WHERE `product_id`=180

SELECT * FROM `discounts` WHERE (0=1) AND (started_at IS NULL OR started_at <= NOW()) AND (finished_at IS NULL OR finished_at >= NOW())

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

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

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

SELECT * FROM `units` WHERE `id`=1

SHOW FULL COLUMNS FROM `units`

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

SELECT * FROM `unit_langs` WHERE `unit_id`=1

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

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

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

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

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

SELECT `discount_id` FROM `products_discounts` WHERE `product_id`=180

SELECT * FROM `discounts` WHERE (0=1) AND (started_at IS NULL OR started_at <= NOW()) AND (finished_at IS NULL OR finished_at >= NOW())

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

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

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

SELECT * FROM `features_products` WHERE `product_id`=180

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

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

SELECT * FROM `category_langs` WHERE `category_id`=25

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

SELECT * FROM `category_langs` WHERE `category_id`=26

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

SELECT * FROM `category_langs` WHERE `category_id`=46

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

SELECT * FROM `category_langs` WHERE `category_id`=57

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

SELECT * FROM `category_langs` WHERE `category_id`=47

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

SELECT * FROM `category_langs` WHERE `category_id`=48

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

SELECT * FROM `category_langs` WHERE `category_id`=49

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

SELECT * FROM `category_langs` WHERE `category_id`=50

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

SELECT * FROM `category_langs` WHERE `category_id`=51

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

SELECT * FROM `category_langs` WHERE `category_id`=52

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

SELECT * FROM `category_langs` WHERE `category_id`=53

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

SELECT * FROM `category_langs` WHERE `category_id`=54

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

SELECT * FROM `category_langs` WHERE `category_id`=55

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

SELECT * FROM `category_langs` WHERE `category_id`=56

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

SELECT * FROM `category_langs` WHERE `category_id`=32

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

SELECT * FROM `category_langs` WHERE `category_id`=29

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

SELECT * FROM `category_langs` WHERE `category_id`=30

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

SELECT * FROM `category_langs` WHERE `category_id`=28

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

SELECT * FROM `category_langs` WHERE `category_id`=45

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

SELECT * FROM `category_langs` WHERE `category_id`=27

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

SELECT * FROM `category_langs` WHERE `category_id`=31

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

SELECT * FROM `category_langs` WHERE `category_id`=33

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

SELECT * FROM `category_langs` WHERE `category_id`=34

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

SELECT * FROM `category_langs` WHERE `category_id`=35

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

SELECT * FROM `category_langs` WHERE `category_id`=36

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

SELECT * FROM `category_langs` WHERE `category_id`=37

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

SELECT * FROM `category_langs` WHERE `category_id`=38

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

SELECT * FROM `category_langs` WHERE `category_id`=39

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

SELECT * FROM `category_langs` WHERE `category_id`=40

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

SELECT * FROM `category_langs` WHERE `category_id`=41

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

SELECT * FROM `category_langs` WHERE `category_id`=42

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

SELECT * FROM `category_langs` WHERE `category_id`=43

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

SELECT * FROM `category_langs` WHERE `category_id`=44

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

SELECT * FROM `category_langs` WHERE `category_id`=84

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

SELECT * FROM `category_langs` WHERE `category_id`=85

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

SELECT * FROM `category_langs` WHERE `category_id`=86

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

SELECT * FROM `category_langs` WHERE `category_id`=87

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

SELECT * FROM `category_langs` WHERE `category_id`=88

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

SELECT * FROM `category_langs` WHERE `category_id`=89

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

SELECT * FROM `category_langs` WHERE `category_id`=81

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

SELECT * FROM `category_langs` WHERE `category_id`=82

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

SELECT * FROM `category_langs` WHERE `category_id`=83

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

SELECT * FROM `category_langs` WHERE `category_id`=72

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

SELECT * FROM `category_langs` WHERE `category_id`=80

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

SELECT * FROM `category_langs` WHERE `category_id`=79

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

SELECT * FROM `category_langs` WHERE `category_id`=78

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

SELECT * FROM `category_langs` WHERE `category_id`=77

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

SELECT * FROM `category_langs` WHERE `category_id`=76

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

SELECT * FROM `category_langs` WHERE `category_id`=75

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

SELECT * FROM `category_langs` WHERE `category_id`=74

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

SELECT * FROM `category_langs` WHERE `category_id`=73

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

SELECT * FROM `category_langs` WHERE `category_id`=69

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

SELECT * FROM `category_langs` WHERE `category_id`=70

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

SELECT * FROM `category_langs` WHERE `category_id`=71

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

SELECT * FROM `category_langs` WHERE `category_id`=65

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

SELECT * FROM `category_langs` WHERE `category_id`=67

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

SELECT * FROM `category_langs` WHERE `category_id`=66

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

SELECT * FROM `category_langs` WHERE `category_id`=68

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

SELECT * FROM `category_langs` WHERE `category_id`=58

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

SELECT * FROM `category_langs` WHERE `category_id`=59

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

SELECT * FROM `category_langs` WHERE `category_id`=60

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

SELECT * FROM `category_langs` WHERE `category_id`=61

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

SELECT * FROM `category_langs` WHERE `category_id`=62

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

SELECT * FROM `category_langs` WHERE `category_id`=63

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

SELECT * FROM `category_langs` WHERE `category_id`=64

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

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

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

(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 `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