Каталог скидок

← оБЪБД

Время генерации страницы: 0.2861 сек.
Запросы к базе: 147
SET NAMES cp1251

SELECT * FROM icms_menu ORDER BY id ASC

SELECT id, title, link, config, internal, published, version, system FROM icms_components

SELECT p.id, p.plugin, p.config, e.event FROM icms_plugins p, icms_event_hooks e WHERE p.published = 1 AND e.plugin_id = p.id

SELECT id FROM icms_user_groups WHERE alias = 'guest'

DELETE FROM icms_online WHERE lastdate <= DATE_SUB(NOW(), INTERVAL 3 MINUTE)

SELECT id as getfield FROM icms_online WHERE sess_id = '38335328e14eb6b719c8ecf53294fb67' AND ip = '54.224.86.148' LIMIT 1

INSERT INTO icms_online (ip, sess_id, lastdate, user_id, agent, viewurl) VALUES ('54.224.86.148', '38335328e14eb6b719c8ecf53294fb67', NOW(), '0', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '/catalog/1014')

SELECT id FROM icms_stats WHERE (ip = '54.224.86.148' AND page = '/catalog/1014')

SELECT NSLeft, NSRight FROM icms_menu WHERE id = '23'

SELECT id, title, link, linktype
                           FROM icms_menu
                           WHERE NSLeft <= 8 AND NSRight >= 9 AND parent_id > 0
                           ORDER BY NSLeft

SELECT * FROM icms_uc_cats WHERE id = 1014

SELECT id, title, NSLevel
                FROM icms_uc_cats
                WHERE NSLeft <= 2 AND NSRight >= 41 AND parent_id > 0
                ORDER BY NSLeft

SELECT cat.*
                FROM icms_uc_cats cat
                WHERE cat.parent_id = '1014' AND cat.published = 1
                ORDER BY cat.title

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 7 AND cat.NSRight <= 8) AND con.published = 1

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 37 AND cat.NSRight <= 38) AND con.published = 1

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 25 AND cat.NSRight <= 26) AND con.published = 1

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 29 AND cat.NSRight <= 32) AND con.published = 1

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 13 AND cat.NSRight <= 16) AND con.published = 1

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 19 AND cat.NSRight <= 20) AND con.published = 1

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 17 AND cat.NSRight <= 18) AND con.published = 1

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 35 AND cat.NSRight <= 36) AND con.published = 1

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 27 AND cat.NSRight <= 28) AND con.published = 1

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 11 AND cat.NSRight <= 12) AND con.published = 1

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 21 AND cat.NSRight <= 24) AND con.published = 1

SELECT con.id
                          FROM icms_uc_items con, icms_uc_cats cat
                          WHERE con.category_id = cat.id AND (cat.NSLeft >= 9 AND cat.NSRight <= 10) AND con.published = 1

SELECT 1 FROM icms_uc_cart WHERE (user_id=0 AND session_id='38335328e14eb6b719c8ecf53294fb67')

SELECT i.* , IFNULL(AVG( r.points ), 0) AS rating, i.price as price
                        FROM icms_uc_items i 
                        LEFT JOIN icms_uc_ratings r ON r.item_id = i.id 
                        WHERE i.published = 1 AND (i.category_id = 1014 OR 1014=1014)
                        GROUP BY i.id ORDER BY pubdate desc

SELECT 1 FROM icms_uc_cats_access WHERE cat_id=1014 AND group_id=8 LIMIT 1

SELECT i.* , IFNULL(AVG( r.points ), 0) AS rating, i.price as price
                        FROM icms_uc_items i 
                        LEFT JOIN icms_uc_ratings r ON r.item_id = i.id 
                        WHERE i.published = 1 AND (i.category_id = 1014 OR 1014=1014)
                        GROUP BY i.id ORDER BY pubdate desc LIMIT 0, 21

SELECT login, nickname, id FROM icms_users WHERE id='43532' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=422

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 422
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1005 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 422 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='43532' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=421

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 421
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1005 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 421 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='43534' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=417

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 417
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1021 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 417 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='279' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=317

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 317
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1006 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 317 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='279' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=319

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 319
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1006 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 319 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='60' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=399

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 399
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1003 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 399 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='279' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=393

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 393
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1006 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 393 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='290' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=392

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 392
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1004 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 392 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='279' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=377

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 377
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1006 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 377 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='279' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=304

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 304
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1006 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 304 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='60' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=10

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 10
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1003 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 10 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='290' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=372

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 372
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1005 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 372 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='316' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=370

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 370
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1014 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 370 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='279' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=320

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 320
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1006 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 320 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='279' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=316

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 316
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1006 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 316 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='279' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=309

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 309
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1006 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 309 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='279' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=308

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 308
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1006 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 308 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='279' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=306

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 306
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1006 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 306 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT login, nickname, id FROM icms_users WHERE id='279' ORDER BY id ASC LIMIT 1

SELECT cmi.title,cmi.seolink FROM icms_uc_map AS cum LEFT JOIN icms_map_items AS cmi ON (cum.map_id=cmi.id) WHERE cum.uc_id=305

SELECT *, IFNULL(AVG(points), 0) as rating, COUNT(id) as votes
            FROM icms_uc_ratings
            WHERE item_id = 305
            GROUP BY item_id

SELECT sign, unit, value FROM icms_uc_discount WHERE cat_id = 1006 OR cat_id = 0 AND sign<2

SELECT id FROM icms_uc_items WHERE id = 305 AND pubdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'top' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '23' OR mb.menu_id = 0)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'sidebar' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '23' OR mb.menu_id = 0)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'left' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '23' OR mb.menu_id = 0)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'user1' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '23' OR mb.menu_id = 0)

SELECT m.access_list
            FROM icms_modules m, icms_modules_bind mb
            WHERE mb.position = 'user3' AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '23' OR mb.menu_id = 0)

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'topmenu') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '23' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC

SELECT NSLeft, NSRight, NSLevel FROM icms_menu WHERE id = '23' ORDER BY id ASC LIMIT 1

SELECT id as getfield FROM icms_menu WHERE parent_id=0 LIMIT 1

SELECT * FROM icms_menu WHERE id = 1 AND NSDiffer = ''

SELECT * FROM icms_menu WHERE NSLeft > 1 AND NSRight < 28 AND NSDiffer = '' ORDER BY NSLeft,ordering

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'top') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '23' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'maintop') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '23' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'mainbottom') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '23' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'footer1') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '23' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC

SELECT NSLeft, NSRight, NSLevel FROM icms_menu WHERE id = '23' ORDER BY id ASC LIMIT 1

SELECT id as getfield FROM icms_menu WHERE parent_id=0 LIMIT 1

SELECT * FROM icms_menu WHERE id = 1 AND NSDiffer = ''

SELECT * FROM icms_menu WHERE NSLeft > 1 AND NSRight < 28 AND NSDiffer = '' ORDER BY NSLeft,ordering

SELECT *, m.id as mid, m.template as tpl
            FROM icms_modules m, icms_modules_bind mb
            WHERE (mb.position = 'footer2') AND
                  m.published = 1 AND
                  m.id = mb.module_id AND
                  (mb.menu_id = '23' OR mb.menu_id = 0)
                  
            ORDER BY m.ordering ASC

SELECT * FROM icms_filters WHERE published = 1 ORDER BY id ASC

SELECT * FROM icms_filter_rules

SELECT id as getfield FROM icms_content WHERE seolink='' LIMIT 1