Monday, 06 September 2010 | NHL.com | Canadiens.com | TSN.ca | Главная   Главная Новости Статьи Календарь Позиция Форум CFL Форум Ссылки Архив Новостей Контакты - - - - - - - Montreal Canadiens Русский фан клуб Edmonton Oilers Русский фан сайт Русский Монреаль Все о Монреале     В данном разделе собраны наиболее интересные и полезные ссылки в сети. Выберите из списка ниже один из разделов, затем выберите нужную ссылку.   NHL   (5) Montreal Canadiens   (7) [Назад]   Популярное Первый взгляд на «Несвободных» агентов 2008 Взгляд на Сергея Костицина Видео обзоры матчей НХЛ Терминология НХЛ для новичков и не только!(Часть II) Кто лучший йога в Канадиенс и где лучше бублики? Случайная новость Не все-так плохо как казалось, однако причин для радости не видно... Подробнее...

1
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='22' LIMIT 1
3
DELETE FROM mos_session
WHERE (time < 1283799313)
4
SELECT * FROM mos_session WHERE session_id='4ff4eeed8f1e1b3841cfa78ff8553a12'
5
UPDATE mos_session SET `time`='1283800213',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='4ff4eeed8f1e1b3841cfa78ff8553a12'
6
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
7
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
8
SELECT access FROM mos_menu WHERE id='22'
9
SELECT *, COUNT(a.id) AS numlinks FROM mos_categories AS cc
 LEFT JOIN mos_weblinks AS a ON a.catid = cc.id
 WHERE a.published='1' AND a.approved='1' AND section='com_weblinks' AND cc.published='1' AND cc.access <= '0'
 GROUP BY cc.id
 ORDER BY cc.ordering
10
SELECT * FROM mos_menu WHERE id='22'
11
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
12
SELECT * FROM mos_components WHERE id='17'
13
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '22' OR mm.menuid = '0')
ORDER BY ordering
14
SELECT m.* FROM mos_menu AS m
WHERE menutype='Links menu' AND published='1' AND access <= '0' AND parent='0'
ORDER BY ordering
15
SELECT *
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
16
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
17
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
18
SELECT m.* FROM mos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
19
SELECT a.id, a.title, a.sectionid, a.catid
 FROM mos_content AS a
 LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
 WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-06 12:10:13' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-06 12:10:13' )
 AND a.access <= '0'
 ORDER BY a.hits DESC LIMIT 5
20
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
21
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
22
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
23
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=239
24
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=203
25
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=127
26
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=31
27
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=253
28
SELECT a.id
 FROM mos_content AS a
 INNER JOIN mos_categories AS b ON b.id = a.catid
 WHERE a.state = 1
 AND a.access <= '0' AND b.access <= '0'
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-06 12:10:13') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-06 12:10:13')
 AND catid='1' 
 ORDER BY a.ordering
 LIMIT 1
29
SELECT * FROM mos_content WHERE id='455'
30
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
31
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
32
SELECT * FROM mos_mambots WHERE id='16'
33
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=455