Obras y Proyectos

82 queries executed
1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 32 ) ORDER BY menuid DESC LIMIT 1
3 DELETE FROM jos_session WHERE ( ( time < '1284007516' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1284007516' ) AND guest = 1 AND userid = 0 )
4 SELECT * FROM jos_menu WHERE id = 32
5 SELECT priv_upload, priv_editmedium, priv_delmedium, priv_creategal, priv_editgal, priv_delgal FROM jos_zoom_priv WHERE gid = '0'
6 DELETE FROM jos_zoom_editmon WHERE vote_time < '1284008416' OR comment_time < '1284008416' OR pass_time < '1284008416'
7 SELECT lightbox_file FROM jos_zoom_editmon WHERE lightbox_time < '1284008416'
8 SELECT cat.catkeywords, img.imgkeywords AS keywords FROM jos_zoom as cat LEFT JOIN jos_zoomfiles AS img ON cat.catid WHERE cat.published = 1 AND cat.catkeywords <> '' AND cat.catpassword = '' AND img.published = 1 AND img.imgkeywords <> ''
9 SELECT catid FROM jos_zoom WHERE subcat_id=0 AND pos=0 AND published=1 ORDER BY custom_order, catid ASC
10 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=9 LIMIT 1
11 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=9 LIMIT 1
12 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=10 LIMIT 1
13 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=10 LIMIT 1
14 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=11 LIMIT 1
15 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=11 LIMIT 1
16 SELECT pos FROM jos_zoom WHERE catid = 9 LIMIT 1
17 SELECT imgid FROM jos_zoomfiles WHERE catid=9 ORDER BY imgdate ASC LIMIT 1
18 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM jos_zoomfiles WHERE imgid=71
19 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM jos_zoomfiles WHERE imgid=71
20 SELECT catdir FROM jos_zoom WHERE catid=9
21 SELECT catdir FROM jos_zoom WHERE catid=9
22 SELECT cmtid FROM jos_zoom_comments WHERE imgid = 71 ORDER BY cmtdate ASC
23 SELECT catdir FROM jos_zoom WHERE catid=9
24 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=9 LIMIT 1
25 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=9 LIMIT 1
26 SELECT catid FROM jos_zoom WHERE subcat_id=9 ORDER BY custom_order, catid ASC
27 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=4 LIMIT 1
28 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=4 LIMIT 1
29 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=5 LIMIT 1
30 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=5 LIMIT 1
31 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=8 LIMIT 1
32 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=8 LIMIT 1
33 SELECT imgid FROM jos_zoomfiles WHERE catid = 9 AND published = 1 ORDER BY imgdate ASC
34 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM jos_zoomfiles WHERE imgid=71
35 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM jos_zoomfiles WHERE imgid=71
36 SELECT catdir FROM jos_zoom WHERE catid=9
37 SELECT catdir FROM jos_zoom WHERE catid=9
38 SELECT cmtid FROM jos_zoom_comments WHERE imgid = 71 ORDER BY cmtdate ASC
39 SELECT catdir FROM jos_zoom WHERE catid=9
40 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM jos_zoomfiles WHERE imgid=150
41 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM jos_zoomfiles WHERE imgid=150
42 SELECT catdir FROM jos_zoom WHERE catid=10
43 SELECT catdir FROM jos_zoom WHERE catid=10
44 SELECT cmtid FROM jos_zoom_comments WHERE imgid = 150 ORDER BY cmtdate ASC
45 SELECT catdir FROM jos_zoom WHERE catid=10
46 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=10 LIMIT 1
47 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=10 LIMIT 1
48 SELECT catid FROM jos_zoom WHERE subcat_id=10 ORDER BY custom_order, catid ASC
49 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=6 LIMIT 1
50 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=6 LIMIT 1
51 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=7 LIMIT 1
52 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=7 LIMIT 1
53 SELECT imgid FROM jos_zoomfiles WHERE catid = 10 AND published = 1 ORDER BY imgdate ASC
54 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM jos_zoomfiles WHERE imgid=150
55 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM jos_zoomfiles WHERE imgid=150
56 SELECT catdir FROM jos_zoom WHERE catid=10
57 SELECT catdir FROM jos_zoom WHERE catid=10
58 SELECT cmtid FROM jos_zoom_comments WHERE imgid = 150 ORDER BY cmtdate ASC
59 SELECT catdir FROM jos_zoom WHERE catid=10
60 SELECT pos FROM jos_zoom WHERE catid = 11 LIMIT 1
61 SELECT imgid FROM jos_zoomfiles WHERE catid=11 ORDER BY imgdate ASC LIMIT 1
62 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM jos_zoomfiles WHERE imgid=70
63 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM jos_zoomfiles WHERE imgid=70
64 SELECT catdir FROM jos_zoom WHERE catid=11
65 SELECT catdir FROM jos_zoom WHERE catid=11
66 SELECT cmtid FROM jos_zoom_comments WHERE imgid = 70 ORDER BY cmtdate ASC
67 SELECT catdir FROM jos_zoom WHERE catid=11
68 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=11 LIMIT 1
69 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=11 LIMIT 1
70 SELECT catid FROM jos_zoom WHERE subcat_id=11 ORDER BY custom_order, catid ASC
71 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=3 LIMIT 1
72 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, catkeywords, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM jos_zoom WHERE catid=3 LIMIT 1
73 SELECT imgid FROM jos_zoomfiles WHERE catid = 11 AND published = 1 ORDER BY imgdate ASC
74 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM jos_zoomfiles WHERE imgid=70
75 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM jos_zoomfiles WHERE imgid=70
76 SELECT catdir FROM jos_zoom WHERE catid=11
77 SELECT catdir FROM jos_zoom WHERE catid=11
78 SELECT cmtid FROM jos_zoom_comments WHERE imgid = 70 ORDER BY cmtdate ASC
79 SELECT catdir FROM jos_zoom WHERE catid=11
80 SELECT a.* FROM jos_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'
81 SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_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 = 32 ) ORDER BY ordering
82 SELECT m.* FROM jos_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering