Database Queries

SELECT * FROM `url_meta` WHERE `path`='/blog/kakie-vizitki'

SHOW FULL COLUMNS FROM `post`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'post' AND kcu.table_name = 'post'

SELECT * FROM `post` WHERE `slug`='kakie-vizitki'

SELECT * FROM `post` WHERE `slug`='kakie-vizitki'

SELECT * FROM `meta` WHERE (`type`=2) AND (`parent_id`=31)

SHOW FULL COLUMNS FROM `meta`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'meta' AND kcu.table_name = 'meta'

SHOW FULL COLUMNS FROM `contact_info`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'contact_info' AND kcu.table_name = 'contact_info'

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

SELECT COUNT(*) FROM `post` WHERE `post_type`=1

SELECT * FROM `post` WHERE `post_type`=1 ORDER BY `created_at` DESC LIMIT 10

SELECT * FROM `category`

select sum(cnt) FROM ( SELECT count(id) cnt FROM service WHERE status = 10 UNION SELECT count(id) cnt FROM category ) t;

SHOW FULL COLUMNS FROM `category`

select sum(cnt) FROM ( SELECT count(id) cnt FROM service WHERE status = 10 UNION SELECT count(id) cnt FROM category ) t;

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 sum(cnt) FROM ( SELECT count(id) cnt FROM service WHERE status = 10 UNION SELECT count(id) cnt FROM category ) t;

SELECT * FROM `category` WHERE `parent_id`=0

select sum(cnt) FROM ( SELECT count(id) cnt FROM service WHERE status = 10 UNION SELECT count(id) cnt FROM category ) t;

SELECT * FROM `service`

select sum(cnt) FROM ( SELECT count(id) cnt FROM service WHERE status = 10 UNION SELECT count(id) cnt FROM category ) t;

SHOW FULL COLUMNS FROM `service`

select sum(cnt) FROM ( SELECT count(id) cnt FROM service WHERE status = 10 UNION SELECT count(id) cnt FROM category ) t;

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'service' AND kcu.table_name = 'service'

select sum(cnt) FROM ( SELECT count(id) cnt FROM service WHERE status = 10 UNION SELECT count(id) cnt FROM category ) t;

SELECT * FROM `post` WHERE ((`status`=10) AND (`post_type`=2)) AND (`main_menu`=TRUE) ORDER BY `position`

SELECT * FROM `post` WHERE `slug`='o-copycentre'

SELECT * FROM `post` WHERE `slug`='reviews'

SELECT * FROM `post` WHERE `slug`='blog'

SELECT * FROM `post` WHERE `slug`='korporativnym-klientam'

SELECT * FROM `post` WHERE `slug`='oplata'

SELECT * FROM `post` WHERE `slug`='garanty'

SELECT * FROM `post` WHERE `slug`='delivery'

SELECT * FROM `post` WHERE `slug`='equipment'

SELECT * FROM `post` WHERE `slug`='contacts'

SELECT * FROM `category` ORDER BY `main_menu_order`

SELECT * FROM `category` WHERE `slug`='pechat'

SELECT * FROM `service` WHERE (place != 3) AND (`category_id`=2) ORDER BY `main_menu_order`

SELECT * FROM `category` WHERE `slug`='polygraphy'

SELECT * FROM `service` WHERE (place != 3) AND (`category_id`=3) ORDER BY `main_menu_order`

SELECT * FROM `category` WHERE `slug`='photouslugi'

SELECT * FROM `service` WHERE (place != 3) AND (`category_id`=6) ORDER BY `main_menu_order`

SELECT * FROM `category` WHERE `slug`='tipographia'

SELECT * FROM `service` WHERE (place != 3) AND (`category_id`=4) ORDER BY `main_menu_order`

SELECT * FROM `category` WHERE `slug`='kopirovalnye-raboty'

SELECT * FROM `service` WHERE (place != 3) AND (`category_id`=1) ORDER BY `main_menu_order`

SELECT * FROM `category` WHERE `slug`='obrabotka'

SELECT * FROM `service` WHERE (place != 3) AND (`category_id`=5) ORDER BY `main_menu_order`

SELECT * FROM `post` WHERE `slug`='blog'

SHOW FULL COLUMNS FROM `order`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'order' AND kcu.table_name = 'order'

SHOW FULL COLUMNS FROM `review`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'review' AND kcu.table_name = 'review'

SELECT * FROM `post` WHERE `slug`='blog'

SELECT * FROM `category` WHERE id IN (11,12,7,16,19,6,4,32,22,5,2,3)

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

SELECT * FROM `category` WHERE `slug`='docs'

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

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

SELECT * FROM `category` WHERE `slug`='chertezh'

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

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

SELECT * FROM `category` WHERE `slug`='pechat-vizitok'

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

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

SELECT * FROM `category` WHERE `slug`='pechat-listovok'

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

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

SELECT * FROM `category` WHERE `slug`='pechat-kalendarey'

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

SELECT * FROM `category` WHERE `slug`='photouslugi'

SELECT * FROM `category` WHERE `slug`='tipographia'

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

SELECT * FROM `category` WHERE `slug`='tverdiy-pereplet'

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

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

SELECT * FROM `category` WHERE `slug`='shirokoformat-pechat'

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

SELECT * FROM `category` WHERE `slug`='obrabotka'

SELECT * FROM `category` WHERE `slug`='pechat'

SELECT * FROM `category` WHERE `slug`='polygraphy'