Database Queries

SELECT * FROM languages WHERE visible=1 ORDER BY sort_order

SELECT MAX(updated_at) FROM languages

SELECT MAX(updated_at) FROM languages

SHOW FULL COLUMNS FROM `redirects`

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

SELECT * FROM `redirects` WHERE `from`='/uk/krupnyj-opt'

SELECT EXISTS(SELECT * FROM `aliases` WHERE `alias`='/uk/krupnyj-opt')

SELECT `id` FROM `page` WHERE (`catalogue`=1) AND (`visible`=1)

SELECT `alias`, `controller`, `primaryKey` FROM `aliases` WHERE (`redirectID`=0) AND (`primaryKey`='3') AND (`model`='app\\modules\\page\\models\\Page')

SELECT `alias`, `controller`, `primaryKey`, `model` FROM `aliases` WHERE (`redirectID`=0) AND (`model` IN ('common\\models\\withdrawal\\MultiCategory', 'app\\modules\\shop\\models\\Showcase'))

SELECT `a`.`alias`, `a`.`controller`, `a`.`primaryKey`, `a`.`model` FROM `aliases` `a` LEFT JOIN `category` `c` ON a.primaryKey=c.id WHERE (`redirectID`=0) AND (`c`.`object`='app\\modules\\shop\\models\\Product') AND (`model`='app\\modules\\main\\models\\Category')

SELECT `retail`, `wholesale`, `dropshipping` FROM `social_visible_price` WHERE `alias`='uk/krupnyj-opt'

SELECT `model`, `redirectID`, `primaryKey`, `controller`, `status` FROM aliases WHERE alias='/krupnyj-opt'

SELECT * FROM `shop_currency` WHERE `main_in_shop`=1

SHOW FULL COLUMNS FROM `shop_currency`

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

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

SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1

SELECT * FROM `shop_currency` WHERE `main`=1

SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1

SELECT `id` FROM `shop_prices` WHERE `base_price`=1

SHOW FULL COLUMNS FROM `shop_multi_category`

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

SELECT * FROM `shop_multi_category` WHERE `id`='9'

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

SELECT * FROM `shop_multi_category_lang` WHERE (`language`='uk') AND (`owner_id`=9)

SELECT * FROM `shop_construct_product` WHERE `id`=14

SHOW FULL COLUMNS FROM `shop_construct_product`

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

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

SELECT * FROM `shop_construct_product_lang` WHERE (`language`='uk') AND (`owner_id`=14)

SELECT `id` FROM `user_type` WHERE `is_default_for_view`=1

SELECT EXISTS(SELECT * FROM `shop_construct_user_type` WHERE `construct_id`=14)

SELECT * FROM `shop_construct_default_colors` WHERE `construct_id`=14

SELECT * FROM `shop_attributes_list` WHERE 0=1 ORDER BY `sort_order`

SELECT EXISTS(SELECT * FROM `shop_construct_product_attribute` WHERE `construct_id`=14)

SHOW FULL COLUMNS FROM `shop_product`

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

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

SELECT `price_id` FROM `user_type` WHERE `is_default_for_view`=1

SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `source_message` `t1`, `message` `t2` WHERE (`t1`.`id`=`t2`.`id`) AND (`t1`.`category`='app') AND (`t2`.`language`='uk')

SELECT `mgt`.`title` AS `groupName`, `mct`.`title` AS `text`, `a`.`alias` AS `url`, `mg`.`position_relative_catalog` AS `position`, `mc`.`position_relative_catalog` AS `position_category`, `mc`.`sorting_by_category` AS `sort_order`, `mc`.`sort_order` AS `sort_order_with_group`, `mg`.`sort_order` AS `sort_order_group`, `mc`.`image_in_menu` AS `image`, `mc`.`construct_id` AS `construct_id` FROM `shop_multi_category` `mc` LEFT JOIN `shop_multi_category_lang` `mct` ON mc.id=mct.owner_id AND mct.language='uk' LEFT JOIN `shop_multi_category_group` `mg` ON mc.group_id=mg.id LEFT JOIN `shop_multi_category_group_lang` `mgt` ON mg.id=mgt.owner_id AND mgt.language='uk' LEFT JOIN `aliases` `a` ON mc.id=a.primaryKey AND a.model='common\\models\\withdrawal\\MultiCategory' AND a.redirectID=0 WHERE (`mc`.`show_in_filter`=1) AND (`mc`.`visible`=1) GROUP BY `mc`.`id` ORDER BY `mg`.`sort_order`, `sort_order_with_group`

