contact us | login

Novinky

• Visual show Gruzie 07
• Článek z Tkibuli (Gruzie) na Aktuálně.cz
• Visula show Gruzie 07 Kozelka
• Visual show Gruzie 07
• Marný boj s gruzínskou byrokracií

Projekce

• Visual show Gruzie 07
• Článek z Tkibuli (Gruzie) na Aktuálně.cz
• Visula show Gruzie 07 Kozelka
• Visual show Gruzie 07
• Přijeďte na naší projekci do Teplic nad Metují

Náhodný obrázek

Hlavní menu

Gruzie 2007

O expedici

Články Gruzie 2007 Pamír-Hindúkuš 2006

Galerie

Odkazy

Kontakty

Vyhledávání

Partneři

Gruzie 2007 Články

Články

Deník  ( 8 položek )

[Zpět]

© 2019 Gruzie 2007 - Expeditions.cz

Customized by SetNet.cz. Powered by Joomla!

Free template by Joomla Junkie

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM gruzie07_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM gruzie07_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 2 )
 ORDER BY menuid DESC
LIMIT 0, 1
4
DELETE FROM gruzie07_session
 WHERE (
 ( time < '1575569671' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1575569671' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT id
 FROM gruzie07_mambots
 WHERE element = 'jceembed'
 AND folder = 'system'
6
SELECT *
 FROM gruzie07_mambots
 WHERE id = '27'
7
SELECT id FROM gruzie07_mambots WHERE element = 'joomsef_metabot' AND folder = 'system'
8
SELECT *
 FROM gruzie07_mambots
 WHERE id = '28'
9
SELECT template
 FROM gruzie07_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 2 )
 ORDER BY menuid DESC
LIMIT 0, 1
10
SELECT *
 FROM gruzie07_menu
 WHERE id = 2
11
SELECT *
 FROM gruzie07_sections
 WHERE id = '1'
12
SELECT a.*, COUNT( b.id ) AS numitems
 FROM gruzie07_categories AS a
 LEFT JOIN gruzie07_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 <= '2019-12-05 19:29' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2019-12-05 19:29' )
 WHERE a.section = '1'
 AND a.published = 1
 AND a.access <= 0
 GROUP BY a.id
 HAVING numitems > 0
 ORDER BY a.ordering
13
SELECT a.*
 FROM gruzie07_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'
14
SELECT id, title, module, position, content, showtitle, params
 FROM gruzie07_modules AS m
 INNER JOIN gruzie07_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 = '2' )
 ORDER BY ordering
15
SELECT id
 FROM gruzie07_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
16
SELECT a.id, a.title, a.sectionid, a.catid, cc.access AS cat_access, s.access AS sec_access, cc.published AS cat_state, s.published AS sec_state
 FROM gruzie07_content AS a
 LEFT JOIN gruzie07_content_frontpage AS f ON f.content_id = a.id
 LEFT JOIN gruzie07_categories AS cc ON cc.id = a.catid
 LEFT JOIN gruzie07_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-05 19:29' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-05 19:29' )
 AND a.access <= 0
 ORDER BY a.created DESC
LIMIT 0, 5
17
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 gruzie07_content AS i
 LEFT JOIN gruzie07_sections AS s ON i.sectionid = s.id
 LEFT JOIN gruzie07_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN gruzie07_categories AS c ON i.catid = c.id
 LEFT JOIN gruzie07_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 = 29
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
18
SELECT id 
 FROM gruzie07_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
19
SELECT id 
 FROM gruzie07_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
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 gruzie07_content AS i
 LEFT JOIN gruzie07_sections AS s ON i.sectionid = s.id
 LEFT JOIN gruzie07_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN gruzie07_categories AS c ON i.catid = c.id
 LEFT JOIN gruzie07_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 = 28
 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 gruzie07_content AS i
 LEFT JOIN gruzie07_sections AS s ON i.sectionid = s.id
 LEFT JOIN gruzie07_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN gruzie07_categories AS c ON i.catid = c.id
 LEFT JOIN gruzie07_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 = 27
 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 gruzie07_content AS i
 LEFT JOIN gruzie07_sections AS s ON i.sectionid = s.id
 LEFT JOIN gruzie07_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN gruzie07_categories AS c ON i.catid = c.id
 LEFT JOIN gruzie07_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 = 26
 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 gruzie07_content AS i
 LEFT JOIN gruzie07_sections AS s ON i.sectionid = s.id
 LEFT JOIN gruzie07_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN gruzie07_categories AS c ON i.catid = c.id
 LEFT JOIN gruzie07_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 = 21
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
24
SELECT a.id, a.title, a.sectionid, a.catid, cc.access AS cat_access, s.access AS sec_access, cc.published AS cat_state, s.published AS sec_state
 FROM gruzie07_content AS a
 LEFT JOIN gruzie07_content_frontpage AS f ON f.content_id = a.id
 LEFT JOIN gruzie07_categories AS cc ON cc.id = a.catid
 LEFT JOIN gruzie07_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-05 19:29' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-05 19:29' )
 AND a.access <= 0
 AND ( a.sectionid IN ( 4 ) )
 ORDER BY a.created DESC
