SELECT *, a.id as id_serv, a.titre_en as titre, a.description_en as description, b.color as color, b.titre_en as titre_serv FROM spectacles a LEFT JOIN services b ON b.id=a.ref_services WHERE a.publier ='Oui' AND a.ref_services <> 0 AND a.ref_services <> '' ORDER BY a.ordre ASC, a.id DESC LIMIT 12,12

Dinosaurs World

Animations

Dinosaurs World
;

Honoring Ceremony for the artist Abdelkarim Al lkader

Concerts

Honoring Ceremony for the artist Abdelkarim Al lkader
;

Concerts

;

Concerts

;

Circus on ice

Animations

Circus on ice
;

Concerts

;

King Abdulaziz Camel Festival

Animations

King Abdulaziz Camel Festival
;

New Mazda Launch Party

Animations

New Mazda Launch Party
;

Concert Rashed Al-Majed & Mohammed Abdu organized by AAA &MMG Live

Concerts

Concert Rashed Al-Majed & Mohammed Abdu organized by AAA &MMG Live
;

Concert Marc Anthony

Concerts

Concert Marc Anthony
;

B2B meeting by "Orange Business Club"

Marketing Events

B2B meeting by
;

HOT-RACE NITRO CUP

Sports

HOT-RACE NITRO CUP
;