Portada Noticias/Albisteak Bitácora Enlaces Contacto Busqueda/Aurki Dudas Frecuentes Foros/Gunea Download MambelFish debug: name= id=18 reference_table=modules language=spanishi class=stdClass MambelFish debug: name= id=15 reference_table=modules language=spanishi class=stdClass MambelFish debug: name= id=2 reference_table=modules language=spanishi class=stdClass MambelFish debug: name= id=31 reference_table=modules language=spanishi class=stdClass Menu Usuario Admin MambelFish debug: name=Administrador id=11 reference_table=menu language=spanishi class=stdClass Administrador   MambelFish debug: name= id=592 reference_table=content language=spanishi class=stdClass MambelFish debug: name= id=519 reference_table=content language=spanishi class=stdClass MambelFish debug: name= id=20 reference_table=mambots language=spanishi class=stdClass MambelFish debug: name=AllVideos Plugin id=20 reference_table=mambots language=spanishi class=mosMambot MambelFish debug: name= id=20 reference_table=mambots language=spanishi class=stdClass MambelFish debug: name=AllVideos Plugin id=20 reference_table=mambots language=spanishi class=mosMambot MambelFish debug: name= id=20 reference_table=mambots language=spanishi class=stdClass MambelFish debug: name=AllVideos Plugin id=20 reference_table=mambots language=spanishi class=mosMambot MambelFish debug: name= id=20 reference_table=mambots language=spanishi class=stdClass MambelFish debug: name=AllVideos Plugin id=20 reference_table=mambots language=spanishi class=mosMambot MambelFish debug: name= id=16 reference_table=mambots language=spanishi class=stdClass MambelFish debug: name=Email Cloaking id=16 reference_table=mambots language=spanishi class=mosMambot Terremoto en Haití Escrito por Admin    18.01.2010  www.lanbi.org Siguiente > [ Atrás ]       Buscar-bilatu   Portada Noticias/Albisteak Bitácora Enlaces Contacto Busqueda/Aurki Dudas Frecuentes Foros/Gunea Download Copyright © 2005 by Visioon Web

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 < 1283720349)
5
SELECT * FROM mos_session WHERE session_id='672ca2b9158345bfa52d17084a991bf1'
6
SELECT session_id FROM mos_session WHERE session_id=MD5('4df9604276decadec08380f0b4fe6840')
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'd0f8acc36df769123a9815899d7074c7','1283721249','','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='592' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-05 23:14:09')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-05 23:14:09')
 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='592'
   AND mbf_content.reference_table='content'
	AND mbf_language.mambo='spanishi'
13
SELECT a.id
 FROM mos_content AS a
 WHERE a.catid = 24
 AND a.state = 1 AND ordering < 1
 AND a.access <= '0'
 ORDER BY a.ordering DESC
 LIMIT 1
14
SELECT a.id
 FROM mos_content AS a
 WHERE a.catid = 24
 AND a.state = 1 AND ordering > 1
 AND a.access <= '0'
 ORDER BY a.ordering
 LIMIT 1
15
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='519'
   AND mbf_content.reference_table='content'
	AND mbf_language.mambo='spanishi'
16
UPDATE mos_content SET hits=(hits+1) WHERE id='592'
17
SELECT hits
FROM mos_core_log_items
WHERE time_stamp='2010-09-05' AND item_table='#__content' AND item_id='592'
18
UPDATE mos_core_log_items SET hits=(hits+1)
WHERE time_stamp='2010-09-05' AND item_table='#__content' AND item_id='592'
19
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
20
SELECT id FROM mos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
21
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'
22
SELECT * FROM mos_mambots WHERE id='20'
23
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'
24
SELECT id FROM mos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
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='20'
   AND mbf_content.reference_table='mambots'
	AND mbf_language.mambo='spanishi'
26
SELECT * FROM mos_mambots WHERE id='20'
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='20'
   AND mbf_content.reference_table='mambots'
	AND mbf_language.mambo='spanishi'
28
SELECT id FROM mos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
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='20'
   AND mbf_content.reference_table='mambots'
	AND mbf_language.mambo='spanishi'
30
SELECT * FROM mos_mambots WHERE id='20'
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='20'
   AND mbf_content.reference_table='mambots'
	AND mbf_language.mambo='spanishi'
32
SELECT id FROM mos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
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='20'
   AND mbf_content.reference_table='mambots'
	AND mbf_language.mambo='spanishi'
34
SELECT * FROM mos_mambots WHERE id='20'
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='20'
   AND mbf_content.reference_table='mambots'
	AND mbf_language.mambo='spanishi'
36
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
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='16'
   AND mbf_content.reference_table='mambots'
	AND mbf_language.mambo='spanishi'
38
SELECT * FROM mos_mambots WHERE id='16'
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='16'
   AND mbf_content.reference_table='mambots'
	AND mbf_language.mambo='spanishi'
40
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'
41
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'
42
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
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='1'
   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='2'
   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='9'
   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='23'
   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='3'
   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='5'
   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='25'
   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='26'
   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='28'
   AND mbf_content.reference_table='menu'
	AND mbf_language.mambo='spanishi'
52
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
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='17'
   AND mbf_content.reference_table='components'
	AND mbf_language.mambo='spanishi'
54
SELECT * FROM mos_components WHERE id='17'
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='17'
   AND mbf_content.reference_table='components'
	AND mbf_language.mambo='spanishi'
56
SELECT id FROM mos_mambots WHERE element = 'tinymce' AND folder = 'editors'
57
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'
58
SELECT * FROM mos_mambots WHERE id='10'
59
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'
60
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
61
SELECT * FROM mos_menu WHERE menutype = 'mainmenu' AND published ='1' AND parent = '0' ORDER BY ordering
62
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'
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='2'
   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='9'
   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='23'
   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='3'
   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='5'
   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='25'
   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='26'
   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='28'
   AND mbf_content.reference_table='menu'
	AND mbf_language.mambo='spanishi'
71
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
72
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'
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='15'
   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='2'
   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='31'
   AND mbf_content.reference_table='modules'
	AND mbf_language.mambo='spanishi'
76
SELECT m.* FROM mos_menu AS m
WHERE menutype='Menu_Usuario' AND published='1' AND access <= '0'
ORDER BY parent,ordering
77
SELECT m.* FROM mos_menu AS m
WHERE menutype='Menu_Administrador' AND published='1' AND access <= '0'
ORDER BY parent,ordering
78
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'
79
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
80
SELECT * FROM mos_banner WHERE showBanner=1 LIMIT 3,1
81
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='21'