LIMIT 0, 5
25
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 gruzie07_content AS i
 LEFT JOIN gruzie07_sections AS s ON i.sectionid = s.id
 LEFT JOIN gruzie07_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN gruzie07_categories AS c ON i.catid = c.id
 LEFT JOIN gruzie07_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 = 6
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
26
SELECT m.*
 FROM gruzie07_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
27
SELECT * FROM gruzie07_advertising WHERE (tid IN (3)) AND
		  (('2019-12-05' <= SUBSTRING(publish_down,1,10)
		   OR publish_down = '0000-00-00 00:00:00' )
		  AND '2019-12-05' >= SUBSTRING(publish_up,1,10)
		  AND (
		      (reccurtype = 0)
		   OR (reccurtype = 1 AND reccurweekdays LIKE '%4%')
		  )
		  AND '19:29:31' >= SUBSTRING(publish_up,12)
		  AND ('19:29:31' <= SUBSTRING(publish_down,12) OR SUBSTRING(publish_down,12) = '00:00:00')
		  AND access <= '0'
                  AND state = '1') ORDER BY last_show ASC, msec ASC
28
SELECT * FROM gruzie07_advertising WHERE (tid IN (3)) AND
		  (('2019-12-05' <= SUBSTRING(publish_down,1,10)
		   OR publish_down = '0000-00-00 00:00:00' )
		  AND '2019-12-05' >= SUBSTRING(publish_up,1,10)
		  AND (
		      (reccurtype = 0)
		   OR (reccurtype = 1 AND reccurweekdays LIKE '%4%')
		  )
		  AND '19:29:31' >= SUBSTRING(publish_up,12)
		  AND ('19:29:31' <= SUBSTRING(publish_down,12) OR SUBSTRING(publish_down,12) = '00:00:00')
		  AND access <= '0'
                  AND state = '1') ORDER BY last_show ASC, msec ASC
29
SELECT * FROM gruzie07_advertising WHERE (tid IN (4)) AND
		  (('2019-12-05' <= SUBSTRING(publish_down,1,10)
		   OR publish_down = '0000-00-00 00:00:00' )
		  AND '2019-12-05' >= SUBSTRING(publish_up,1,10)
		  AND (
		      (reccurtype = 0)
		   OR (reccurtype = 1 AND reccurweekdays LIKE '%4%')
		  )
		  AND '19:29:31' >= SUBSTRING(publish_up,12)
		  AND ('19:29:31' <= SUBSTRING(publish_down,12) OR SUBSTRING(publish_down,12) = '00:00:00')
		  AND access <= '0'
                  AND state = '1') ORDER BY last_show ASC, msec ASC
30
SELECT * FROM gruzie07_advertising WHERE (tid IN (4)) AND
		  (('2019-12-05' <= SUBSTRING(publish_down,1,10)
		   OR publish_down = '0000-00-00 00:00:00' )
		  AND '2019-12-05' >= SUBSTRING(publish_up,1,10)
		  AND (
		      (reccurtype = 0)
		   OR (reccurtype = 1 AND reccurweekdays LIKE '%4%')
		  )
		  AND '19:29:31' >= SUBSTRING(publish_up,12)
		  AND ('19:29:31' <= SUBSTRING(publish_down,12) OR SUBSTRING(publish_down,12) = '00:00:00')
		  AND access <= '0'
                  AND state = '1') ORDER BY last_show ASC, msec ASC
31
SELECT id, name, link, parent, type, menutype, access
 FROM gruzie07_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering