Database

SHOW FULL COLUMNS FROM `q_contact`

SHOW CREATE TABLE `q_contact`

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

SELECT * FROM `q_contact` WHERE `id`=91

SELECT `sit`.* FROM `q_information` `sit` LEFT JOIN `q_contact` `c` ON `sit`.`id` = `c`.`site_id` WHERE `sit`.`id`=91 LIMIT 1

SHOW FULL COLUMNS FROM `q_information`

SHOW CREATE TABLE `q_information`

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

SELECT * FROM `q_contact` `c` WHERE `site_id`=91

SELECT ST_X('\0\0\0\0

\0\0\0�=wE�K@���\Z�B@') as lat, ST_Y('\0\0\0\0

\0\0\0�=wE�K@���\Z�B@') as lon

SELECT * FROM `q_contact` WHERE `site_id`=91 LIMIT 1

SELECT * FROM `q_contact` WHERE `site_id`=91

SELECT * FROM `q_contact` WHERE `site_id`=91

SELECT ST_AsText('\0\0\0\0

\0\0\0�=wE�K@���\Z�B@') as point

SELECT ST_AsText('\0\0\0\0

\0\0\0�=wE�K@���\Z�B@') as point

SELECT * FROM `shop_discounts` WHERE `status` > 2 ORDER BY `sort`

SHOW FULL COLUMNS FROM `shop_discounts`

SHOW CREATE TABLE `shop_discounts`

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

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3)

SHOW FULL COLUMNS FROM `shop_razdels`

SHOW CREATE TABLE `shop_razdels`

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

SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) ORDER BY `lft`

SHOW FULL COLUMNS FROM `content_pages`

SHOW CREATE TABLE `content_pages`

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

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=3)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=4)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=6)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=11)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=12)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=13)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=14)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=15)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=16)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=17)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=18)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=19)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=23)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=24)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=25)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=26)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=27)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=28)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=29)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=30)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=31)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=32)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=33)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=36)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=40)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=42)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=43)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=44)

SELECT * FROM `shop_razdels` `rzd` WHERE (`rzd`.`site_id` = 91) AND (`rzd`.`status` >= 3) AND (`rzd`.`id`=53)

SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) AND (`pag`.`id`=4) ORDER BY `lft`

SELECT * FROM `content_pages` WHERE ((`lft` < 2) AND (`rgt` > 3)) AND (`tree`=91) AND (`status` > 0) ORDER BY `lft`

SELECT * FROM `content_pages` `pag` WHERE (`pag`.`site_id` = 91) AND (`pag`.`status` >= 3) AND (`pag`.`id`=10) ORDER BY `lft`

SELECT * FROM `content_pages` WHERE ((`lft` < 4) AND (`rgt` > 5)) AND (`tree`=91) AND (`status` > 0) ORDER BY `lft`