Home Contact Forum   Newsflash Bine ati venit pe site, va dorim navigare placuta!   Meniu Principal Home Argument Actualitate Articole Cauta in site Istoria Bisericii Istoria sarbilor Sfintii imparati Texte bizantine Profetii Istorie Bizantina Harti Imperiul romano-bulgar Forum Muzica Bizantina Familia Bizantina Spiritualitate ortodoxa Recomandari Afaceri  Detectoare radar Romania Bogdan Stanciu  Revista Murmur Sfantul Daniil Sihastrul  Sita Deasa  Home Familia Bizantina Actualitate Articole de atitudine, realitati contemporane, noutati si puncte de vedere. Filtru     Implicit  Data cresc. Data desc. Titlu cresc. Titlu desc. Afisari cresc. Afisari desc. Autor cresc Autor desc. Ordonare    Afisare #  5 10 15 20 25 30 50 Data Titlu articol Autor Vizite Miercuri, 10 Octombrie 2007 Babilon II. Noul imperiu al Europei Administrator 681 Miercuri, 10 Octombrie 2007 Identitate bizantina vs. integrare europeana Administrator 724   << Start < Inapoi 1 Inainte > Sfarsit >> Rezultate 1 - 2 din 2 Spiritualitate ortodoxa  ( 4 articole ) Familia Bizantina  ( 3 articole ) Muzica Bizantina  ( 3 articole ) Latest News  ( 3 articole ) Scurta istorie bizantina  ( 4 articole ) [ Inapoi ]

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 42 )
 ORDER BY menuid DESC
LIMIT 1
3
DELETE FROM jos_session
 WHERE (
 ( time < '1216843874' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1216843874' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT *
 FROM jos_menu
 WHERE id = 42
5
SELECT *
 FROM jos_categories
 WHERE id = '17'
6
SELECT *
 FROM jos_sections
 WHERE id = '1'
7
SELECT c.*, COUNT( b.id ) AS numitems
 FROM jos_categories AS c
 LEFT JOIN jos_content AS b ON b.catid = c.id 
 AND b.state = 1
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2008-07-23 13:26' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2008-07-23 13:26' )
 AND b.access <= 0
 WHERE c.section = '1'
 AND c.published = 1
 AND c.access <= 0
 GROUP BY c.id
 HAVING COUNT( b.id ) > 0
 ORDER BY c.ordering
8
SELECT COUNT(a.id) as numitems
 FROM jos_content AS a
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.catid = 17
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2008-07-23 13:26' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-07-23 13:26' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
9
SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups
 FROM jos_content AS a
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.catid = 17
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2008-07-23 13:26' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-07-23 13:26' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
LIMIT 30
10
SELECT a.*
 FROM jos_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'
11
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_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 = 42 )
 ORDER BY ordering
12
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
13
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
14
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-07-23 13:26' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-07-23 13:26' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
15
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
16
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
17
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
18
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=30'
19
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
20
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=15'
21
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=16'
22
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=17'
23
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=18'
24
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=19'
25
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
26
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=23'
27
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=25'
28
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Recomandari'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
29
SELECT *
 FROM jos_banner
 WHERE showBanner=1
30
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering