SELECT *
FROM `hjts_admintools_ipautoban`
WHERE `ip` = '54.224.89.34'
SELECT `value`
FROM `hjts_admintools_storage`
WHERE `key` = 'cparams'
SELECT `source`
FROM `hjts_admintools_redirects`
WHERE (`dest` = 'index.php' OR `dest` = 'index.php?option=com_djclassifieds&view=show&cid=29&order=description&Itemid=63&lang=en')
AND `published` = 1
ORDER BY `ordering` DESC
LIMIT 0,1
SELECT m.*, c.`option` AS component
FROM hjts_menu AS m
LEFT JOIN hjts_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 hjts_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(11,20,28,40,67,68,69,62,61,85,12,38,29,44,51,73,81,86,63,13,18,43,45,52,89,82,14,24,30,46,64,90,87,15,47,65,83,88,16,56,84,93,17,57,94,58,95,1,2,27,72,41)
AND jf_content.reference_table='menu'
SELECT COUNT(id)
FROM hjts_djcf_categories
WHERE published = 1
AND parent_id=29
SELECT template
FROM hjts_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 63)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM hjts_djcf_categories
WHERE published = 1
ORDER BY ordering
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM hjts_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(1,6,30,2,7,31,3,8,9,32,4,27,33,5,25,26,28,29,34,35,36,39)
AND jf_content.reference_table='djcf_categories'
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM hjts_modules AS m
LEFT JOIN hjts_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 = 63 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 hjts_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(49,77,67,33,43,50,74,39,58,60,85,36,25,63,64,65,29)
AND jf_content.reference_table='modules'
SELECT COUNT(*)
FROM hjts_djcf_items
WHERE date_exp > '2018-10-19'
AND published = 1
AND cat_id IN (30)
SELECT COUNT(*)
FROM hjts_djcf_items
WHERE date_exp > '2018-10-19'
AND published = 1
AND cat_id IN (31)
SELECT COUNT(*)
FROM hjts_djcf_items
WHERE date_exp > '2018-10-19'
AND published = 1
AND cat_id IN (32)
SELECT COUNT(*)
FROM hjts_djcf_items
WHERE date_exp > '2018-10-19'
AND published = 1
AND cat_id IN (33)
SELECT i.*, c.name AS c_name, c.id AS c_id
FROM hjts_djcf_items i, hjts_djcf_categories c
WHERE i.cat_id = c.id
AND i.cat_id IN (30,31,32,33,29)
AND i.date_exp > '2018-10-19'
AND i.published = 1
ORDER BY i.special DESC, i.intro_desc
LIMIT 0, 10
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM hjts_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(343,346,329)
AND jf_content.reference_table='djcf_items'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM hjts_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(30,33)
AND jf_content.reference_table='djcf_categories'
SELECT COUNT(*)
FROM hjts_djcf_items
WHERE date_exp > '2018-10-19'
AND published = 1
AND cat_id IN (30,31,32,33,29)
SELECT params
FROM hjts_components AS c
WHERE c.OPTION='com_widgetkit'
SELECT *
FROM hjts_djcf_categories
WHERE published = 1
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM hjts_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(1,2,3,4,5,6,7,8,9,25,26,27,28,29,30,31,32,33,34,35,36,39)
AND jf_content.reference_table='djcf_categories'
SELECT *
FROM hjts_languages
WHERE active=1
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM hjts_menu AS m
LEFT JOIN hjts_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 hjts_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(11,20,28,40,67,68,69,62,61,85,12,38,29,44,51,73,81,86,63,13,18,43,45,52,89,82,14,24,30,46,64,90,87,15,47,65,83,88,16,56,84,93,17,57,94,58,95,1,2,27,72,41)
AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM hjts_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(63)
AND jf_content.reference_table='menu'
SELECT `value`
FROM `hjts_admintools_storage`
WHERE `key` = 'cparams'
