SELECT *
FROM qrt_session
WHERE session_id = 'bd0908b3c439133ca04a517721b88123'
DELETE
FROM qrt_session
WHERE ( TIME < '1550465519' )
SELECT *
FROM qrt_session
WHERE session_id = 'bd0908b3c439133ca04a517721b88123'
INSERT INTO `qrt_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'bd0908b3c439133ca04a517721b88123','1550466419','','0','1','0' )
SELECT *
FROM qrt_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM qrt_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
CREATE TABLE IF NOT EXISTS qrt_zoo_version (version VARCHAR(255) NOT NULL) ENGINE=MyISAM;
SELECT version
FROM qrt_zoo_version
SELECT m.*, c.`option` AS component
FROM qrt_menu AS m
LEFT JOIN qrt_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM qrt_rokcandy
WHERE published=1
SELECT template
FROM qrt_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 239)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM qrt_jcalpro2_config
SELECT unix_timestamp( '2019-02-18 05:06:59');
SELECT name
FROM qrt_jcalpro2_themes
WHERE published= '1'
SELECT lft, rgt
FROM qrt_core_acl_aro_groups
WHERE name = 'registered'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM qrt_core_acl_aro_groups AS g1
INNER JOIN qrt_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft > 4
AND g1.lft <11
GROUP BY g1.name
ORDER BY g1.lft
SELECT lft, rgt
FROM qrt_core_acl_aro_groups
WHERE name = 'public backend'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM qrt_core_acl_aro_groups AS g1
INNER JOIN qrt_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft > 13
AND g1.lft <20
GROUP BY g1.name
ORDER BY g1.lft
SELECT id, name
FROM qrt_core_acl_aro_groups;
SELECT lft, rgt
FROM qrt_core_acl_aro_groups
WHERE name = 'manager'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM qrt_core_acl_aro_groups AS g1
INNER JOIN qrt_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft > 14
AND g1.lft <19
GROUP BY g1.name
ORDER BY g1.lft
SELECT id, name
FROM qrt_core_acl_aro_groups;
SELECT lft, rgt
FROM qrt_core_acl_aro_groups
WHERE name = 'manager'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM qrt_core_acl_aro_groups AS g1
INNER JOIN qrt_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft > 14
AND g1.lft <19
GROUP BY g1.name
ORDER BY g1.lft
SELECT id, name
FROM qrt_core_acl_aro_groups;
SELECT lft, rgt
FROM qrt_core_acl_aro_groups
WHERE name = 'manager'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM qrt_core_acl_aro_groups AS g1
INNER JOIN qrt_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft > 14
AND g1.lft <19
GROUP BY g1.name
ORDER BY g1.lft
SELECT id, name
FROM qrt_core_acl_aro_groups;
SELECT
cat_id, level
FROM
qrt_jcalpro2_categories
SELECT lft, rgt
FROM qrt_core_acl_aro_groups
WHERE name = 'public frontend'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM qrt_core_acl_aro_groups AS g1
INNER JOIN qrt_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft > 3
AND g1.lft <12
GROUP BY g1.name
ORDER BY g1.lft
SELECT lft, rgt
FROM qrt_core_acl_aro_groups
WHERE name = 'public backend'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM qrt_core_acl_aro_groups AS g1
INNER JOIN qrt_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft > 13
AND g1.lft <20
GROUP BY g1.name
ORDER BY g1.lft
SELECT id, name
FROM qrt_core_acl_aro_groups;
SELECT
cal_id, level
FROM
qrt_jcalpro2_calendars
SELECT lft, rgt
FROM qrt_core_acl_aro_groups
WHERE name = 'public frontend'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM qrt_core_acl_aro_groups AS g1
INNER JOIN qrt_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft > 3
AND g1.lft <12
GROUP BY g1.name
ORDER BY g1.lft
SELECT lft, rgt
FROM qrt_core_acl_aro_groups
WHERE name = 'public backend'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM qrt_core_acl_aro_groups AS g1
INNER JOIN qrt_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft > 13
AND g1.lft <20
GROUP BY g1.name
ORDER BY g1.lft
SELECT id, name
FROM qrt_core_acl_aro_groups;
SELECT cat_id, cat_name, description
FROM qrt_jcalpro2_categories
WHERE published = 1
AND cat_id = '1'
SELECT *
FROM qrt_jcalpro2_calendars
WHERE (published = '1' OR cal_id = '')
ORDER BY cal_name
SELECT cat_id, cat_name, description
FROM qrt_jcalpro2_categories
WHERE published = 1
AND cat_id = '1'
SELECT *
FROM qrt_jcalpro2_events AS e
WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') >= 20190218 OR DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190218)
AND cat = '1'
AND approved = 1
AND published = 1
ORDER BY start_date ASC, title ASC
SELECT cat_id
FROM qrt_jcalpro2_categories
WHERE `published`='1'
SELECT cal_id
FROM qrt_jcalpro2_calendars
WHERE `published`='1'
SELECT e.*, c.cat_id, c.cat_name, c.color, c.description AS cat_desc
FROM qrt_jcalpro2_events AS e
LEFT JOIN qrt_jcalpro2_categories AS c
ON e.cat=c.cat_id
LEFT JOIN qrt_jcalpro2_calendars AS cal
ON e.cal_id=cal.cal_id
WHERE ( ( e.start_date <= '2019-02-18 00:00:00'
AND e.end_date >= '2038-01-17 00:00:00'
AND e.end_date != '2038-01-18 00:00:00'
AND e.end_date != '0000-00-00 00:00:01'
AND e.end_date != '9999-12-01 00:00:00') OR ((e.start_date >= '2019-02-18 00:00:00'
AND e.start_date < '2038-01-17 00:00:00')
AND (e.end_date = '2038-01-18 00:00:00' OR e.end_date = '0000-00-00 00:00:01' OR e.end_date = '9999-12-01 00:00:00')) OR ( e.start_date > '2019-02-18 00:00:00'
AND e.start_date <= '2038-01-17 00:00:00') OR ( e.end_date > '2019-02-18 00:00:00'
AND e.end_date <= '2038-01-17 00:00:00' ) )
AND c.published = '1'
AND e.published = '1'
AND cal.published='1'
AND approved = '1'
AND e.cat = '1'
AND e.cal_id IN (1)
AND (e.private IN ('0', '2') OR (e.owner_id = '0'
AND e.private = '1'))
ORDER BY start_date,title ASC
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM qrt_modules AS m
LEFT JOIN qrt_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 = 239 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT params
FROM qrt_components AS c
WHERE c.OPTION='com_widgetkit'
SELECT template
FROM qrt_templates_menu
WHERE client_id = 0
AND menuid = 0
SELECT DISTINCT a.*, a.images, cc.alias AS catalias, 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 qrt_content AS a
LEFT JOIN qrt_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN qrt_categories AS cc
ON cc.id = a.catid
INNER JOIN qrt_sections AS s
ON s.id = a.sectionid
LEFT JOIN qrt_content_rating AS r
ON r.content_id = a.id
WHERE ( a.state = 1
AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-18 05:07:00' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-18 05:07:00' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( ( a.catid IN ( 61 ) ) )
AND s.published = 1
AND cc.published = 1
ORDER BY RAND()
LIMIT 0, 4
SELECT *
FROM qrt_content
WHERE id = '151'
SELECT title
FROM qrt_content
WHERE id = 151
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 151
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 151
SELECT *
FROM qrt_content
WHERE id = '152'
SELECT title
FROM qrt_content
WHERE id = 152
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 152
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 152
SELECT *
FROM qrt_content
WHERE id = '153'
SELECT title
FROM qrt_content
WHERE id = 153
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 153
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 153
SELECT *
FROM qrt_content
WHERE id = '150'
SELECT title
FROM qrt_content
WHERE id = 150
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 150
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 150
SELECT DISTINCT a.*, a.images, cc.alias AS catalias, 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 qrt_content AS a
LEFT JOIN qrt_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN qrt_categories AS cc
ON cc.id = a.catid
INNER JOIN qrt_sections AS s
ON s.id = a.sectionid
LEFT JOIN qrt_content_rating AS r
ON r.content_id = a.id
WHERE ( a.state = 1
AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-18 05:07:00' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-18 05:07:00' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( ( a.catid IN ( 60 ) ) )
AND s.published = 1
AND cc.published = 1
ORDER BY RAND()
LIMIT 0, 4
SELECT *
FROM qrt_content
WHERE id = '137'
SELECT title
FROM qrt_content
WHERE id = 137
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 137
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 137
SELECT *
FROM qrt_content
WHERE id = '254'
SELECT title
FROM qrt_content
WHERE id = 254
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 254
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 254
SELECT *
FROM qrt_content
WHERE id = '257'
SELECT title
FROM qrt_content
WHERE id = 257
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 257
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 257
SELECT *
FROM qrt_content
WHERE id = '147'
SELECT title
FROM qrt_content
WHERE id = 147
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 147
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 147
SELECT DISTINCT a.*, a.images, cc.alias AS catalias, 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 qrt_content AS a
LEFT JOIN qrt_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN qrt_categories AS cc
ON cc.id = a.catid
INNER JOIN qrt_sections AS s
ON s.id = a.sectionid
LEFT JOIN qrt_content_rating AS r
ON r.content_id = a.id
WHERE ( a.state = 1
AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-18 05:07:00' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-18 05:07:00' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( ( a.catid IN ( 62 ) ) )
AND s.published = 1
AND cc.published = 1
ORDER BY RAND()
LIMIT 0, 4
SELECT *
FROM qrt_content
WHERE id = '190'
SELECT title
FROM qrt_content
WHERE id = 190
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 190
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 190
SELECT *
FROM qrt_content
WHERE id = '186'
SELECT title
FROM qrt_content
WHERE id = 186
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 186
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 186
SELECT *
FROM qrt_content
WHERE id = '188'
SELECT title
FROM qrt_content
WHERE id = 188
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 188
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 188
SELECT *
FROM qrt_content
WHERE id = '185'
SELECT title
FROM qrt_content
WHERE id = 185
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 185
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 185
SELECT name,hits
FROM qrt_tag_term
ORDER BY hits DESC
LIMIT 0, 28
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 qrt_content AS a
INNER JOIN qrt_categories AS cc
ON cc.id = a.catid
INNER JOIN qrt_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-18 05:07:00' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-18 05:07:00' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=51 OR cc.id=52 OR cc.id=53 OR cc.id=54 OR cc.id=55 OR cc.id=56)
AND (s.id=7)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 5
SELECT e.*, c.cat_id, c.cat_name, c.color, c.description AS cat_desc
FROM qrt_jcalpro2_events AS e
LEFT JOIN qrt_jcalpro2_categories AS c
ON e.cat=c.cat_id
LEFT JOIN qrt_jcalpro2_calendars AS cal
ON e.cal_id=cal.cal_id
WHERE ( ( e.start_date <= '2019-02-18 00:00:00'
AND e.end_date >= '2019-02-28 23:59:59'
AND e.end_date != '2038-01-18 00:00:00'
AND e.end_date != '0000-00-00 00:00:01'
AND e.end_date != '9999-12-01 00:00:00') OR ((e.start_date >= '2019-02-18 00:00:00'
AND e.start_date < '2019-02-28 23:59:59')
AND (e.end_date = '2038-01-18 00:00:00' OR e.end_date = '0000-00-00 00:00:01' OR e.end_date = '9999-12-01 00:00:00')) OR ( e.start_date > '2019-02-18 00:00:00'
AND e.start_date <= '2019-02-28 23:59:59') OR ( e.end_date > '2019-02-18 00:00:00'
AND e.end_date <= '2019-02-28 23:59:59' ) )
AND c.published = '1'
AND e.published = '1'
AND cal.published='1'
AND approved = '1'
AND e.cat = '1'
AND e.cal_id IN (1)
AND (e.private IN ('0', '2') OR (e.owner_id = '0'
AND e.private = '1'))
ORDER BY start_date,title ASC
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM qrt_content AS a
LEFT JOIN qrt_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN qrt_users AS u
ON u.id = a.created_by
INNER JOIN qrt_categories AS cc
ON cc.id = a.catid
INNER JOIN qrt_sections AS s
ON s.id = a.sectionid
WHERE ( a.state = 1
AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-18 05:07:04')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-18 05:07:04' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=54 )
AND ( a.sectionid=7 )
AND ((TO_DAYS('2019-02-18') - TO_DAYS(a.created)) <= '1200000')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,10
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM qrt_content AS a
LEFT JOIN qrt_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN qrt_users AS u
ON u.id = a.created_by
INNER JOIN qrt_categories AS cc
ON cc.id = a.catid
INNER JOIN qrt_sections AS s
ON s.id = a.sectionid
WHERE ( a.state = 1
AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-18 05:07:04')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-18 05:07:04' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=58 )
AND ( a.sectionid=7 )
AND ((TO_DAYS('2019-02-18') - TO_DAYS(a.created)) <= '1200000')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,10
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM qrt_content AS a
LEFT JOIN qrt_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN qrt_users AS u
ON u.id = a.created_by
INNER JOIN qrt_categories AS cc
ON cc.id = a.catid
INNER JOIN qrt_sections AS s
ON s.id = a.sectionid
WHERE ( a.state = 1
AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-18 05:07:04')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-18 05:07:04' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=52 )
AND ( a.sectionid=7 )
AND ((TO_DAYS('2019-02-18') - TO_DAYS(a.created)) <= '1200000')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,10
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM qrt_content AS a
LEFT JOIN qrt_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN qrt_users AS u
ON u.id = a.created_by
INNER JOIN qrt_categories AS cc
ON cc.id = a.catid
INNER JOIN qrt_sections AS s
ON s.id = a.sectionid
WHERE ( a.state = 1
AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-18 05:07:04')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-18 05:07:04' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=54 )
AND ( a.sectionid=7 )
AND ((TO_DAYS('2019-02-18') - TO_DAYS(a.created)) <= '1200000')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,10
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM qrt_content AS a
LEFT JOIN qrt_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN qrt_users AS u
ON u.id = a.created_by
INNER JOIN qrt_categories AS cc
ON cc.id = a.catid
INNER JOIN qrt_sections AS s
ON s.id = a.sectionid
WHERE ( a.state = 1
AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-18 05:07:04')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-18 05:07:04' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=55 )
AND ( a.sectionid=7 )
AND ((TO_DAYS('2019-02-18') - TO_DAYS(a.created)) <= '1200000')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,10
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM qrt_content AS a
LEFT JOIN qrt_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN qrt_users AS u
ON u.id = a.created_by
INNER JOIN qrt_categories AS cc
ON cc.id = a.catid
INNER JOIN qrt_sections AS s
ON s.id = a.sectionid
WHERE ( a.state = 1
AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-18 05:07:04')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-18 05:07:04' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=56 )
AND ( a.sectionid=7 )
AND ((TO_DAYS('2019-02-18') - TO_DAYS(a.created)) <= '1200000')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,10
SELECT a.*, u.name, u.username, cc.image AS image, 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,'link' AS link
FROM qrt_content AS a
LEFT JOIN qrt_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN qrt_users AS u
ON u.id = a.created_by
INNER JOIN qrt_categories AS cc
ON cc.id = a.catid
INNER JOIN qrt_sections AS s
ON s.id = a.sectionid
WHERE ( a.state = 1
AND a.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-18 05:07:04')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-18 05:07:04' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND ( a.catid=57 )
AND ( a.sectionid=7 )
AND ((TO_DAYS('2019-02-18') - TO_DAYS(a.created)) <= '1200000')
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0,10
SELECT a.id, a.alias AS username, a.title AS fullname, a.catid, a.sectionid, a.introtext AS intro, u.email AS email, u.id AS user_id, 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 qrt_content AS a
LEFT JOIN qrt_categories AS cc
ON cc.id = a.catid
LEFT JOIN qrt_users AS u
ON u.username = a.alias
WHERE a.sectionid = 11
AND a.state = 1