SELECT * FROM `shop_construct_product` WHERE `id`='27'

SELECT * FROM `shop_construct_product_lang` WHERE (`language`='uk') AND (`owner_id`=27)

SELECT EXISTS(SELECT * FROM `shop_construct_user_type` WHERE `construct_id`=27)

SELECT * FROM `shop_construct_product` WHERE `id`='29'

SELECT * FROM `shop_construct_product_lang` WHERE (`language`='uk') AND (`owner_id`=29)

SELECT EXISTS(SELECT * FROM `shop_construct_user_type` WHERE `construct_id`=29)

SELECT * FROM `shop_construct_product` WHERE `id`='13'

SELECT * FROM `shop_construct_product_lang` WHERE (`language`='uk') AND (`owner_id`=13)

SELECT EXISTS(SELECT * FROM `shop_construct_user_type` WHERE `construct_id`=13)

SELECT * FROM `shop_construct_product` WHERE `id`='14'

SELECT * FROM `shop_construct_product_lang` WHERE (`language`='uk') AND (`owner_id`=14)

SELECT EXISTS(SELECT * FROM `shop_construct_user_type` WHERE `construct_id`=14)

SELECT * FROM `shop_construct_product` WHERE `id`='4'

SELECT * FROM `shop_construct_product_lang` WHERE (`language`='uk') AND (`owner_id`=4)

SELECT EXISTS(SELECT * FROM `shop_construct_user_type` WHERE `construct_id`=4)

SELECT * FROM `shop_construct_product` WHERE `id`='10'

SELECT * FROM `shop_construct_product_lang` WHERE (`language`='uk') AND (`owner_id`=10)

SELECT EXISTS(SELECT * FROM `shop_construct_user_type` WHERE `construct_id`=10)

SELECT `primaryKey` FROM `aliases` WHERE (`model`='app\\modules\\main\\models\\Category') AND (`alias`='/uk/krupnyj-opt')

SHOW FULL COLUMNS FROM `category`

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

SELECT * FROM `category` WHERE `id`=FALSE

SELECT `t`.`id`, `t`.`parent_id`, `tlang`.`title`, `t`.`image`, `t`.`sort_order` FROM `category` `t` LEFT JOIN `category_lang` `tlang` ON tlang.owner_id=t.id WHERE (`tlang`.`language`='uk') AND (`t`.`object`='app\\modules\\shop\\models\\Product') AND (`visible`=1) ORDER BY `t`.`draft`, `t`.`sort_order`

SELECT * FROM `category` WHERE `id`='6'

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

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=6)

SELECT * FROM `category` WHERE `id`='9'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=9)

SELECT * FROM `category` WHERE `id`='38'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=38)

SELECT * FROM `category` WHERE `id`='3'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=3)

SELECT * FROM `category` WHERE `id`='13'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=13)

SELECT * FROM `category` WHERE `id`='5'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=5)

SELECT * FROM `category` WHERE `id`='1'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=1)

SELECT * FROM `category` WHERE `id`='42'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=42)

SELECT * FROM `category` WHERE `id`='40'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=40)

SELECT * FROM `category` WHERE `id`='39'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=39)

SELECT * FROM `category` WHERE `id`='41'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=41)

SELECT * FROM `category` WHERE `id`='22'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=22)

SELECT * FROM `category` WHERE `id`='31'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=31)

SELECT * FROM `category` WHERE `id`='15'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=15)

SELECT * FROM `category` WHERE `id`='2'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=2)

SELECT * FROM `category` WHERE `id`='8'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=8)

SELECT * FROM `category` WHERE `id`='43'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=43)

SELECT `id` FROM `page` WHERE (`catalogue`=1) AND (`visible`=1)

SELECT `alias`, `controller`, `primaryKey` FROM `aliases` WHERE (`redirectID`=0) AND (`primaryKey`='3') AND (`model`='app\\modules\\page\\models\\Page')

SELECT `alias`, `controller`, `primaryKey`, `model` FROM `aliases` WHERE (`redirectID`=0) AND (`model` IN ('common\\models\\withdrawal\\MultiCategory', 'app\\modules\\shop\\models\\Showcase'))

SELECT `a`.`alias`, `a`.`controller`, `a`.`primaryKey`, `a`.`model` FROM `aliases` `a` LEFT JOIN `category` `c` ON a.primaryKey=c.id WHERE (`redirectID`=0) AND (`c`.`object`='app\\modules\\shop\\models\\Product') AND (`model`='app\\modules\\main\\models\\Category')

SELECT `id` FROM `page` WHERE (`catalogue`=1) AND (`visible`=1)

SELECT `alias`, `controller`, `primaryKey` FROM `aliases` WHERE (`redirectID`=0) AND (`primaryKey`='3') AND (`model`='app\\modules\\page\\models\\Page')

SELECT `alias`, `controller`, `primaryKey`, `model` FROM `aliases` WHERE (`redirectID`=0) AND (`model` IN ('common\\models\\withdrawal\\MultiCategory', 'app\\modules\\shop\\models\\Showcase'))

SELECT `a`.`alias`, `a`.`controller`, `a`.`primaryKey`, `a`.`model` FROM `aliases` `a` LEFT JOIN `category` `c` ON a.primaryKey=c.id WHERE (`redirectID`=0) AND (`c`.`object`='app\\modules\\shop\\models\\Product') AND (`model`='app\\modules\\main\\models\\Category')

SELECT * FROM `category` WHERE `id`='7'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=7)

SELECT * FROM `category` WHERE `id`='17'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=17)

SELECT * FROM `category` WHERE `id`='12'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=12)

SELECT * FROM `category` WHERE `id`='25'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=25)

SELECT * FROM `category` WHERE `id`='27'

SELECT * FROM `category_lang` WHERE (`language`='uk') AND (`owner_id`=27)

SELECT * FROM `shop_currency` WHERE `main_in_shop`=1

SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1

SELECT * FROM `shop_currency` WHERE `main`=1

SELECT * FROM `shop_currency_lang` WHERE `owner_id`=1

SELECT COUNT(*) FROM (SELECT `main`.`id`, `main`.`article`, `main`.`sort_order`, `lang`.`title` AS `selectTitle`, `lang`.`description` AS `selectDescription`, `category_lang`.`owner_id` AS `selectCategoryId`, `category_lang`.`title` AS `selectCategoryTitle`, `main`.`created_at` AS `created_at`, `pp`.`value` AS `typePrice`, CASE WHEN SUM(ps.quantity) > 0 THEN 1 ELSE 0 END AS `storeCount` FROM `shop_product` `main` LEFT JOIN `category_lang` `category_lang` ON main.parent_id=category_lang.owner_id LEFT JOIN `shop_product_lang` `lang` ON lang.owner_id=main.id LEFT JOIN `shop_product_prices` `pp` ON main.id=pp.product_id AND pp.price_id='1' LEFT JOIN `shop_product_prices` `ppr` ON main.id=ppr.product_id AND ppr.price_id=1 LEFT JOIN `shop_product_store` `ps` ON main.id=ps.product_id LEFT JOIN (SELECT `p`.`id`, SUM(ps.quantity) AS `sum`, `sum` AS `order` FROM `shop_product` `p` LEFT JOIN `shop_product_store` `ps` ON p.id=ps.product_id WHERE `p`.`visible`=1 GROUP BY `p`.`id` HAVING `sum` >= 50) subProductQuery ON subProductQuery.id=main.id WHERE ((`main`.`visible`=1) AND (`lang`.`language`='uk') AND (`category_lang`.`language`='uk')) AND (main.id IN (subProductQuery.id)) GROUP BY `main`.`id` ORDER BY `storeCount` DESC) `sub`