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 jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(1,81,108,80,37,41,33,100,30,127,31,34,32,39,121,98,59,95,120,27,129,47,88,103,117,45,133,156,148,86,50,105,109,124,128,114,112,113,97,89,102,96,110,162,130,99,131,52,43,122,48,42,90,104,139,135,145,137,134,141,150,147,153,149,146,151,152,158,155,161,157,154,159,160)
AND jf_content.reference_table='menu'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 39)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_rsgallery2_config
SELECT *
FROM jos_rsgallery2_config
SELECT *
FROM jos_rsgallery2_galleries
WHERE id = '3'
ORDER BY ordering ASC
SELECT *
FROM jos_rsgallery2_files
WHERE gallery_id = 3
AND published = 1
ORDER BY ordering ASC
SELECT username
FROM jos_users
WHERE id = '62'
SELECT *
FROM jos_rsgallery2_galleries
WHERE parent = '3'
SELECT COUNT(1)
FROM jos_rsgallery2_files
WHERE gallery_id IN (3)
SELECT thumb_id
FROM jos_rsgallery2_galleries
WHERE id = '3'
SELECT *
FROM jos_rsgallery2_galleries
WHERE parent = '3'
SELECT name
FROM jos_rsgallery2_files
WHERE gallery_id IN (3)
AND published=1
ORDER BY rand()
LIMIT 1
UPDATE jos_rsgallery2_files
SET hits = hits + 1
WHERE id = 156
SELECT COUNT(1)
FROM jos_rsgallery2_files
WHERE gallery_id='3'
AND published = '1'
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 = 39 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(52,46,25,35,82,29,30,31,55,40,85,65,84,32,81,57,54,63,62,41,1)
AND jf_content.reference_table='modules'
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 22:09:53' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 22:09:53' )
AND cc.id = 11
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(84)
AND jf_content.reference_table='content'
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 9
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(23)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 23
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 12
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(35)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 35
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 4
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(5)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 5
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 10
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(30)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 30
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 8
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(19)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 19
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 22:09:53' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 22:09:53' )
AND cc.id = 8
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(62)
AND jf_content.reference_table='content'
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 22:09:53' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 22:09:53' )
AND cc.id = 7
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(63)
AND jf_content.reference_table='content'
SELECT *
FROM jos_jstats_configuration
SELECT exclude, type, tld, id, useragent
FROM jos_jstats_ipaddresses
WHERE ip = '54.234.180.187'
SELECT country_code2
FROM jos_jstats_iptocountry
WHERE inet_aton('54.234.180.187') >= ip_from
AND inet_aton('54.234.180.187') <= ip_to
SELECT t.tld_id AS tld_id, t.tld AS tld, t.fullname AS tld_name
FROM jos_jstats_topleveldomains t
WHERE t.tld=''
SELECT b.browser_id AS browser_id, b.browsertype_id AS browsertype_id, b.browser_key AS browser_key, b.browser_name AS browser_name, b.browser_img AS browser_img
FROM jos_jstats_browsers b
WHERE b.browser_id > 0
SELECT LENGTH(o.sys_string) AS strlen, o.sys_id AS os_id, o.sys_type AS ostype_id, o.sys_string AS os_key, o.sys_fullname AS os_name, o.sys_img AS os_img
FROM jos_jstats_systems o
WHERE o.sys_id > 0
ORDER BY strlen DESC
INSERT INTO jos_jstats_ipaddresses (ip, nslookup, useragent, tld, system, browser, type)
VALUES ('54.234.180.187', 'ec2-54-234-180-187.compute-1.amazonaws.com', 'ccbot/2.0', 'unknown', 'Unknown', 'Unknown Bot',2)
SELECT visit_id
FROM jos_jstats_visits
WHERE visitor_id = 75451
AND CAST(CONCAT(visit_date, ' ', visit_time) AS DATETIME) >= DATE_ADD('2013-05-18 23:09:53', INTERVAL -15 MINUTE)
INSERT INTO jos_jstats_visits (visitor_id, joomla_userid, visit_date, visit_time)
VALUES ( 75451, 0, '2013-05-18', '23:09:53' )
SELECT page_id, page_title
FROM jos_jstats_pages
WHERE page = 'http://www.elfentheater.be/index.php/en/pictures-performance?limit=1&start=26'
LIMIT 1
INSERT INTO `jos_jstats_impressions` (`page_id`, `visit_id`)
VALUES (248,342394)
SELECT id
FROM jos_plugins
WHERE element = 'legacy'
AND published = 0
SELECT *
FROM jos_facileforms_forms
WHERE name='nieuwsbrief'
AND published=1
ORDER BY ordering, id
SELECT id
FROM jos_users
WHERE lower(username)=lower('')
SELECT *
FROM jos_facileforms_forms
WHERE id = 13
SELECT *
FROM jos_facileforms_elements
WHERE form=13
AND published=1
ORDER BY page, ordering
SELECT name, code
FROM jos_facileforms_pieces
WHERE id=12
AND published=1
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_Constants'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_expstring'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_makePageUrl'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_makeFormUrl'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_makeSelfUrl'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_die'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_dying'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_redirect'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_redirectParentX'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_redirectPage'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_redirectForm'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_redirectSelf'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_setCheckedX'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_setSelectedX'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_setValueX'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_getPageByNameX'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_getParam'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_getSubmit'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_impString'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_securityImage'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_select'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_selectValue'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_query'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_markdown'
AND published=1
ORDER BY id DESC
SELECT name
FROM jos_facileforms_scripts
WHERE id=38
AND published=1
SELECT name
FROM jos_facileforms_scripts
WHERE id=37
AND published=1
SELECT name
FROM jos_facileforms_scripts
WHERE id=22
AND published=1
SELECT id, name, code
FROM jos_facileforms_scripts
WHERE published=1
ORDER BY type, title, name, id DESC
SELECT name, code
FROM jos_facileforms_scripts
WHERE id=31
AND published=1
SELECT name, code
FROM jos_facileforms_scripts
WHERE id=38
AND published=1
SELECT name, code
FROM jos_facileforms_scripts
WHERE id=37
AND published=1
SELECT name, code
FROM jos_facileforms_scripts
WHERE id=22
AND published=1
SELECT name, code
FROM jos_facileforms_scripts
WHERE id=36
AND published=1
SELECT name
FROM jos_facileforms_scripts
WHERE id=36
AND published=1
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 11
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(1)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 1
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 2
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(2)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 2
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 3
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(3)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 3
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 7
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(18)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 18
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 6
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 20
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(12,24,33,34,32,10,11,22,8,15,20,21,25,26,27,28,29,36)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 12
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 24
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 33
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 34
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 32
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 10
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 11
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 22
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 8
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 15
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 20
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 21
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 25
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 26
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 27
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 28
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 29
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 36
SELECT *
FROM jos_languages
WHERE active=1
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 jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(1,81,108,80,37,41,33,100,30,127,31,34,32,39,121,98,59,95,120,27,129,47,88,103,117,45,133,156,148,86,50,105,109,124,128,114,112,113,97,89,102,96,110,162,130,99,131,52,43,122,48,42,90,104,139,135,145,137,134,141,150,147,153,149,146,151,152,158,155,161,157,154,159,160)
AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(39)
AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=4
AND jf_content.published=1
AND jf_content.reference_id IN(39)
AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=5
AND jf_content.published=1
AND jf_content.reference_id IN(39)
AND jf_content.reference_table='menu'
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 jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(1,81,108,80,37,41,33,100,30,127,31,34,32,39,121,98,59,95,120,27,129,47,88,103,117,45,133,156,148,86,50,105,109,124,128,114,112,113,97,89,102,96,110,162,130,99,131,52,43,122,48,42,90,104,139,135,145,137,134,141,150,147,153,149,146,151,152,158,155,161,157,154,159,160)
AND jf_content.reference_table='menu'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 39)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_rsgallery2_config
SELECT *
FROM jos_rsgallery2_config
SELECT *
FROM jos_rsgallery2_galleries
WHERE id = '3'
ORDER BY ordering ASC
SELECT *
FROM jos_rsgallery2_files
WHERE gallery_id = 3
AND published = 1
ORDER BY ordering ASC
SELECT username
FROM jos_users
WHERE id = '62'
SELECT *
FROM jos_rsgallery2_galleries
WHERE parent = '3'
SELECT COUNT(1)
FROM jos_rsgallery2_files
WHERE gallery_id IN (3)
SELECT thumb_id
FROM jos_rsgallery2_galleries
WHERE id = '3'
SELECT *
FROM jos_rsgallery2_galleries
WHERE parent = '3'
SELECT name
FROM jos_rsgallery2_files
WHERE gallery_id IN (3)
AND published=1
ORDER BY rand()
LIMIT 1
UPDATE jos_rsgallery2_files
SET hits = hits + 1
WHERE id = 156
SELECT COUNT(1)
FROM jos_rsgallery2_files
WHERE gallery_id='3'
AND published = '1'
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 = 39 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(52,46,25,35,82,29,30,31,55,40,85,65,84,32,81,57,54,63,62,41,1)
AND jf_content.reference_table='modules'
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 22:09:53' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 22:09:53' )
AND cc.id = 11
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(84)
AND jf_content.reference_table='content'
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 9
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(23)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 23
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 12
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(35)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 35
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 4
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(5)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 5
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 10
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(30)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 30
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 8
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(19)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 19
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 22:09:53' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 22:09:53' )
AND cc.id = 8
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(62)
AND jf_content.reference_table='content'
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-18 22:09:53' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-18 22:09:53' )
AND cc.id = 7
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(63)
AND jf_content.reference_table='content'
SELECT *
FROM jos_jstats_configuration
SELECT exclude, type, tld, id, useragent
FROM jos_jstats_ipaddresses
WHERE ip = '54.234.180.187'
SELECT country_code2
FROM jos_jstats_iptocountry
WHERE inet_aton('54.234.180.187') >= ip_from
AND inet_aton('54.234.180.187') <= ip_to
SELECT t.tld_id AS tld_id, t.tld AS tld, t.fullname AS tld_name
FROM jos_jstats_topleveldomains t
WHERE t.tld=''
SELECT b.browser_id AS browser_id, b.browsertype_id AS browsertype_id, b.browser_key AS browser_key, b.browser_name AS browser_name, b.browser_img AS browser_img
FROM jos_jstats_browsers b
WHERE b.browser_id > 0
SELECT LENGTH(o.sys_string) AS strlen, o.sys_id AS os_id, o.sys_type AS ostype_id, o.sys_string AS os_key, o.sys_fullname AS os_name, o.sys_img AS os_img
FROM jos_jstats_systems o
WHERE o.sys_id > 0
ORDER BY strlen DESC
INSERT INTO jos_jstats_ipaddresses (ip, nslookup, useragent, tld, system, browser, type)
VALUES ('54.234.180.187', 'ec2-54-234-180-187.compute-1.amazonaws.com', 'ccbot/2.0', 'unknown', 'Unknown', 'Unknown Bot',2)
SELECT visit_id
FROM jos_jstats_visits
WHERE visitor_id = 75451
AND CAST(CONCAT(visit_date, ' ', visit_time) AS DATETIME) >= DATE_ADD('2013-05-18 23:09:53', INTERVAL -15 MINUTE)
INSERT INTO jos_jstats_visits (visitor_id, joomla_userid, visit_date, visit_time)
VALUES ( 75451, 0, '2013-05-18', '23:09:53' )
SELECT page_id, page_title
FROM jos_jstats_pages
WHERE page = 'http://www.elfentheater.be/index.php/en/pictures-performance?limit=1&start=26'
LIMIT 1
INSERT INTO `jos_jstats_impressions` (`page_id`, `visit_id`)
VALUES (248,342394)
SELECT id
FROM jos_plugins
WHERE element = 'legacy'
AND published = 0
SELECT *
FROM jos_facileforms_forms
WHERE name='nieuwsbrief'
AND published=1
ORDER BY ordering, id
SELECT id
FROM jos_users
WHERE lower(username)=lower('')
SELECT *
FROM jos_facileforms_forms
WHERE id = 13
SELECT *
FROM jos_facileforms_elements
WHERE form=13
AND published=1
ORDER BY page, ordering
SELECT name, code
FROM jos_facileforms_pieces
WHERE id=12
AND published=1
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_Constants'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_expstring'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_makePageUrl'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_makeFormUrl'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_makeSelfUrl'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_die'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_dying'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_redirect'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_redirectParentX'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_redirectPage'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_redirectForm'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_redirectSelf'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_setCheckedX'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_setSelectedX'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_setValueX'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_getPageByNameX'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_getParam'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_getSubmit'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_impString'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_securityImage'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_select'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_selectValue'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_query'
AND published=1
ORDER BY id DESC
SELECT id, code
FROM jos_facileforms_pieces
WHERE name='ff_markdown'
AND published=1
ORDER BY id DESC
SELECT name
FROM jos_facileforms_scripts
WHERE id=38
AND published=1
SELECT name
FROM jos_facileforms_scripts
WHERE id=37
AND published=1
SELECT name
FROM jos_facileforms_scripts
WHERE id=22
AND published=1
SELECT id, name, code
FROM jos_facileforms_scripts
WHERE published=1
ORDER BY type, title, name, id DESC
SELECT name, code
FROM jos_facileforms_scripts
WHERE id=31
AND published=1
SELECT name, code
FROM jos_facileforms_scripts
WHERE id=38
AND published=1
SELECT name, code
FROM jos_facileforms_scripts
WHERE id=37
AND published=1
SELECT name, code
FROM jos_facileforms_scripts
WHERE id=22
AND published=1
SELECT name, code
FROM jos_facileforms_scripts
WHERE id=36
AND published=1
SELECT name
FROM jos_facileforms_scripts
WHERE id=36
AND published=1
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 11
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(1)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 1
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 2
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(2)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 2
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 3
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(3)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 3
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 7
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(18)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 18
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 6
AND catid = 5
ORDER BY sticky DESC, ordering
LIMIT 0, 20
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(12,24,33,34,32,10,11,22,8,15,20,21,25,26,27,28,29,36)
AND jf_content.reference_table='banner'
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 12
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 24
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 33
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 34
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 32
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 10
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 11
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 22
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 8
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 15
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 20
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 21
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 25
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 26
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 27
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 28
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 29
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 36
SELECT *
FROM jos_languages
WHERE active=1
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 jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(1,81,108,80,37,41,33,100,30,127,31,34,32,39,121,98,59,95,120,27,129,47,88,103,117,45,133,156,148,86,50,105,109,124,128,114,112,113,97,89,102,96,110,162,130,99,131,52,43,122,48,42,90,104,139,135,145,137,134,141,150,147,153,149,146,151,152,158,155,161,157,154,159,160)
AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(39)
AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=4
AND jf_content.published=1
AND jf_content.reference_id IN(39)
AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=5
AND jf_content.published=1
AND jf_content.reference_id IN(39)
AND jf_content.reference_table='menu'