SELECT *
FROM jos_session
WHERE session_id = '35tvsb36gvbsqe440ukivrqpk5'
DELETE
FROM jos_session
WHERE ( time < '1280498307' )
SELECT *
FROM jos_session
WHERE session_id = '35tvsb36gvbsqe440ukivrqpk5'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '35tvsb36gvbsqe440ukivrqpk5','1280499207','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT published
FROM jos_plugins
WHERE element = 'jceembed' OR element = 'mediaobject'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 159)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT COUNT(*)
FROM jos_tpwebgallery_items
WHERE published=1
AND approved=1
AND deleted=0
SELECT a.*, b.name AS regname
FROM jos_tpwebgallery_items AS a
LEFT JOIN jos_users AS b
ON a.userid=b.id
WHERE a.published=1
AND a.approved=1
AND deleted=0
ORDER BY a.id DESC
LIMIT 0, 9
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=22
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=21
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=20
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=19
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=18
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=17
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=16
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=15
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=14
SELECT DISTINCT position
FROM jos_modules
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 159 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT m.*, sum(case when p.published=1 then 1 else 0 end) AS cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p
ON p.parent = m.id
WHERE m.menutype='mainmenu'
AND m.published='1'
AND m.access <= '0'
GROUP BY m.id
ORDER BY m.parent, m.ordering
SELECT m.*
FROM jos_menu AS m
WHERE menutype='mainmenu'
AND m.published='1'
SELECT DISTINCT position
FROM jos_modules
SELECT (SUM(vr.votesum)/SUM(vr.votecount)) AS vote,
SUM(vr.votesum) AS votesum,
SUM(vr.votecount) AS votecount,
b.title AS cattitle,
a.*
FROM jos_tpwebgallery_items AS a
INNER JOIN jos_tpwebgallery_categories AS b
ON a.catid=b.id
AND b.published=1
LEFT JOIN jos_tpwebgallery_vote_result AS vr
ON vr.itemid=a.id
LEFT JOIN jos_tpwebgallery_votes AS v
ON v.id=vr.voteid
AND v.published=1
WHERE a.published=1
AND a.approved=1
AND a.deleted=0
GROUP BY a.id
ORDER BY vote ASC
LIMIT 5
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=13
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=15
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=16
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=20
SELECT COUNT(*)
FROM jos_tpwebgallery_votes
WHERE published=1
SELECT SUM(votecount) AS vc, SUM(votesum) AS vs
FROM jos_tpwebgallery_vote_result
WHERE itemid=22
SELECT DISTINCT(a.userid), count(a.id) AS items, b.lastvisitDate
FROM jos_tpwebgallery_items AS a
INNER JOIN jos_users AS b
ON a.userid=b.id
WHERE a.published=1
AND a.approved=1
AND a.deleted=0
AND b.block=0
GROUP BY a.userid
ORDER BY a.id DESC
LIMIT 5
SELECT a.*, COUNT(c.id) AS countitems
FROM jos_tpwebgallery_tags AS a
INNER JOIN jos_tpwebgallery_item_tag AS b
ON a.id=b.tagid
INNER JOIN jos_tpwebgallery_items AS c
ON c.id=b.itemid
AND c.published=1
AND c.approved=1
AND c.deleted=0
WHERE a.published=1
GROUP BY a.id
ORDER BY a.title ASC
LIMIT 5
SELECT a.*
FROM jos_tpwebgallery_items AS a
INNER JOIN jos_tpwebgallery_categories AS b
ON a.catid=b.id
AND b.published=1
WHERE a.catid=1
AND a.published=1
AND a.approved=1
AND a.deleted=0
AND b.published=1
ORDER BY a.id DESC
LIMIT 5
SELECT a.*
FROM jos_tpwebgallery_items AS a
INNER JOIN jos_tpwebgallery_categories AS b
ON a.catid=b.id
AND b.published=1
WHERE a.catid=2
AND a.published=1
AND a.approved=1
AND a.deleted=0
AND b.published=1
ORDER BY a.id DESC
LIMIT 5
SELECT a.*
FROM jos_tpwebgallery_items AS a
INNER JOIN jos_tpwebgallery_categories AS b
ON a.catid=b.id
AND b.published=1
WHERE a.catid=3
AND a.published=1
AND a.approved=1
AND a.deleted=0
AND b.published=1
ORDER BY a.id DESC
LIMIT 5
TPWebGallery
Designed by 
