Украинская Баннерная Сеть Украинская Баннерная Сеть Украинская Баннерная Сеть

Навигация Главная Банковское дело Бухгалтерский учет, аудит Инвестиции Экономика Налоги Финансы Финансовое право Прочие дисциплины Карта сайта - - - - - - - Правила користування - - - - - - - оптимизация сайта Украинская Баннерная Сеть   Главная Инвестиции Книги   Аналіз інвестиційних проектів - Щукін Б.М.   Інвестиційне кредитування - Пересада А.А.   Інвестування - Пересада А.А.   Інвестування - Щукін Б. М.   Страховий та інвестиційний менеджмент - Федоренко В. Г.     Украинская Баннерная Сеть Украинская Баннерная Сеть Добавить свое объявление Загрузка... Добавить свое объявление Загрузка...

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM j11_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM j11_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 87 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM j11_session
 WHERE (
 ( time < '1329953173' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1329953173' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM j11_menu
 WHERE id = 87
6
SELECT *
 FROM j11_sections
 WHERE id = '26'
7
SELECT a.*, COUNT( b.id ) AS numitems
 FROM j11_categories AS a
 LEFT JOIN j11_content AS b ON b.catid = a.id
 AND b.state = 1
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2012-02-23 01:41' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-23 01:41' )
 WHERE a.section = '26'
 AND a.published = 1
 AND a.access <= 0
 AND b.access <= 0
 GROUP BY a.id
 HAVING numitems > 0
 ORDER BY a.ordering
8
SELECT a.*
 FROM j11_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
9
SELECT m.id
 FROM j11_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
10
SELECT id, title, module, position, content, showtitle, params
 FROM j11_modules AS m
 INNER JOIN j11_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 87 )
 ORDER BY ordering
11
SELECT id, name, link, parent, type, menutype, access
 FROM j11_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
12
SELECT c.*  FROM j11_categories AS c INNER JOIN j11_sections AS s ON s.id = c.section WHERE c.id > 0 AND c.access <= 0 AND s.id=26 AND (s.id!=7 AND s.id!=4 AND s.id!=8 AND s.id!=13 AND s.id!=20 AND s.id!=23 AND s.id!=24 AND s.id!=27) AND c.published = 1 ORDER BY c.section, c.title ASC
13
SELECT COUNT( id )
 FROM j11_menu 
 WHERE type = 'content_item_link'
 AND published = 1
14
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM j11_content AS i
 LEFT JOIN j11_sections AS s ON i.sectionid = s.id
 LEFT JOIN j11_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN j11_categories AS c ON i.catid = c.id
 LEFT JOIN j11_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 0
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
15
SELECT id 
 FROM j11_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
16
SELECT id 
 FROM j11_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
