SELECT `ar`.`id`,`ar`.`title`,`ar`.`introtext`,`ar`.`image`,`ar`.`dossier`,`ar`.`publish_up`,`ar`.`legende`,`ar`.`surtitre`,`ar`.`video`,`ar`.`imagequoi`,"redaction" as tab_org,`c`.`title` AS `name`,`c`.`id` AS `catid`
FROM `#__redaction` AS `ar`
LEFT JOIN `#__categories` AS `c` ON (`c`.`id` = `ar`.`catid`)
WHERE featured!=1 AND state=1 AND (catid=66 OR catid=75 OR catid=74 or catid=74)
UNION (
SELECT ar.id,ar.titel as title,ar.chapo as introtext,ar.image,ar.dossier,ar.date_pub as publish_up,"" as legende,"" as surtitre,"" as video,"" as imagequoi,"article" as tab_org,`c`.`title` AS `name`,`c`.`id` AS `catid`
FROM `#__articles` AS `ar`
LEFT JOIN `#__categories` AS `c` ON (`c`.`id` = `ar`.`idrub`)
WHERE (idrub=66 OR idrub=75 OR idrub=74 OR afrique=1) AND ar.published=1
ORDER BY ar.date_pub DESC)
ORDER BY publish_up DESC LIMIT 1, 6