SELECT *
FROM qrt_session
WHERE session_id = 'e7d86599d662aaa745d0cdca5c2ba294'
DELETE
FROM qrt_session
WHERE ( TIME < '1550709548' )
SELECT *
FROM qrt_session
WHERE session_id = 'e7d86599d662aaa745d0cdca5c2ba294'
INSERT INTO `qrt_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'e7d86599d662aaa745d0cdca5c2ba294','1550710448','','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 = 236)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM qrt_jcomments_settings
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, 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, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM qrt_content AS a
LEFT JOIN qrt_categories AS cc
ON cc.id = a.catid
LEFT JOIN qrt_sections AS s
ON s.id = cc.SECTION
AND s.scope = "content"
LEFT JOIN qrt_users AS u
ON u.id = a.created_by
LEFT JOIN qrt_groups AS g
ON a.access = g.id
WHERE a.id = 198
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-21 00:54:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-21 00:54:08' ) ) OR ( a.state = -1 ) )
UPDATE qrt_content
SET hits = ( hits + 1 )
WHERE id='198'
SELECT t.id,t.name,t.hits
FROM qrt_tag_term AS t
LEFT JOIN qrt_tag_term_content AS c
ON c.tid=t.id
WHERE c.cid=198
ORDER BY t.weight DESC,t.name
SELECT created_by, sectionid, catid
FROM qrt_content
WHERE id='198'
SELECT id
FROM qrt_users
WHERE username = 'jose-yuste-frias'
LIMIT 0, 1
SELECT a.id AS id, a.title AS title, a.created AS created, a.introtext AS intro, a.catid AS catid, a.sectionid AS sectionid, a.ordering AS ordering, b.title AS SECTION, b.ordering AS sectionorder, c.title AS cat, c.ordering AS catorder, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
FROM qrt_content AS a
LEFT JOIN qrt_sections AS b
ON b.id = a.sectionid
LEFT JOIN qrt_categories AS c
ON c.id = a.catid
WHERE a.sectionid <> '11'
AND ( LOWER(a.created_by_alias) LIKE '%ga=%'
AND LOWER(a.created_by_alias) LIKE '%jose-yuste-frias%' )
AND ( a.state = 1 OR a.state = -1 )
ORDER BY a.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 = 236 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-21 00:54:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-21 00:54:08' )
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 = '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 *
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 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-21 00:54:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-21 00:54:08' )
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 = '146'
SELECT title
FROM qrt_content
WHERE id = 146
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 146
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 146
SELECT *
FROM qrt_content
WHERE id = '249'
SELECT title
FROM qrt_content
WHERE id = 249
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 249
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 249
SELECT *
FROM qrt_content
WHERE id = '247'
SELECT title
FROM qrt_content
WHERE id = 247
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 247
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 247
SELECT *
FROM qrt_content
WHERE id = '251'
SELECT title
FROM qrt_content
WHERE id = 251
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 251
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 251
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-21 00:54:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-21 00:54:08' )
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 = '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 = '189'
SELECT title
FROM qrt_content
WHERE id = 189
SELECT rating_sum
FROM qrt_content_rating
WHERE content_id = 189
SELECT rating_count
FROM qrt_content_rating
WHERE content_id = 189
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 = '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-21 00:54:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-21 00:54:08' )
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 *
FROM qrt_jcalpro2_config
SELECT unix_timestamp( '2019-02-21 00:54:13');
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
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-21 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-21 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-21 00:00:00'
AND e.start_date <= '2019-02-28 23:59:59') OR ( e.end_date > '2019-02-21 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 IN (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-21 00:54:13')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-21 00:54:13' )
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-21') - 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-21 00:54:13')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-21 00:54:13' )
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-21') - 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-21 00:54:13')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-21 00:54:13' )
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-21') - 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-21 00:54:13')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-21 00:54:13' )
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-21') - 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-21 00:54:13')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-21 00:54:13' )
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-21') - 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-21 00:54:13')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-21 00:54:13' )
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-21') - 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-21 00:54:13')
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-21 00:54:13' )
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-21') - 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