17
SELECT a.id, a.title, a.sectionid, a.catid, a.introtext, a.lang, a.fulltext, a.images, a.created
 FROM j11_content AS a
 LEFT JOIN j11_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN j11_categories AS cc ON cc.id = a.catid
 INNER JOIN j11_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 01:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 01:41' )
 AND a.access <= 0
 AND f.content_id IS NOT NULL
 AND a.catid =  214
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.title ASC
LIMIT 1000
18
SELECT a.id, a.title, a.sectionid, a.catid, a.introtext, a.lang, a.fulltext, a.images, a.created
 FROM j11_content AS a
 LEFT JOIN j11_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN j11_categories AS cc ON cc.id = a.catid
 INNER JOIN j11_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 01:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 01:41' )
 AND a.access <= 0
 AND f.content_id IS NOT NULL
 AND a.catid =  213
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.title ASC
LIMIT 1000
19
SELECT a.id, a.title, a.sectionid, a.catid, a.introtext, a.lang, a.fulltext, a.images, a.created
 FROM j11_content AS a
 LEFT JOIN j11_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN j11_categories AS cc ON cc.id = a.catid
 INNER JOIN j11_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 01:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 01:41' )
 AND a.access <= 0
 AND f.content_id IS NOT NULL
 AND a.catid =  209
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.title ASC
LIMIT 1000
20
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM j11_content AS i
 LEFT JOIN j11_sections AS s ON i.sectionid = s.id
 LEFT JOIN j11_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN j11_categories AS c ON i.catid = c.id
 LEFT JOIN j11_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 1393
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
21
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM j11_content AS i
 LEFT JOIN j11_sections AS s ON i.sectionid = s.id
 LEFT JOIN j11_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN j11_categories AS c ON i.catid = c.id
 LEFT JOIN j11_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 195
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
22
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM j11_content AS i
 LEFT JOIN j11_sections AS s ON i.sectionid = s.id
 LEFT JOIN j11_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN j11_categories AS c ON i.catid = c.id
 LEFT JOIN j11_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 200
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
23
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM j11_content AS i
 LEFT JOIN j11_sections AS s ON i.sectionid = s.id
 LEFT JOIN j11_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN j11_categories AS c ON i.catid = c.id
 LEFT JOIN j11_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 1377
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
24
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM j11_content AS i
 LEFT JOIN j11_sections AS s ON i.sectionid = s.id
 LEFT JOIN j11_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN j11_categories AS c ON i.catid = c.id
 LEFT JOIN j11_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 1167
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
25
SELECT a.id, a.title, a.sectionid, a.catid, a.introtext, a.lang, a.fulltext, a.images, a.created
 FROM j11_content AS a
 LEFT JOIN j11_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN j11_categories AS cc ON cc.id = a.catid
 INNER JOIN j11_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 01:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 01:41' )
 AND a.access <= 0
 AND f.content_id IS NOT NULL
 AND a.catid =  207
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.title ASC
LIMIT 1000
26
SELECT a.id, a.title, a.sectionid, a.catid, a.introtext, a.lang, a.fulltext, a.images, a.created
 FROM j11_content AS a
 LEFT JOIN j11_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN j11_categories AS cc ON cc.id = a.catid
 INNER JOIN j11_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 01:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 01:41' )
 AND a.access <= 0
 AND f.content_id IS NOT NULL
 AND a.catid =  212
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.title ASC
LIMIT 1000
27
SELECT a.id, a.title, a.sectionid, a.catid, a.introtext, a.lang, a.fulltext, a.images, a.created
 FROM j11_content AS a
 LEFT JOIN j11_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN j11_categories AS cc ON cc.id = a.catid
 INNER JOIN j11_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 01:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 01:41' )
 AND a.access <= 0
 AND f.content_id IS NOT NULL
 AND a.catid =  211
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.title ASC
LIMIT 1000
28
SELECT a.id, a.title, a.sectionid, a.catid, a.introtext, a.lang, a.fulltext, a.images, a.created
 FROM j11_content AS a
 LEFT JOIN j11_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN j11_categories AS cc ON cc.id = a.catid
 INNER JOIN j11_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 01:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 01:41' )
 AND a.access <= 0
 AND f.content_id IS NOT NULL
 AND a.catid =  210
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.title ASC
LIMIT 1000
29
SELECT a.id, a.title, a.sectionid, a.catid, a.introtext, a.lang, a.fulltext, a.images, a.created
 FROM j11_content AS a
 LEFT JOIN j11_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN j11_categories AS cc ON cc.id = a.catid
 INNER JOIN j11_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 01:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 01:41' )
 AND a.access <= 0
 AND f.content_id IS NOT NULL
 AND a.catid =  208
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.title ASC
LIMIT 1000
30
SELECT a.id, a.title, a.sectionid, a.catid, a.introtext, a.lang, a.fulltext, a.images, a.created
 FROM j11_content AS a
 LEFT JOIN j11_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN j11_categories AS cc ON cc.id = a.catid
 INNER JOIN j11_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 01:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 01:41' )
 AND a.access <= 0
 AND f.content_id IS NOT NULL
 AND a.catid =  216
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.title ASC
LIMIT 1000
31
SELECT a.id, a.title, a.sectionid, a.catid, a.introtext, a.lang, a.fulltext, a.images, a.created
 FROM j11_content AS a
 LEFT JOIN j11_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN j11_categories AS cc ON cc.id = a.catid
 INNER JOIN j11_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-23 01:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-23 01:41' )
 AND a.access <= 0
 AND f.content_id IS NOT NULL
 AND a.catid =  215
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.title ASC
LIMIT 1000