|
|||||||||||||||||||||||||||||||||||
1 SELECT * FROM mos_mbf_language WHERE iso='es_ES'
2 SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
3 SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='9' LIMIT 1
4 DELETE FROM mos_session WHERE (time < 1283717863)
5 SELECT * FROM mos_session WHERE session_id='65cfe4bcd6187b84dbe827b09c9a0048'
6 SELECT session_id FROM mos_session WHERE session_id=MD5('2174e3460622df55ea716460dfcb033c')
7 INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '9a5743f409bc452f11e7b3470422dd71','1283718763','','0','1' )
8 SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup FROM mos_mambots WHERE published >= 1 AND access <= 0 AND folder='editors' ORDER BY ordering
9 SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup FROM mos_mambots WHERE published >= 1 AND access <= 0 AND folder='editors-xtd' ORDER BY ordering
10 SELECT access FROM mos_menu WHERE id='9'
11 SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups 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_content_rating AS v ON a.id = v.content_id LEFT JOIN mos_groups AS g ON a.access = g.id WHERE a.id='711' AND (a.state = '1' OR a.state = '-1') AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-05 22:32:43') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-05 22:32:43') AND a.access <= 0
12 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='711' AND mbf_content.reference_table='content' AND mbf_language.mambo='spanishi'
13 SELECT a.id FROM mos_content AS a WHERE a.catid = 17 AND a.state = 1 AND ordering < 6 AND a.access <= '0' ORDER BY a.ordering DESC LIMIT 1
14 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='714' AND mbf_content.reference_table='content' AND mbf_language.mambo='spanishi'
15 SELECT a.id FROM mos_content AS a WHERE a.catid = 17 AND a.state = 1 AND ordering > 6 AND a.access <= '0' ORDER BY a.ordering LIMIT 1
16 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='710' AND mbf_content.reference_table='content' AND mbf_language.mambo='spanishi'
17 UPDATE mos_content SET hits=(hits+1) WHERE id='711'
18 SELECT hits FROM mos_core_log_items WHERE time_stamp='2010-09-05' AND item_table='#__content' AND item_id='711'
19 UPDATE mos_core_log_items SET hits=(hits+1) WHERE time_stamp='2010-09-05' AND item_table='#__content' AND item_id='711'
20 SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup FROM mos_mambots WHERE published >= 1 AND access <= 0 AND folder='content' ORDER BY ordering
21 SELECT id FROM mos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
22 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='20' AND mbf_content.reference_table='mambots' AND mbf_language.mambo='spanishi'
23 SELECT * FROM mos_mambots WHERE id='20'
24 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='20' AND mbf_content.reference_table='mambots' AND mbf_language.mambo='spanishi'
25 SELECT id FROM mos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
26 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='20' AND mbf_content.reference_table='mambots' AND mbf_language.mambo='spanishi'
27 SELECT * FROM mos_mambots WHERE id='20'
28 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='20' AND mbf_content.reference_table='mambots' AND mbf_language.mambo='spanishi'
29 SELECT id FROM mos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
30 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='20' AND mbf_content.reference_table='mambots' AND mbf_language.mambo='spanishi'
31 SELECT * FROM mos_mambots WHERE id='20'
32 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='20' AND mbf_content.reference_table='mambots' AND mbf_language.mambo='spanishi'
33 SELECT id FROM mos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
34 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='20' AND mbf_content.reference_table='mambots' AND mbf_language.mambo='spanishi'
35 SELECT * FROM mos_mambots WHERE id='20'
36 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='20' AND mbf_content.reference_table='mambots' AND mbf_language.mambo='spanishi'
37 SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
38 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='16' AND mbf_content.reference_table='mambots' AND mbf_language.mambo='spanishi'
39 SELECT * FROM mos_mambots WHERE id='16'
40 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='16' AND mbf_content.reference_table='mambots' AND mbf_language.mambo='spanishi'
41 SELECT g.* FROM mos_core_acl_aro_groups AS g INNER JOIN mos_core_acl_groups_aro_map AS gm ON gm.group_id = g.group_id INNER JOIN mos_core_acl_aro AS ao ON ao.aro_id = gm.aro_id WHERE ao.value='62'
42 SELECT COUNT(*) FROM mos_core_acl_aro_groups AS g1 LEFT JOIN mos_core_acl_aro_groups AS g2 ON g1.lft > g2.lft AND g1.lft < g2.rgt WHERE g1.group_id='25' AND g2.name='Public Frontend'
43 SELECT m.* FROM mos_menu AS m WHERE menutype='mainmenu' AND published='1' AND access <= '0' ORDER BY parent,ordering
44 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='1' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
45 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='2' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
46 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='9' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
47 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='23' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
48 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='3' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
49 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='5' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
50 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='25' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
51 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='26' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
52 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='28' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
53 SELECT a.id FROM mos_components AS a WHERE a.name = 'Syndicate'
54 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='17' AND mbf_content.reference_table='components' AND mbf_language.mambo='spanishi'
55 SELECT * FROM mos_components WHERE id='17'
56 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='17' AND mbf_content.reference_table='components' AND mbf_language.mambo='spanishi'
57 SELECT id FROM mos_mambots WHERE element = 'tinymce' AND folder = 'editors'
58 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='10' AND mbf_content.reference_table='mambots' AND mbf_language.mambo='spanishi'
59 SELECT * FROM mos_mambots WHERE id='10'
60 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='10' AND mbf_content.reference_table='mambots' AND mbf_language.mambo='spanishi'
61 SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
62 SELECT * FROM mos_menu WHERE menutype = 'mainmenu' AND published ='1' AND parent = '0' ORDER BY ordering
63 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='1' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
64 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='2' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
65 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='9' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
66 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='23' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
67 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='3' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
68 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='5' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
69 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='25' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
70 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='26' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
71 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='28' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
72 SELECT id, title, module, position, content, showtitle, params FROM mos_modules AS m, mos_modules_menu AS mm WHERE m.published='1' AND m.access <= '0' AND m.client_id='0' AND mm.moduleid=m.id AND (mm.menuid = '9' OR mm.menuid = '0') ORDER BY ordering
73 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='18' AND mbf_content.reference_table='modules' AND mbf_language.mambo='spanishi'
74 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='15' AND mbf_content.reference_table='modules' AND mbf_language.mambo='spanishi'
75 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='2' AND mbf_content.reference_table='modules' AND mbf_language.mambo='spanishi'
76 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='31' AND mbf_content.reference_table='modules' AND mbf_language.mambo='spanishi'
77 SELECT m.* FROM mos_menu AS m WHERE menutype='Menu_Usuario' AND published='1' AND access <= '0' ORDER BY parent,ordering
78 SELECT m.* FROM mos_menu AS m WHERE menutype='Menu_Administrador' AND published='1' AND access <= '0' ORDER BY parent,ordering
79 SELECT mbf_content.reference_field, mbf_content.value FROM mos_mbf_content AS mbf_content, mos_mbf_language as mbf_language WHERE mbf_content.language_id=mbf_language.id AND mbf_content.published=1 AND mbf_content.reference_id='11' AND mbf_content.reference_table='menu' AND mbf_language.mambo='spanishi'
80 SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
81 SELECT * FROM mos_banner WHERE showBanner=1 LIMIT 3,1
82 UPDATE mos_banner SET impmade=impmade+1 WHERE bid='21'