SELECT
content_type,
content_order,
id,
title,
subtitle,
old_id,
image,
image_id,
intro_text,
intro_text_output,
date_created,
time_created,
author_id,
author_name,
section_name,
section_id
FROM (
(SELECT
('article') as content_type,
(1) as content_order,
ar.id as id,
ar.title as title,
ar.subtitle,
ar.old_id,
ar.image,
ar.image_id,
ar.intro_text,
ar.intro_text_output,
ar.date_created,
ar.time_created,
ar.author_id as author_id,
au.author_name as author_name,
ars.section_name,
ars.id as section_id
FROM
cont_articles ar
LEFT JOIN
cont_authors au
ON
ar.author_id = au.id
LEFT JOIN
cont_sections as ars
ON
ar.section_id = ars.id
WHERE
( MATCH(ar.title) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1
)UNION(
SELECT
('article') as content_type,
(20) as content_order,
ar.id as id,
ar.title as title,
ar.subtitle,
ar.old_id,
ar.image,
ar.image_id,
ar.intro_text,
ar.intro_text_output,
ar.date_created,
ar.time_created,
ar.author_id as author_id,
au.author_name as author_name,
ars.section_name,
ars.id as section_id
FROM
cont_articles ar
LEFT JOIN
cont_authors au
ON
ar.author_id = au.id
LEFT JOIN
cont_sections as ars
ON
ar.section_id = ars.id
WHERE
( MATCH(au.author_name) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1
)UNION(
SELECT
('article') as content_type,
(10) as content_order,
ar.id as id,
ar.title as title,
ar.subtitle,
ar.old_id,
ar.image,
ar.image_id,
ar.intro_text,
ar.intro_text_output,
ar.date_created,
ar.time_created,
ar.author_id as author_id,
au.author_name as author_name,
ars.section_name,
ars.id as section_id
FROM
cont_articles ar
LEFT JOIN
cont_authors au
ON
ar.author_id = au.id
LEFT JOIN
cont_sections as ars
ON
ar.section_id = ars.id
WHERE
( MATCH(ar.subtitle) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1
)UNION(
SELECT
('blog') as content_type,
(2) as content_order,
ar.id as id,
ar.title as title,
('') as subtitle,
ar.old_id,
ar.have_image as image,
ar.image_id,
ar.content as intro_text,
ar.content_output as intro_text_output,
ar.date_created,
ar.time_created,
ar.author_id as author_id,
au.author_name as author_name,
ars.section_name,
ars.id as section_id
FROM
users_blogs ar
LEFT JOIN
cont_authors au
ON
ar.author_id = au.id
LEFT JOIN
blogs_sections as ars
ON
ar.section_id = ars.id
WHERE
( MATCH(ar.title) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1
)UNION(
SELECT
('blog') as content_type,
(21) as content_order,
ar.id as id,
ar.title as title,
('') as subtitle,
ar.old_id,
ar.have_image as image,
ar.image_id,
ar.content as intro_text,
ar.content_output as intro_text_output,
ar.date_created,
ar.time_created,
ar.author_id as author_id,
au.author_name as author_name,
ars.section_name,
ars.id as section_id
FROM
users_blogs ar
LEFT JOIN
cont_authors au
ON
ar.author_id = au.id
LEFT JOIN
blogs_sections as ars
ON
ar.section_id = ars.id
WHERE
( MATCH(au.author_name) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1
)UNION(
SELECT
('article') as content_type,
(23) as content_order,
ar.id as id,
ar.title as title,
ar.subtitle,
ar.old_id,
ar.image,
ar.image_id,
ar.intro_text,
ar.intro_text_output,
ar.date_created,
ar.time_created,
ar.author_id as author_id,
au.author_name as author_name,
ars.section_name,
ars.id as section_id
FROM
cont_articles ar
LEFT JOIN
cont_authors au
ON
ar.author_id = au.id
LEFT JOIN
cont_sections as ars
ON
ar.section_id = ars.id
WHERE
( MATCH(ar.intro_text_output) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1
)UNION(
SELECT
('article') as content_type,
(25) as content_order,
ar.id as id,
ar.title as title,
ar.subtitle,
ar.old_id,
ar.image,
ar.image_id,
ar.intro_text,
ar.intro_text_output,
ar.date_created,
ar.time_created,
ar.author_id as author_id,
au.author_name as author_name,
ars.section_name,
ars.id as section_id
FROM
cont_articles ar
LEFT JOIN
cont_authors au
ON
ar.author_id = au.id
LEFT JOIN
cont_sections as ars
ON
ar.section_id = ars.id
WHERE
( MATCH(ar.content_output) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1
)UNION(
SELECT
('blog') as content_type,
(24) as content_order,
ar.id as id,
ar.title as title,
('') as subtitle,
ar.old_id,
ar.have_image as image,
ar.image_id,
ar.content as intro_text,
ar.content_output as intro_text_output,
ar.date_created,
ar.time_created,
ar.author_id as author_id,
au.author_name as author_name,
ars.section_name,
ars.id as section_id
FROM
users_blogs ar
LEFT JOIN
cont_authors au
ON
ar.author_id = au.id
LEFT JOIN
blogs_sections as ars
ON
ar.section_id = ars.id
WHERE
( MATCH(ar.content_output) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1
)) ToTal
GROUP BY
id
ORDER BY
content_order ASC,
date_created DESC,
time_created DESC,
title ASC
