 |
Menu Principal |
 |
| |
|
Exclusivo Exparticipantes |
|
|
|
Exclusivo Exparticipantes |
|
|
|
|
 |
|
 |
|
|
|
|
|
| |
| |
|
|
|
MISCELANEA FISCAL 2009-2010 |
|
|
|
DECRETOS Y FACILIDADES ADMINISTRATIVAS 2009 |
|
|
| << Start < Prev 1 Next > End >>
| | Results 1 - 8 of 8 |
|
|
|
|
|
|
|
|
 |
|
© 2010 Grupo Corporativo de Ejecutivos Consultores
Joomla! es Software Libre distribuido bajo licencia GNU/GPL.
|
64 preguntas ejecutadas1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
FROM mos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering
3
SELECT id, link
FROM mos_menu
WHERE menutype = 'mainmenu'
AND published = 1
ORDER BY parent, ordering
LIMIT 1
4
SELECT template
FROM mos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 1 )
ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM mos_session
WHERE (
( time < '1280435076' )
AND guest = 0
AND gid > 0
) OR (
( time < '1280437776' )
AND guest = 1
AND userid = 0
)
6
SELECT COUNT(*)
FROM mos_stats_agents
WHERE agent = 'Unknown'
AND type = 0
7
UPDATE mos_stats_agents
SET hits = ( hits + 1 )
WHERE agent = 'Unknown'
AND type = 0
8
SELECT COUNT(*)
FROM mos_stats_agents
WHERE agent = 'Unknown'
AND type = 1
9
UPDATE mos_stats_agents
SET hits = ( hits + 1 )
WHERE agent = 'Unknown'
AND type = 1
10
SELECT COUNT(*)
FROM mos_stats_agents
WHERE agent = 'Unknown'
AND type = 2
11
UPDATE mos_stats_agents
SET hits = ( hits + 1 )
WHERE agent = 'Unknown'
AND type = 2
12
SELECT *
FROM mos_menu
WHERE id = 1
13
SELECT COUNT(a.id)
FROM mos_content AS a
INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN mos_categories AS cc ON cc.id = a.catid
INNER JOIN mos_sections AS s ON s.id = a.sectionid
LEFT JOIN mos_users AS u ON u.id = a.created_by
LEFT JOIN mos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-07-29 16:24' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-29 16:24' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 0
AND s.access <= 0
AND cc.access <= 0
14
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
FROM mos_content AS a
INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN mos_categories AS cc ON cc.id = a.catid
INNER JOIN mos_sections AS s ON s.id = a.sectionid
LEFT JOIN mos_users AS u ON u.id = a.created_by
LEFT JOIN mos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-07-29 16:24' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-29 16:24' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 0
AND s.access <= 0
AND cc.access <= 0
ORDER BY cc.ordering, a.created DESC
LIMIT 8
15
SELECT folder, element, published, params
FROM mos_mambots
WHERE access <= 0
AND folder = 'content'
ORDER BY ordering
16
SELECT a.*
FROM mos_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'
17
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m
INNER JOIN mos_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 = 1 )
ORDER BY ordering
18
SELECT count(*) AS numrows FROM mos_ugbanner
19
SELECT p.*
FROM mos_ugbanner_menu AS pm, mos_ugbanner AS p
WHERE (pm.menuid='1' OR pm.menuid='0') AND p.bid=pm.bid
AND p.showBanner=1 ORDER BY p.ordering ASC
20
SELECT p.*
FROM mos_ugbanner_menu AS pm, mos_ugbanner AS p
WHERE (pm.menuid='1' OR pm.menuid='0') AND p.bid=pm.bid
AND p.showBanner=1 ORDER BY p.ordering ASC
21
SELECT p.*
FROM mos_ugbanner_menu AS pm, mos_ugbanner AS p
WHERE (pm.menuid='1' OR pm.menuid='0') AND p.bid=pm.bid
AND p.showBanner=1 ORDER BY p.ordering ASC
22
UPDATE mos_ugbanner SET impmade=impmade+1 WHERE bid='47'
23
SELECT position FROM mos_modules WHERE module='mod_ugbanners'
24
SELECT position FROM mos_modules WHERE module='mod_ugbanners'
25
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
26
SELECT COUNT( id )
FROM mos_menu
WHERE type = 'content_typed'
AND published = 1
27
SELECT COUNT( id )
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
28
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=26'
29
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=32'
30
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=64'
31
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=66'
32
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=65'
33
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=172'
34
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=115'
35
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=42'
36
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=150'
37
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=151'
38
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=152'
39
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=153'
40
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=107'
41
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=108'
42
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=109'
43
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=110'
44
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=111'
45
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=112'
46
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=103'
47
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=104'
48
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=102'
49
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=105'
50
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=63'
51
SELECT m.*
FROM mos_menu AS m
WHERE menutype = 'topmenu'
AND published = 1
AND access <= 0
AND parent = 0
ORDER BY ordering
52
SELECT id
FROM mos_menu
WHERE link = 'index.php?option=com_search'
AND published = 1
53
SELECT *
FROM mos_tdihistory AS m
WHERE m.published = 1
AND (m.day = '29')
AND (m.month = '07')
ORDER BY RAND() LIMIT 1
54
SELECT id FROM mos_menu WHERE link LIKE '%com_today_in_history%' AND published = '1'
55
UPDATE mos_tdihistory SET displays=displays+1 WHERE id= 55
56
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 (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-07-29 21:24:37')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-29 21:24:37')
AND catid='1'
ORDER BY a.ordering ASC LIMIT 3
57
SELECT *
FROM mos_content
WHERE id = '184'
58
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 mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid = s.id
LEFT JOIN mos_menu AS ms ON ms.componentid = s.id
LEFT JOIN mos_categories AS c ON i.catid = c.id
LEFT JOIN mos_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 = 184
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
59
SELECT id
FROM mos_menu
WHERE type = 'content_blog_section'
AND published = 1
AND componentid = 0
60
SELECT id
FROM mos_menu
WHERE type = 'content_blog_category'
AND published = 1
AND componentid = 0
61
SELECT *
FROM mos_content
WHERE id = '182'
62
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 mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid = s.id
LEFT JOIN mos_menu AS ms ON ms.componentid = s.id
LEFT JOIN mos_categories AS c ON i.catid = c.id
LEFT JOIN mos_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 = 182
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
63
SELECT *
FROM mos_content
WHERE id = '181'
64
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 mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid = s.id
LEFT JOIN mos_menu AS ms ON ms.componentid = s.id
LEFT JOIN mos_categories AS c ON i.catid = c.id
LEFT JOIN mos_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 = 181
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id