SELECT *
FROM `hjts_admintools_ipautoban`
WHERE `ip` = '23.20.245.192'
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=showlist&cid=36&order=display&Itemid=63&lang=mk')
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=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 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
AND id = 36
ORDER BY ordering
LIMIT 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=2
AND jf_content.published=1
AND jf_content.reference_id IN(36)
AND jf_content.reference_table='djcf_categories'
SELECT *
FROM hjts_djcf_items
WHERE cat_id = (36)
AND date_exp > '2018-04-23'
AND published = 1
ORDER BY special DESC, display 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=2
AND jf_content.published=1
AND jf_content.reference_id IN(287,310,353)
AND jf_content.reference_table='djcf_items'
SELECT COUNT(*)
FROM hjts_djcf_items
WHERE date_exp > '2018-04-23'
AND cat_id = (36)
SELECT *
FROM hjts_djcf_categories
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(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,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=2
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 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=2
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=1
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'
