DELETE
FROM jos_session
WHERE ( time < '1579561274' )
SELECT *
FROM jos_session
WHERE session_id = '9rdqck011ldjb1r8bcllk3u9o2'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '9rdqck011ldjb1r8bcllk3u9o2','1579621274','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT count(*)
FROM jos_menu_types
WHERE `menutype`='magazine'
SELECT `id`,`title`,`published`
FROM jos_sections
WHERE `published`<>-2
SELECT name,id,published,parent,link,home
FROM `jos_menu`
WHERE `menutype`='magazine'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='17'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='18'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='19'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='20'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='21'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='22'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='15'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='16'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='30'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='24'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='25'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='26'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='27'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='28'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='29'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='32'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='35'
AND `published`<>-2
SELECT id,title,section
FROM `jos_categories`
WHERE `section`='34'
AND `published`<>-2
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 641)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
ORDER BY f.ordering
LIMIT 21, 7
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
ORDER BY f.ordering
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 641 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 641
LIMIT 1
SELECT count(*)
FROM jos_menu AS m
WHERE menutype='magazine'
AND published='1'
AND access <= '0'
AND parent=0
AND ordering < 4
SELECT params
FROM jos_modules
WHERE `module`='mod_janews2'
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 3
AND catid = 230
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 13
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 3
AND catid = 230
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 13
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 3
AND catid = 230
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 13
SELECT a.*,u.name AS authorname,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM (
SELECT created_by, MAX(created) AS maxcreated
FROM jos_content AS x
INNER JOIN jos_categories AS cc
ON cc.id = x.catid
INNER JOIN jos_sections AS s
ON s.id = x.sectionid
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = x.id
WHERE x.state = 1
AND (x.created_by=69 OR x.created_by=71 OR x.created_by=148 OR x.created_by=257)
AND s.id > 0
AND s.published = 1
AND cc.published = 1
AND (x.publish_up = '0000-00-00 00:00:00' OR x.publish_up <= '2020-01-21 15:41:14')
AND (x.publish_down = '0000-00-00 00:00:00' OR x.publish_down >= '2020-01-21 15:41:14')
AND (cc.id=143 OR cc.id=144 OR cc.id=145 OR cc.id=146 OR cc.id=147)
AND (s.id=15)
AND x.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND f.content_id IS NULL
GROUP BY created_by) AS b
INNER JOIN jos_content AS a
ON a.created_by = b.created_by
AND a.created = b.maxcreated
LEFT JOIN jos_users AS u
ON u.id = a.created_by
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
SHOW TABLES LIKE 'jos_fb_%'
SELECT *
FROM jos_fb_config
SELECT *
FROM jos_fb_config
SELECT *
FROM jos_fb_users
WHERE userid = '0'
SELECT *
FROM jos_fb_config
SELECT id
FROM jos_menu
WHERE link='index.php?option=com_kunena'
AND published='1'
SELECT id
FROM jos_menu
WHERE link LIKE 'index.php?option=com_community%'
AND published='1'
ORDER BY id ASC
LIMIT 1
SELECT *
FROM jos_community_config
WHERE name = 'config'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos_community_users AS a
LEFT JOIN jos_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos_session s
ON s.`userid`=a.`userid`
AND s.client_id !='1'
WHERE a.`userid`='0'
SELECT template
FROM jos_templates_menu
WHERE client_id='0'
SELECT l.id, l.time, l.thread, n.hits, count(m.id) AS `count`, l.subject, l.userid, l.name, l.catid, l.catname, l.unread, t.message
FROM
(SELECT m.time, m.thread, m.id, m.catid, m.userid, m.name, m.subject, c.name AS catname , 0 AS unread
FROM jos_fb_messages AS m
JOIN jos_fb_categories AS c
ON m.catid = c.id
WHERE c.published = 1
AND m.hold = 0
AND m.moved = 0
AND c.pub_access IN (0,1,-1,18)
ORDER BY m.id DESC
LIMIT 10) AS l
JOIN jos_fb_messages AS m
ON l.thread = m.thread
JOIN jos_fb_messages AS n
ON l.thread = n.id
JOIN jos_fb_messages_text AS t
ON l.id = t.mesid
WHERE l.time >= m.time
AND m.hold = 0
AND m.moved = 0
GROUP BY l.id
ORDER BY l.id DESC
SELECT id
FROM jos_menu
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`=1
SELECT id
FROM jos_menu
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`=1
SELECT `varname`, `value`, `default`
FROM jos_mt_config
SELECT l.*, cl.cat_id AS cat_id, c.cat_name AS category
FROM (jos_mt_links AS l, jos_mt_cats AS c, jos_mt_cl AS cl)
WHERE l.link_id = cl.link_id
AND c.cat_id = cl.cat_id
AND cl.main = 1
AND link_published='1' && link_approved='1'
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2020-01-21 15:41:14' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2020-01-21 15:41:14' )
AND l.link_votes >= 1
ORDER BY link_rating DESC, link_votes DESC
LIMIT 10
SELECT id, title, `description`, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS slug
FROM jos_sections s
WHERE published = 1
AND `id` IN (16,17,18,19,20,29)
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=16
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=99
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=100
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=101
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=17
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=102
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=103
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=104
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=18
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=105
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=106
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=107
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=19
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=108
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=109
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=110
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=20
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=157
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=158
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=148
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=29
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=140
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=139
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=141
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT id, title, `description`, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS slug
FROM jos_sections s
WHERE published = 1
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=17
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=102
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=103
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:14' )
AND cc.id=104
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=18
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=105
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=106
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=107
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=19
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=108
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=109
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=110
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=20
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=157
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=158
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=148
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=21
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=115
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=119
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=120
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=15
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=144
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=146
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=147
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=16
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=99
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=100
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=101
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=26
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=130
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=177
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=178
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=29
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=140
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=139
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=141
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=35
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=196
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=197
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=198
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END AS `slug`
FROM `jos_categories` s
WHERE published = 1
AND section=34
LIMIT 0, 3
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=194
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=193
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT a.*,u.name AS creater,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON a.created_by = u.id
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-21 15:41:15' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-21 15:41:15' )
AND cc.id=195
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 4
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
WHERE id = 219
ORDER BY position, ordering
SELECT
`userid`
FROM
`jos_community_users` AS a
INNER JOIN
`jos_users` AS b
ON a.userid=b.id
WHERE
`thumb` != 'components/com_community/assets/default_thumb.jpg'
ORDER
BY `points` DESC
LIMIT
10
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos_community_users AS a
LEFT JOIN jos_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos_session s
ON s.`userid`=a.`userid`
AND s.client_id !='1'
WHERE a.`userid`='143'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos_community_users AS a
LEFT JOIN jos_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos_session s
ON s.`userid`=a.`userid`
AND s.client_id !='1'
WHERE a.`userid`='148'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos_community_users AS a
LEFT JOIN jos_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos_session s
ON s.`userid`=a.`userid`
AND s.client_id !='1'
WHERE a.`userid`='167'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos_community_users AS a
LEFT JOIN jos_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos_session s
ON s.`userid`=a.`userid`
AND s.client_id !='1'
WHERE a.`userid`='112'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos_community_users AS a
LEFT JOIN jos_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos_session s
ON s.`userid`=a.`userid`
AND s.client_id !='1'
WHERE a.`userid`='169'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos_community_users AS a
LEFT JOIN jos_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos_session s
ON s.`userid`=a.`userid`
AND s.client_id !='1'
WHERE a.`userid`='69'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos_community_users AS a
LEFT JOIN jos_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos_session s
ON s.`userid`=a.`userid`
AND s.client_id !='1'
WHERE a.`userid`='180'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos_community_users AS a
LEFT JOIN jos_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos_session s
ON s.`userid`=a.`userid`
AND s.client_id !='1'
WHERE a.`userid`='223'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos_community_users AS a
LEFT JOIN jos_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos_session s
ON s.`userid`=a.`userid`
AND s.client_id !='1'
WHERE a.`userid`='94'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos_community_users AS a
LEFT JOIN jos_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos_session s
ON s.`userid`=a.`userid`
AND s.client_id !='1'
WHERE a.`userid`='187'
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
WHERE id = 217
ORDER BY position, ordering
SELECT a.*, TO_DAYS('2020-01-21 09:41:15') - TO_DAYS( DATE_ADD(a.`created`, INTERVAL -6 HOUR ) ) AS 'daydiff'
FROM jos_community_activities AS a
WHERE `archived`=0
AND (a.`access` <= 10)
ORDER BY a.`created` DESC
LIMIT 40
SELECT name
FROM jos_plugins
WHERE `element`='profile'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos_community_users AS a
LEFT JOIN jos_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos_session s
ON s.`userid`=a.`userid`
AND s.client_id !='1'
WHERE a.`userid`='310'
SELECT name
FROM jos_plugins
WHERE `element`='videos'
SELECT *
FROM jos_community_videos
WHERE id = '737'
SELECT id
FROM jos_menu
WHERE `link` LIKE '%option=com_community&view=videos%'
AND `published`=1
SELECT name
FROM jos_plugins
WHERE `element`='videos'
SELECT *
FROM jos_community_videos
WHERE id = '736'
SELECT name
FROM jos_plugins
WHERE `element`='videos'
SELECT *
FROM jos_community_videos
WHERE id = '735'
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
WHERE id = 218
ORDER BY position, ordering
SELECT *
FROM jos_community_wall AS a
INNER JOIN jos_community_videos AS b
ON a.contentid=b.id
WHERE a.type ='videos'
ORDER BY a.date DESC
LIMIT 5
SELECT DISTINCT
c.id AS ID,
c.section AS SID,
c.title AS name
FROM
jos_categories AS c
LEFT JOIN
jos_content AS content
ON
c.id = content.catid
WHERE
( c.id = 102 )
AND
c.published = 1
AND
c.access <= 0;
SELECT DISTINCT
cats.title AS cat,
users.name AS author,
users.email AS author_email,
cats.section AS SID,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.images AS images,
content.id AS IID,
content.hits AS hits,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", content.id, content.alias)
ELSE content.id END AS ID,
CASE WHEN CHAR_LENGTH(cats.alias)
THEN CONCAT_WS(":", cats.id, cats.alias)
ELSE cats.id END AS CID
FROM
jos_content AS content
LEFT JOIN
jos_categories AS categories
ON categories.id = content.catid
LEFT JOIN
jos_sections AS sections
ON sections.id = content.sectionid
LEFT JOIN
jos_users AS users
ON users.id = content.created_by
LEFT JOIN
jos_content_frontpage AS frontpage
ON content.id = frontpage.content_id
LEFT JOIN
jos_categories AS cats
ON content.catid = cats.id
LEFT JOIN
jos_content_rating AS content_rating
ON content_rating.content_id = content.id
WHERE
content.state = 1
AND categories.access <= 0
AND content.access <= 0
AND categories.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2020-01-21 15:41:14' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2020-01-21 15:41:14' )
AND ( content.catid = 102 )
AND content.created >= '2016-09-15 00:00:00'
ORDER BY
content.created DESC
LIMIT
0,12;
SELECT *
FROM jos_modules
WHERE id='139'
SELECT *
FROM jos_modules
WHERE id='139'
SELECT *
FROM jos_modules
WHERE id='139'
SELECT *
FROM jos_modules
WHERE id='139'
SELECT *
FROM jos_modules
WHERE id='139'
SELECT *
FROM jos_modules
WHERE id='139'
SELECT *
FROM jos_modules
WHERE id='289'
SELECT *
FROM jos_modules
WHERE id='289'
SELECT *
FROM jos_modules
WHERE id='289'
SELECT *
FROM jos_modules
WHERE id='289'
SELECT *
FROM jos_modules
WHERE id='289'
SELECT *
FROM jos_modules
WHERE id='289'
SELECT *
FROM jos_modules
WHERE id='289'
SELECT *
FROM jos_modules
WHERE id='289'
SELECT *
FROM jos_modules
WHERE id='289'
SELECT *
FROM jos_modules
WHERE id='289'
SELECT *
FROM jos_modules
WHERE id='289'
Yetenek Sizsiniz, O Ses Türkiye yarışmalarında boy gösteren, Ahlat Ağacı filminin başrol oyuncusu ve BKM Mutfak ekibinden Komedyen Doğu Demirkol, tek kişilik şovuyla New York'ta sahne alıyor. IN 212 Prodüksiyon ve BKM (Beşiktaş Kültür Merkezi) işbirliğiyle sahneye çıkacak olan Demirkol, kendi yaşantısından ve gözlemlerinden oluşan tek kişilik gösterisini New York’ta, Art & Design HS tiyatro salonunda gerçekleştirecek. Demirkol, ünlü yönetmen Nuri Bilge Ceylan'ın Ahlat Ağacı filminin de başrol oyuncusu olarak ismini duyurmuştu. Film, Cannes Film Festivali'nde dakikalarca ayakta alkışlanmıştı.
MÜSİAD USA, Birleşmiş Milletler tarafından da kutlanan Dünya Kadınlar Günü etkinlikleri kampasında New York'ta bir kadın zirvesi organize etti. Harvard Club'ta gerçekleştirilen etkinlikte konuşan Türkiye Cumhuriyeti Aile, Çalışma ve Sosyal Hizmetler Bakanı Zehra Zümrüt Selçuk, kadınların sosyal ve ekonomik alanda daha etkin olmalarının toplumun gelişimi için çok önemli olduğunu söyledi. Bakan Selçuk, kadının iş hayatında önündeki engelleri kaldırmak için çalıştıklarını, iş gücündeki kadın oranını 2023'te yğzde 41'e çıkarmayı hedeflediklerini söyledi. Sempozyumun kapanışında konuşan MÜSİAD USA Başkanı Mustafa Tuncer, bir gün MÜSİAD'ın başında da bir kadın başkan görmeyi arzu ettiklerini söyledi. Tuncer, ''Bu yıl ikincisini organize ettiğimiz kadınlar zirvesinde, kadınların sosyal ve iş hayatında yaşadıkları sıkıntılara dikkat çekmeye çalıştık,'' dedi.
Sahip olduğu güçlü finansal yapısı ve bugüne kadar Türkiye'de başarıyla gerçekleştirdiği projelerle Ege Yapı, ABD’deki Türklere özel ödeme planları ile satışları devam eden Batışehir, Cer İstanbul, ÇamlıYaka Konakları, Kordon İstanbul ile İzmir’de inşa edeceği yeni projesinden ev sahibi yapacak. Türkiye gayrimenkul sektörünün öncü markalarından Ege Yapı, ABD’de yaşayan Türklere İstanbul ve İzmir'de kira öder gibi ev sahibi olma imkanı sunuyor. Ege Yapı, Türkiye ve Türkiye dışında konut, ofis, otel, alışveriş merkezi ve eğitim kurumu gibi birçok projenin müteahhitlik ve gayrimenkul geliştirme işlerini gerçekleştiriyor.
Kore Savaşı'nda savaş meydanında annesi ve babası öldürülen küçük bir Koreli kız çocuğunun bir Türk astsubay tarafından kurtarılmasını ve korunmasını konu eden Ayla filmi New York'ta göz yaşları içinde izlendi. Amerikan, Türk ve Kore marşlarının okunması ile başlayan gecede, Türk ve Kore milli marşlarını Koreli sanatçı So Young seslendirdi. Türkiye ve Kore New York başkonsoloslarının ve 10 Kore gazisinin katıldığı gecede, duygulu anlar yaşandı. Salonda bulunan Kore gazileri salondakiler tarafından ayakta alkışlandı. Amerika'da yaşayan Türk ve Korelilerin ilgi gösterdiği gecede sponsorlardan elde edilen gelir Ankara Şehit ve Gaziler Derneğine bağışlandı. Film ücretsiz olarak gösterildi. 
Yayınladığı andan itibaren büyük ses getiren ve Türk-Kore dostluğunu beyaz perdeye taşıyan Ayla filmi, New York'ta seyircilerle buluşuyor. Gösterimine destek veren sponsorlardan elde edilen gelirin Ankara Şehit ve Gaziler Derneğine bağışlanacağı film ücretsiz olarak gösterime sunulacak. New York'taki 480 kişilik SVA Theatre'de 8 Mart'ta gösterilecek film, Kore Savaşı'nda omuz omuza çarpışan Türk ve Koreli gazilere onurlandırmak amacı da taşıyor.
Türkiye’de kurduğu InBox isimli E-Mail Marketing şirketinin bir ayağını Kanada’ya taşıyan Onur Genç, Kanada’dan StartUp programı ile göçmenlik almayı başaran ilk Türk şirketi sahibi oldu. 16 aylık denetlemenin ardından Kanada hükümeti tarafından start-up olarak kabul edilen InBox, Kanada'nın üçüncü büyük e-mail pazarlama şirketi oldu.
ABD’de kurdukları SBK-USA Holding şirketiyle Amerikan maliyesini 511 milyon dolar dolandırıp; paraları Türkiye’deki SBK Holding’e aktardıkları ve Türkiye’de pek çok şirket satın aldıkları iddia edilen Ermeni asıllı Amerikalı sanıklar için 417 yıla kadar hapis cezası isteneceği belirtildi. ABD'de, Türkiye'ye kaçmak üzereyken FBI tarafından gözaltına alınan ve 2 yıl önce Borajet'i satın alan SBK Holding'in finansörü olduğu iddia edilen Ermeni asıllı Türk vatandaşı Lev Aslan Dermen (Levon Termendzhyan) ile ortakları Jacob ve Isaiah Kingston kardeşlerin Utah'ta görülen son kefalet duruşmasında, Kingston kardeşlerin Haziran ayında başlayacak duruşmalara kadar cezaevinde kalmasına karar verildi. Hâkim Brook C. Wells'in karar yazısında Jacob Kingston'un en az 134 milyon, kardeşi Isaiah'ın ise yine en az 52 milyon doları Türkiye'ye kaçırdığının iddia edildiği ve duruşma gününe kadar hapishanede kalacakları belirtildi. Diğer sanık Dermen'in de kefalet başvurusu yine reddedilmişti.
