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='25' LIMIT 14
DELETE FROM mos_session
WHERE (time < 1283720215)5
SELECT * FROM mos_session WHERE session_id='a29ca13b71f954f797efcf789ffe0660'6
SELECT session_id FROM mos_session WHERE session_id=MD5('da3bd2882fa5b893117bd184c8afa8b1')7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'd41fabf38eda90c82c33946ce14fcc2a','1283721115','','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 ordering9
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 ordering10
SELECT access FROM mos_menu WHERE id='25'11
SELECT * FROM mos_menu WHERE id='25'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='25'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'13
SELECT * FROM mos_categories WHERE id='7'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='7'
AND mbf_content.reference_table='categories'
AND mbf_language.mambo='spanishi'15
SELECT * FROM mos_menu WHERE id='25'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='25'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'17
SELECT c.*, COUNT( b.id ) AS numitems
FROM mos_categories AS c
LEFT JOIN mos_content AS b ON b.catid = c.id
AND b.state='1'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-05 23:11:55' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-05 23:11:55' )
AND b.access <= '0'
WHERE c.section = '3'
AND c.published='1'
AND c.access <= '0'
GROUP BY c.id
HAVING COUNT( b.id ) > 0
ORDER BY c.ordering18
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='7'
AND mbf_content.reference_table='categories'
AND mbf_language.mambo='spanishi'19
SELECT COUNT(a.id) as numitems
FROM mos_content AS a
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.catid='7'
AND a.state='1'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-05 23:11:55' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-05 23:11:55' )
AND a.access<='0'
AND '0'<='0'
ORDER BY a.created DESC20
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 mos_content AS a
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.catid='7'
AND a.state='1'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-05 23:11:55' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-05 23:11:55' )
AND a.access<='0'
AND '0'<='0'
ORDER BY a.created DESC
LIMIT 0, 5021
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='365'
AND mbf_content.reference_table='content'
AND mbf_language.mambo='spanishi'22
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering23
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'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='2'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'25
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'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='23'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'27
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'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='5'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'29
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'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='26'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'31
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'32
SELECT a.id
FROM mos_components AS a
WHERE a.name = 'Syndicate'33
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'34
SELECT * FROM mos_components WHERE id='17'35
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'36
SELECT id FROM mos_mambots WHERE element = 'tinymce' AND folder = 'editors'37
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'38
SELECT * FROM mos_mambots WHERE id='10'39
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'40
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'41
SELECT * FROM mos_menu WHERE menutype = 'mainmenu' AND published ='1' AND parent = '0' ORDER BY ordering42
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'43
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'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='9'
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='23'
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='3'
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='5'
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='25'
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='26'
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='28'
AND mbf_content.reference_table='menu'
AND mbf_language.mambo='spanishi'51
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 = '25' OR mm.menuid = '0')
ORDER BY ordering52
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'53
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'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='2'
AND mbf_content.reference_table='modules'
AND mbf_language.mambo='spanishi'55
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'56
SELECT m.* FROM mos_menu AS m
WHERE menutype='Menu_Usuario' AND published='1' AND access <= '0'
ORDER BY parent,ordering57
SELECT m.* FROM mos_menu AS m
WHERE menutype='Menu_Administrador' AND published='1' AND access <= '0'
ORDER BY parent,ordering58
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'59
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=160
SELECT * FROM mos_banner WHERE showBanner=1 LIMIT 2,161
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='12'