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 template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 84)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT i.*, c.title AS cattitle, c.image AS catimage, c.gallery AS catgallery
FROM jos_stocklist AS i, jos_stocklist_categories AS c
WHERE c.id=i.catid
AND i.published>0
AND c.published>0
ORDER BY c.ordering ASC, i.ordering ASC
LIMIT 0, 10
SELECT i.*, c.title AS cattitle, c.image AS catimage, c.gallery AS catgallery
FROM jos_stocklist AS i, jos_stocklist_categories AS c
WHERE c.id=i.catid
AND i.published>0
AND c.published>0
ORDER BY c.ordering ASC, i.ordering ASC
SELECT id, description
FROM jos_stocklist_categories
WHERE id IN (41,43,40)
SELECT introtext
FROM jos_content
WHERE id=73
SELECT name
FROM jos_stocklist
SELECT sciname
FROM jos_stocklist
SELECT title
FROM jos_stocklist_categories
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 = 84 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT *
FROM jos_bion_data
SELECT count(s.`id`) AS c
FROM `jos_stocklist` AS s
WHERE s.`hotoffers`=1
AND s.`published`=1
SELECT *
FROM jos_bionmodules
WHERE groupid=12
ORDER BY RAND()
LIMIT 0,1
SELECT FLOOR(RAND()*COUNT(id))
FROM jos_stocklist
WHERE hotoffers=1
AND published=1
SELECT s.`name` AS cname, s.`sciname` AS sciname, s.`gallery` AS gallery
FROM `jos_stocklist` AS s
WHERE s.`hotoffers`=1
AND s.`published`=1
LIMIT 0,1
SELECT id, parent_id
FROM jos_mediagallery_categories
SELECT FLOOR(RAND()*COUNT(id))
FROM jos_mediagallery
WHERE catid IN(104)
AND published=1
AND type=1
SELECT *
FROM jos_mediagallery
WHERE catid IN(104)
AND published=1
AND type=1
LIMIT 3,1
