 |
Menu Principal |
 |
| |
|
Exclusivo Exparticipantes |
|
|
|
Exclusivo Exparticipantes |
|
|
|
|
 |
|
 |
|
|
|
|
© 2010 Grupo Corporativo de Ejecutivos Consultores
Joomla! es Software Libre distribuido bajo licencia GNU/GPL.
|
61 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 template
FROM mos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 1 )
ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM mos_session
WHERE (
( time < '1283711754' )
AND guest = 0
AND gid > 0
) OR (
( time < '1283714454' )
AND guest = 1
AND userid = 0
)
5
SELECT *
FROM mos_session
WHERE session_id = 'baa38ebc5a3ed2306a4498f9a6dccaae'
6
SELECT session_id
FROM mos_session
WHERE session_id = 'de21c69615e66bce923e6acd8c318400'
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'de21c69615e66bce923e6acd8c318400','1283715354','','0','1' )
8
SELECT *
FROM mos_menu
WHERE id = 1
9
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
s.id AS sec_id, cc.id as cat_id
FROM mos_content AS a
LEFT JOIN mos_categories AS cc ON cc.id = a.catid
LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope = 'content'
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.id = 182 AND ( a.state = 1 OR a.state = -1 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-05 14:35' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 14:35' )
AND a.access <= 0
10
SELECT a.id
FROM mos_content AS a
WHERE a.catid = 1
AND a.state = 1
AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-05 14:35' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 14:35' )
ORDER BY a.created DESC
11
UPDATE mos_content
SET hits = ( hits + 1 )
WHERE id = '182'
12
SELECT folder, element, published, params
FROM mos_mambots
WHERE access <= 0
AND folder = 'content'
ORDER BY ordering
13
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'
14
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
15
SELECT count(*) AS numrows FROM mos_ugbanner
16
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
17
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
18
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
19
UPDATE mos_ugbanner SET impmade=impmade+1 WHERE bid='47'
20
SELECT position FROM mos_modules WHERE module='mod_ugbanners'
21
SELECT position FROM mos_modules WHERE module='mod_ugbanners'
22
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
23
SELECT COUNT( id )
FROM mos_menu
WHERE type = 'content_typed'
AND published = 1
24
SELECT COUNT( id )
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
25
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=26'
26
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=32'
27
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=64'
28
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=66'
29
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=65'
30
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=172'
31
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=115'
32
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=42'
33
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=150'
34
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=151'
35
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=152'
36
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=153'
37
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=107'
38
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=108'
39
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=109'
40
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=110'
41
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=111'
42
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=112'
43
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=103'
44
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=104'
45
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=102'
46
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=105'
47
SELECT id
FROM mos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=63'
48
SELECT m.*
FROM mos_menu AS m
WHERE menutype = 'topmenu'
AND published = 1
AND access <= 0
AND parent = 0
ORDER BY ordering
49
SELECT id
FROM mos_menu
WHERE link = 'index.php?option=com_search'
AND published = 1
50
SELECT *
FROM mos_tdihistory AS m
WHERE m.published = 1
AND (m.day = '05')
AND (m.month = '09')
ORDER BY RAND() LIMIT 1
51
SELECT id FROM mos_menu WHERE link LIKE '%com_today_in_history%' AND published = '1'
52
UPDATE mos_tdihistory SET displays=displays+1 WHERE id= 93
53
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-09-05 19:35:54')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 19:35:54')
AND catid='1'
ORDER BY a.ordering ASC LIMIT 3
54
SELECT *
FROM mos_content
WHERE id = '184'
55
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
56
SELECT id
FROM mos_menu
WHERE type = 'content_blog_section'
AND published = 1
AND componentid = 0
57
SELECT id
FROM mos_menu
WHERE type = 'content_blog_category'
AND published = 1
AND componentid = 0
58
SELECT *
FROM mos_content
WHERE id = '182'
59
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
60
SELECT *
FROM mos_content
WHERE id = '181'
61
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
