The Socceroos need to defeat world number four Chile by two clear goals to continue their Confederations Cup in the semi-finals after labouring to a 1-1 draw with Cameroon.
Saudi Arabia's king has appointed his son Mohammed bin Salman as crown prince - replacing his nephew, Mohammed bin Nayef, as first in line to the throne.
Australia is bringing in its first national gun amnesty since 1996 because of the growing terrorism threat and an influx of illegal arms in the country.
Diplomatic officials have brushed off footage leaked to the media showing Australia's prime minister making fun of US President Donald Trump.
Schapelle Corby's sister Mercedes says rumours the convicted drug smuggler is heading to the UK to appear on TV's Celebrity Big Brother is 'a load of crap'.
Nicole Kidman feared she would 'let down' real-life adoptive mother Sue Brierley, who she played in 'Lion'.
President Rodrigo Duterte said on Sunday he did not seek support from Washington to end the siege of a southern Philippines town by Islamist militants, a day after the United States said it was providing assistance at the request of the government.
Qatar is ready to listen to the concerns of Gulf Arab states that have cut diplomatic and economic ties, Kuwait said on Sunday as it tried to mediate a solution to the worst regional crisis in years.
The Socceroos need to defeat world number four Chile by two clear goals to continue their...
President Rodrigo Duterte said on Sunday he did not seek support from Washington to end the siege of a...
Saudi Arabia's king has appointed his son Mohammed bin Salman as crown prince - replacing his...
Australia is bringing in its first national gun amnesty since 1996 because of the growing...
A Paul Cezanne painting of a southern French town sells for $29.8 million at a London auction, as...
Clean, cheap nuclear energy is often touted as a means to battle climate change. But how close...
Temperature data for 2016 shows it is likely to have edged ahead of 2015 as the world's...
They may have the power to alter your thoughts, your behaviour, how well you feel or influence...
session.client.browser ⇒ CCBot/2.0 (http://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
link ⇒ https://theworldobserver.com.au/sport-news/10632-confederations-cup-australia-held-1-1-by-cameroon-needs-miracle-chile-win-to-progress.html
link ⇒ https://theworldobserver.com.au/middle-east-news-2/10631-saudi-king-s-son-mohammed-bin-salman-is-new-crown-prince.html
link ⇒ https://theworldobserver.com.au/australia-blogs/10628-australia-announces-national-gun-amnesty.html
link ⇒ https://theworldobserver.com.au/breaking-news-world/10627-us-embassy-brushes-off-australian-pm-s-trump-joke.html
link ⇒ https://theworldobserver.com.au/in-focus/10626-corby-s-sister-denies-big-brother-plans.html
link ⇒ https://theworldobserver.com.au/celebrity-sightings/10624-kidman-wanted-to-honour-sue-brierley-s-life.html
link ⇒ https://theworldobserver.com.au/world-news-2/asia-news/10623-philippines-duterte-says-didn-t-seek-u-s-support-in-city-siege.html
link ⇒ https://theworldobserver.com.au/middle-east-news-2/10622-qatar-willing-to-listen-to-gulf-concerns-kuwait-says.html
Application 0.000 seconds (+0.000); 1.02 MB (+1.016) - afterLoadApplication 0.040 seconds (+0.040); 4.27 MB (+3.253) - afterInitialiseApplication 0.060 seconds (+0.021); 5.88 MB (+1.607) - afterRouteApplication 0.388 seconds (+0.328); 9.67 MB (+3.797) - afterDispatchApplication 0.399 seconds (+0.011); 10.08 MB (+0.405) - beforeRenderModule mod_custom (banner under-menu)Application 0.401 seconds (+0.002); 10.10 MB (+0.024) - afterRenderModule mod_custom (banner under-menu)Application 0.401 seconds (+0.000); 10.12 MB (+0.021) - beforeRenderModule mod_featcats (Sport)Application 0.425 seconds (+0.024); 10.44 MB (+0.322) - afterRenderModule mod_featcats (Sport)Application 0.426 seconds (+0.000); 10.36 MB (-0.089) - beforeRenderModule mod_featcats (World)Application 0.482 seconds (+0.056); 10.55 MB (+0.192) - afterRenderModule mod_featcats (World)Application 0.482 seconds (+0.000); 10.45 MB (-0.094) - beforeRenderModule mod_featcats (Middle East)Application 0.508 seconds (+0.026); 10.56 MB (+0.107) - afterRenderModule mod_featcats (Middle East)Application 0.508 seconds (+0.000); 10.47 MB (-0.090) - beforeRenderModule mod_featcats (Australia)Application 0.532 seconds (+0.023); 10.58 MB (+0.107) - afterRenderModule mod_featcats (Australia)Application 0.532 seconds (+0.000); 10.49 MB (-0.088) - beforeRenderModule mod_featcats (Entertainment & Art)Application 0.539 seconds (+0.007); 10.61 MB (+0.123) - afterRenderModule mod_featcats (Entertainment & Art)Application 0.539 seconds (+0.000); 10.51 MB (-0.097) - beforeRenderModule mod_featcats (Technology)Application 0.546 seconds (+0.007); 10.66 MB (+0.148) - afterRenderModule mod_featcats (Technology)Application 0.547 seconds (+0.000); 10.55 MB (-0.115) - beforeRenderModule mod_featcats (Environment)Application 0.553 seconds (+0.007); 10.67 MB (+0.127) - afterRenderModule mod_featcats (Environment)Application 0.554 seconds (+0.000); 10.57 MB (-0.101) - beforeRenderModule mod_featcats (Health)Application 0.560 seconds (+0.007); 10.71 MB (+0.133) - afterRenderModule mod_featcats (Health)Application 0.565 seconds (+0.005); 10.74 MB (+0.032) - beforeRenderModule mod_custom (logo)Application 0.565 seconds (+0.001); 10.74 MB (+0.004) - afterRenderModule mod_custom (logo)Application 0.566 seconds (+0.001); 10.75 MB (+0.004) - beforeRenderModule mod_tcvn_banner_slider (Header-Beside-Logo-banners)Application 0.572 seconds (+0.006); 10.91 MB (+0.166) - afterRenderModule mod_tcvn_banner_slider (Header-Beside-Logo-banners)Application 0.573 seconds (+0.001); 10.89 MB (-0.018) - beforeRenderModule mod_menu (Top Menu)Application 0.582 seconds (+0.009); 11.02 MB (+0.129) - afterRenderModule mod_menu (Top Menu)Application 0.590 seconds (+0.008); 11.34 MB (+0.314) - beforeRenderModule mod_search (Search)Application 0.592 seconds (+0.002); 11.36 MB (+0.023) - afterRenderModule mod_search (Search)Application 0.594 seconds (+0.002); 11.36 MB (-0.002) - beforeRenderModule mod_menu (Main Menu)Application 0.604 seconds (+0.010); 11.45 MB (+0.088) - afterRenderModule mod_menu (Main Menu)Application 0.604 seconds (+0.000); 11.46 MB (+0.012) - beforeRenderModule mod_featcats (Sharp Corner)Application 0.621 seconds (+0.016); 11.61 MB (+0.155) - afterRenderModule mod_featcats (Sharp Corner)Application 0.621 seconds (+0.000); 11.49 MB (-0.121) - beforeRenderModule mod_featcats (Local Community News)Application 0.638 seconds (+0.017); 11.65 MB (+0.153) - afterRenderModule mod_featcats (Local Community News)Application 0.638 seconds (+0.000); 11.53 MB (-0.120) - beforeRenderModule mod_featcats ( Youth Issues )Application 0.647 seconds (+0.009); 11.68 MB (+0.154) - afterRenderModule mod_featcats ( Youth Issues )Application 0.648 seconds (+0.000); 11.55 MB (-0.129) - beforeRenderModule mod_featcats (Climate Change)Application 0.658 seconds (+0.010); 11.71 MB (+0.156) - afterRenderModule mod_featcats (Climate Change)Application 0.658 seconds (+0.000); 11.58 MB (-0.130) - beforeRenderModule mod_featcats (Crime News )Application 0.681 seconds (+0.023); 11.72 MB (+0.141) - afterRenderModule mod_featcats (Crime News )Application 0.681 seconds (+0.000); 11.58 MB (-0.135) - beforeRenderModule mod_asfaleiafacebooklikebox (Like us on Facebook !)Application 0.681 seconds (+0.000); 11.59 MB (+0.007) - afterRenderModule mod_asfaleiafacebooklikebox (Like us on Facebook !)Application 0.689 seconds (+0.007); 11.62 MB (+0.027) - beforeRenderModule mod_custom (Languages)Application 0.690 seconds (+0.001); 11.62 MB (+0.006) - afterRenderModule mod_custom (Languages)Application 0.690 seconds (+0.000); 11.62 MB (-0.002) - beforeRenderModule mod_custom (new-banner-right)Application 0.690 seconds (+0.001); 11.63 MB (+0.004) - afterRenderModule mod_custom (new-banner-right)Application 0.691 seconds (+0.000); 11.65 MB (+0.020) - beforeRenderModule mod_featcats ( Odd News )Application 0.713 seconds (+0.022); 11.79 MB (+0.141) - afterRenderModule mod_featcats ( Odd News )Application 0.713 seconds (+0.000); 11.67 MB (-0.115) - beforeRenderModule mod_featcats ( Around the World )Application 0.731 seconds (+0.017); 11.81 MB (+0.139) - afterRenderModule mod_featcats ( Around the World )Application 0.731 seconds (+0.001); 11.70 MB (-0.113) - beforeRenderModule mod_featcats ( Behind the Scene )Application 0.763 seconds (+0.032); 11.82 MB (+0.122) - afterRenderModule mod_featcats ( Behind the Scene )Application 0.764 seconds (+0.000); 11.71 MB (-0.115) - beforeRenderModule mod_articles_latest (Popular stories)Application 0.796 seconds (+0.033); 11.88 MB (+0.176) - afterRenderModule mod_articles_latest (Popular stories)Application 0.797 seconds (+0.001); 11.76 MB (-0.117) - beforeRenderModule mod_featcats ( Celebrity Sightings )Application 0.821 seconds (+0.024); 11.90 MB (+0.137) - afterRenderModule mod_featcats ( Celebrity Sightings )Application 0.822 seconds (+0.000); 11.76 MB (-0.136) - beforeRenderModule mod_custom (NewsPaper Download)Application 0.822 seconds (+0.001); 11.77 MB (+0.004) - afterRenderModule mod_custom (NewsPaper Download)Application 0.823 seconds (+0.000); 11.77 MB (-0.002) - beforeRenderModule mod_custom (Magazine Download)Application 0.823 seconds (+0.001); 11.77 MB (+0.004) - afterRenderModule mod_custom (Magazine Download)Application 0.823 seconds (+0.000); 11.79 MB (+0.019) - beforeRenderModule mod_featcats ( In Focus )Application 0.844 seconds (+0.021); 11.92 MB (+0.133) - afterRenderModule mod_featcats ( In Focus )Application 0.845 seconds (+0.000); 11.79 MB (-0.133) - beforeRenderModule mod_tcvn_banner_slider (Right-Side-banners)Application 0.848 seconds (+0.003); 11.80 MB (+0.012) - afterRenderModule mod_tcvn_banner_slider (Right-Side-banners)Application 0.878 seconds (+0.030); 11.83 MB (+0.026) - beforeRenderModule mod_blank250 (Blank Module)Application 0.881 seconds (+0.003); 11.87 MB (+0.043) - afterRenderModule mod_blank250 (Blank Module)Application 0.904 seconds (+0.023); 11.86 MB (-0.016) - afterRender11.94 MB (12,520,624 Bytes)SELECT `data`
FROM `sezpj_session`
WHERE `session_id` = '532a47d639178ee86107dffa9f591e4f'SELECT `session_id`
FROM `sezpj_session`
WHERE `session_id` = '532a47d639178ee86107dffa9f591e4f'
LIMIT 0, 1INSERT INTO `sezpj_session`
(`session_id`, `client_id`, `time`)
VALUES
('532a47d639178ee86107dffa9f591e4f', 0, '1498356118')SELECT extension_id AS id, element AS "option", params, enabled
FROM sezpj_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT b.id
FROM sezpj_usergroups AS a
LEFT JOIN sezpj_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT id, rules
FROM `sezpj_viewlevels`SELECT folder AS type, element AS name, params
FROM sezpj_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM sezpj_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT extension_id AS id, element AS "option", params, enabled
FROM sezpj_extensions
WHERE `type` = 'component'
AND `element` = 'com_widgetkit'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM sezpj_menu AS m
LEFT JOIN sezpj_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftSELECT id, home, template, s.params
FROM sezpj_template_styles as s
LEFT JOIN sezpj_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1SELECT extension_id AS id, element AS "option", params, enabled
FROM sezpj_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT *
FROM sezpj_languages
WHERE published=1
ORDER BY ordering ASCSELECT a.rules
FROM sezpj_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSELECT b.rules
FROM sezpj_assets AS a
LEFT JOIN sezpj_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
WHERE
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 0, 10SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
WHERE
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created DESCSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=150
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=139
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=95
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=100
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=112
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=102
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=159
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=160
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT params
FROM sezpj_extensions AS e
WHERE e.element='com_widgetkit'SELECT extension_id AS id, element AS "option", params, enabled
FROM sezpj_extensions
WHERE `type` = 'component'
AND `element` = 'com_media'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sezpj_modules AS m
LEFT JOIN sezpj_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sezpj_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2017-06-25 02:01:58')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-06-25 02:01:58')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 435 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 150
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 3SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN `sezpj_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=154
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (154,155,156,159,160)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 3SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 139
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 3SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 95
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 3SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=108
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 108
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 3SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=123
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 123
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 3SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=119
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 119
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 3SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=120
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 120
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 3SELECT *
FROM sezpj_banners
WHERE '2017-06-25 02:01:58' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM sezpj_banners as a
LEFT JOIN sezpj_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (101)
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM sezpj_banners as a
LEFT JOIN sezpj_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (101)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 10UPDATE sezpj_banners
SET impmade = (impmade + 1)
WHERE id = 17UPDATE sezpj_banners
SET impmade = (impmade + 1)
WHERE id = 25UPDATE sezpj_banners
SET impmade = (impmade + 1)
WHERE id = 24UPDATE sezpj_banners
SET impmade = (impmade + 1)
WHERE id = 27SELECT extension_id AS id, element AS "option", params, enabled
FROM sezpj_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=148
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 148
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 4SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=135
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 135
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 4SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=158
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 158
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 4SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=104
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 104
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 4SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=106
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 106
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 4SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=142
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 142
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 4SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=94
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 94
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 4SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=97
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 97
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 3SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (145)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 5SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=145
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 102
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 4SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sezpj_content AS a
LEFT JOIN sezpj_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sezpj_categories AS c
ON c.id = a.catid
LEFT JOIN sezpj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sezpj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sezpj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sezpj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 112
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-25 02:01:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-25 02:01:58')
ORDER BY a.created DESC
LIMIT 0, 4SELECT *
FROM sezpj_banners
WHERE '2017-06-25 02:01:58' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM sezpj_banners as a
LEFT JOIN sezpj_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (166)
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM sezpj_banners as a
LEFT JOIN sezpj_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (166)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 10UPDATE sezpj_banners
SET impmade = (impmade + 1)
WHERE id = 18UPDATE sezpj_banners
SET impmade = (impmade + 1)
WHERE id = 26UPDATE sezpj_banners
SET impmade = (impmade + 1)
WHERE id = 28UPDATE `sezpj_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1498356118;s:18:\"session.timer.last\";i:1498356118;s:17:\"session.timer.now\";i:1498356118;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:8:{s:40:\"6a0d013eeac913f9c7036dfd84c4bc8e8217b169\";O:8:\"stdClass\":2:{s:4:\"link\";s:139:\"https://theworldobserver.com.au/sport-news/10632-confederations-cup-australia-held-1-1-by-cameroon-needs-miracle-chile-win-to-progress.html\";s:6:\"expiry\";i:1498356118;}s:40:\"a0d5890e55f433cf36cf841039d312ac360a8376\";O:8:\"stdClass\":2:{s:4:\"link\";s:118:\"https://theworldobserver.com.au/middle-east-news-2/10631-saudi-king-s-son-mohammed-bin-salman-is-new-crown-prince.html\";s:6:\"expiry\";i:1498356118;}s:40:\"9cfd602629eb7a073931d0a473ce9799f445cf11\";O:8:\"stdClass\":2:{s:4:\"link\";s:99:\"https://theworldobserver.com.au/australia-blogs/10628-australia-announces-national-gun-amnesty.html\";s:6:\"expiry\";i:1498356118;}s:40:\"678e7edfc625426fe233f8fffd3f7a3aca14af12\";O:8:\"stdClass\":2:{s:4:\"link\";s:112:\"https://theworldobserver.com.au/breaking-news-world/10627-us-embassy-brushes-off-australian-pm-s-trump-joke.html\";s:6:\"expiry\";i:1498356118;}s:40:\"6785974dff8f11ac969da56d5283edee65348861\";O:8:\"stdClass\":2:{s:4:\"link\";s:91:\"https://theworldobserver.com.au/in-focus/10626-corby-s-sister-denies-big-brother-plans.html\";s:6:\"expiry\";i:1498356118;}s:40:\"564e3c54285c07a130ac007d4ba924c5a67dec7e\";O:8:\"stdClass\":2:{s:4:\"link\";s:106:\"https://theworldobserver.com.au/celebrity-sightings/10624-kidman-wanted-to-honour-sue-brierley-s-life.html\";s:6:\"expiry\";i:1498356118;}s:40:\"f79276bcc942e0c12a580d832882b4d46486e855\";O:8:\"stdClass\":2:{s:4:\"link\";s:128:\"https://theworldobserver.com.au/world-news-2/asia-news/10623-philippines-duterte-says-didn-t-seek-u-s-support-in-city-siege.html\";s:6:\"expiry\";i:1498356118;}s:40:\"41ec651f7b01bdf10dbf5486dfc682819fd69293\";O:8:\"stdClass\":2:{s:4:\"link\";s:114:\"https://theworldobserver.com.au/middle-east-news-2/10622-qatar-willing-to-listen-to-gulf-concerns-kuwait-says.html\";s:6:\"expiry\";i:1498356118;}}}'
, `time` = '1498356119'
WHERE `session_id` = '532a47d639178ee86107dffa9f591e4f'21 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt18 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,a.id, a.title, a.alias, a.introtext, a.fulltext, a.images, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact6 × SELECT extension_id AS id, element AS "option", params, enabled
FROM sezpj_extensions4 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM sezpj_banners as a
LEFT JOIN sezpj_banner_clients AS cl
ON cl.id = a.cid3 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM sezpj_contact_details AS contact2 × SELECT *
FROM sezpj_banners1 × SELECT params
FROM sezpj_extensions AS e1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM sezpj_categories as c
LEFT JOIN sezpj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sezpj_categories AS cat JOIN sezpj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT b.rules
FROM sezpj_assets AS a
LEFT JOIN sezpj_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sezpj_modules AS m
LEFT JOIN sezpj_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sezpj_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT a.rules
FROM sezpj_assets AS a1 × SELECT id, rules
FROM `sezpj_viewlevels1 × SELECT b.id
FROM sezpj_usergroups AS a
LEFT JOIN sezpj_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `session_id`
FROM `sezpj_session`1 × SELECT folder AS type, element AS name, params
FROM sezpj_extensions1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM sezpj_menu AS m
LEFT JOIN sezpj_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM sezpj_languages1 × SELECT id, home, template, s.params
FROM sezpj_template_styles as s
LEFT JOIN sezpj_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `data`
FROM `sezpj_session`7 × UPDATE sezpj_banners
SET impmade = (impmade + 1)1 × UPDATE `sezpj_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1498356118;s:18:\"session.timer.last\";i:1498356118;s:17:\"session.timer.now\";i:1498356118;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:8:{s:40:\"6a0d013eeac913f9c7036dfd84c4bc8e8217b169\";O:8:\"stdClass\":2:{s:4:\"link\";s:139:\"https://theworldobserver.com.au/sport-news/10632-confederations-cup-australia-held-1-1-by-cameroon-needs-miracle-chile-win-to-progress.html\";s:6:\"expiry\";i:1498356118;}s:40:\"a0d5890e55f433cf36cf841039d312ac360a8376\";O:8:\"stdClass\":2:{s:4:\"link\";s:118:\"https://theworldobserver.com.au/middle-east-news-2/10631-saudi-king-s-son-mohammed-bin-salman-is-new-crown-prince.html\";s:6:\"expiry\";i:1498356118;}s:40:\"9cfd602629eb7a073931d0a473ce9799f445cf11\";O:8:\"stdClass\":2:{s:4:\"link\";s:99:\"https://theworldobserver.com.au/australia-blogs/10628-australia-announces-national-gun-amnesty.html\";s:6:\"expiry\";i:1498356118;}s:40:\"678e7edfc625426fe233f8fffd3f7a3aca14af12\";O:8:\"stdClass\":2:{s:4:\"link\";s:112:\"https://theworldobserver.com.au/breaking-news-world/10627-us-embassy-brushes-off-australian-pm-s-trump-joke.html\";s:6:\"expiry\";i:1498356118;}s:40:\"6785974dff8f11ac969da56d5283edee65348861\";O:8:\"stdClass\":2:{s:4:\"link\";s:91:\"https://theworldobserver.com.au/in-focus/10626-corby-s-sister-denies-big-brother-plans.html\";s:6:\"expiry\";i:1498356118;}s:40:\"564e3c54285c07a130ac007d4ba924c5a67dec7e\";O:8:\"stdClass\":2:{s:4:\"link\";s:106:\"https://theworldobserver.com.au/celebrity-sightings/10624-kidman-wanted-to-honour-sue-brierley-s-life.html\";s:6:\"expiry\";i:1498356118;}s:40:\"f79276bcc942e0c12a580d832882b4d46486e855\";O:8:\"stdClass\":2:{s:4:\"link\";s:128:\"https://theworldobserver.com.au/world-news-2/asia-news/10623-philippines-duterte-says-didn-t-seek-u-s-support-in-city-siege.html\";s:6:\"expiry\";i:1498356118;}s:40:\"41ec651f7b01bdf10dbf5486dfc682819fd69293\";O:8:\"stdClass\":2:{s:4:\"link\";s:114:\"https://theworldobserver.com.au/middle-east-news-2/10622-qatar-willing-to-listen-to-gulf-concerns-kuwait-says.html\";s:6:\"expiry\";i:1498356118;}}}' , `time` = '1498356119'1 × INSERT INTO `sezpj_session` (`session_id`, `client_id`, `time`)
VALUES ('532a47d639178ee86107dffa9f591e4f', 0, '1498356118'