Документы, регламентирующие деятельность

SHOW FULL COLUMNS FROM `settings`

SELECT `setting`.* FROM `settings` AS `setting` LIMIT 1

SHOW FULL COLUMNS FROM `pages`

SELECT `page`.* FROM `pages` AS `page` WHERE `id` = 2 AND `status` = '1' ORDER BY `page`.`lft` ASC LIMIT 1

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 434 AND `rgt` < 441 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `id` = 3 AND `status` = '1' ORDER BY `page`.`lft` ASC LIMIT 1

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 428 AND `rgt` < 433 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `id` = 4 AND `status` = '1' ORDER BY `page`.`lft` ASC LIMIT 1

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 250 AND `rgt` < 427 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 3 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `id` = 5 AND `status` = '1' ORDER BY `page`.`lft` ASC LIMIT 1

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 10 AND `rgt` < 249 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 3 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `id` = 6 AND `status` = '1' ORDER BY `page`.`lft` ASC LIMIT 1

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 4 AND `rgt` < 9 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' ORDER BY `lft` DESC

SHOW FULL COLUMNS FROM `gallery`

SELECT `gallery`.* FROM `gallery` AS `gallery` WHERE `gallery_category_id` = 1 AND `status` = '1' ORDER BY `order` DESC

SELECT `gallery`.* FROM `gallery` AS `gallery` WHERE `gallery_category_id` = 3 AND `status` = '1' ORDER BY `order` DESC

SHOW FULL COLUMNS FROM `banners`

SELECT `banner`.* FROM `banners` AS `banner` WHERE `status` = '1' ORDER BY `order`

SHOW FULL COLUMNS FROM `questions`

SELECT `questions`.* FROM `questions` AS `questions` WHERE `status` = '1' AND NOW() BETWEEN `date_begin` AND `date_end` ORDER BY RAND() LIMIT 1

SELECT `page`.* FROM `pages` AS `page` WHERE `status` = '1' AND `alias` = 'dokumenty_reglamentirujushhie_dejatelnost_tekhnikuma' ORDER BY `page`.`lft` ASC LIMIT 1

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` <= 258 AND `rgt` >= 339 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lft` != 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 425 AND `rgt` < 426 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 367 AND `rgt` < 424 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 367 AND `rgt` > 424 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 410 AND `rgt` > 423 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 400 AND `rgt` > 409 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 378 AND `rgt` > 399 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 376 AND `rgt` > 377 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 368 AND `rgt` > 375 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 357 AND `rgt` < 366 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 253 AND `rgt` < 356 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 253 AND `rgt` > 356 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 253 AND `rgt` > 356 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 350 AND `rgt` > 355 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 340 AND `rgt` > 349 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 258 AND `rgt` > 339 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 256 AND `rgt` > 257 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 254 AND `rgt` > 255 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 251 AND `rgt` < 252 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 258 AND `rgt` < 339 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 5 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 335 AND `rgt` > 338 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 333 AND `rgt` > 334 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 331 AND `rgt` > 332 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 329 AND `rgt` > 330 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 327 AND `rgt` > 328 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 325 AND `rgt` > 326 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 323 AND `rgt` > 324 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 321 AND `rgt` > 322 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 319 AND `rgt` > 320 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 317 AND `rgt` > 318 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 315 AND `rgt` > 316 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 313 AND `rgt` > 314 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 311 AND `rgt` > 312 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 309 AND `rgt` > 310 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 267 AND `rgt` > 308 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 265 AND `rgt` > 266 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 263 AND `rgt` > 264 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 261 AND `rgt` > 262 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 259 AND `rgt` > 260 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 221 AND `rgt` > 248 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 221 AND `rgt` < 248 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 246 AND `rgt` > 247 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 236 AND `rgt` > 241 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 232 AND `rgt` > 233 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 228 AND `rgt` > 229 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 226 AND `rgt` > 227 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 224 AND `rgt` > 225 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 219 AND `rgt` > 220 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 219 AND `rgt` < 220 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 205 AND `rgt` > 218 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 205 AND `rgt` < 218 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 216 AND `rgt` > 217 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 214 AND `rgt` > 215 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 212 AND `rgt` > 213 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 210 AND `rgt` > 211 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 208 AND `rgt` > 209 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 206 AND `rgt` > 207 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 157 AND `rgt` > 204 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 157 AND `rgt` < 204 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 200 AND `rgt` > 203 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 192 AND `rgt` > 199 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 190 AND `rgt` > 191 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 188 AND `rgt` > 189 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 170 AND `rgt` > 187 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 168 AND `rgt` > 169 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 166 AND `rgt` > 167 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 164 AND `rgt` > 165 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 162 AND `rgt` > 163 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 160 AND `rgt` > 161 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 158 AND `rgt` > 159 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 117 AND `rgt` > 156 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 117 AND `rgt` < 156 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 154 AND `rgt` > 155 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 152 AND `rgt` > 153 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 144 AND `rgt` > 151 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 142 AND `rgt` > 143 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 136 AND `rgt` > 139 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 134 AND `rgt` > 135 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 132 AND `rgt` > 133 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 130 AND `rgt` > 131 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 128 AND `rgt` > 129 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 126 AND `rgt` > 127 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 120 AND `rgt` > 125 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 118 AND `rgt` > 119 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 105 AND `rgt` > 116 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 105 AND `rgt` < 116 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 114 AND `rgt` > 115 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 112 AND `rgt` > 113 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 108 AND `rgt` > 111 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 106 AND `rgt` > 107 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 91 AND `rgt` > 104 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 91 AND `rgt` < 104 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 79 AND `rgt` > 90 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 79 AND `rgt` < 90 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 53 AND `rgt` > 78 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 53 AND `rgt` < 78 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 72 AND `rgt` > 77 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 68 AND `rgt` > 71 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 66 AND `rgt` > 67 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 64 AND `rgt` > 65 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 60 AND `rgt` > 63 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 58 AND `rgt` > 59 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 56 AND `rgt` > 57 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 51 AND `rgt` > 52 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 51 AND `rgt` < 52 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 47 AND `rgt` > 50 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 47 AND `rgt` < 50 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 48 AND `rgt` > 49 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 45 AND `rgt` > 46 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 45 AND `rgt` < 46 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 39 AND `rgt` > 44 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 39 AND `rgt` < 44 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 40 AND `rgt` > 43 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 33 AND `rgt` > 34 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 33 AND `rgt` < 34 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 31 AND `rgt` > 32 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 31 AND `rgt` < 32 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` < 29 AND `rgt` > 30 AND `scope` = 1 ORDER BY `lft` ASC

SELECT `page`.* FROM `pages` AS `page` WHERE `lft` > 29 AND `rgt` < 30 AND `scope` = 1 AND `status` = '1' AND `menu_show` = '1' AND `lvl` = 4 ORDER BY `lft` DESC