LES FORMATIONS
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='5' OR `niveau_etudes_id` LIKE '5,%' OR `niveau_etudes_id` LIKE '%,5,%' OR `niveau_etudes_id` LIKE '%,5') AND domaines_id=1 ORDER BY ordre ASC
Ville :
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='1' OR `niveau_etudes_id` LIKE '1,%' OR `niveau_etudes_id` LIKE '%,1,%' OR `niveau_etudes_id` LIKE '%,1') AND domaines_id=1 ORDER BY ordre ASC
Ville :
- formation bac +2
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='2' OR `niveau_etudes_id` LIKE '2,%' OR `niveau_etudes_id` LIKE '%,2,%' OR `niveau_etudes_id` LIKE '%,2') AND domaines_id=1 ORDER BY ordre ASC
Ville :
- formation bac +3
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='3' OR `niveau_etudes_id` LIKE '3,%' OR `niveau_etudes_id` LIKE '%,3,%' OR `niveau_etudes_id` LIKE '%,3') AND domaines_id=1 ORDER BY ordre ASC
Ville :
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='4' OR `niveau_etudes_id` LIKE '4,%' OR `niveau_etudes_id` LIKE '%,4,%' OR `niveau_etudes_id` LIKE '%,4') AND domaines_id=1 ORDER BY ordre ASC
Ville :
- formation bac +5
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='5' OR `niveau_etudes_id` LIKE '5,%' OR `niveau_etudes_id` LIKE '%,5,%' OR `niveau_etudes_id` LIKE '%,5') AND domaines_id=2 ORDER BY ordre ASC
Ville :
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='1' OR `niveau_etudes_id` LIKE '1,%' OR `niveau_etudes_id` LIKE '%,1,%' OR `niveau_etudes_id` LIKE '%,1') AND domaines_id=2 ORDER BY ordre ASC
Ville :
- formation bac +2
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='2' OR `niveau_etudes_id` LIKE '2,%' OR `niveau_etudes_id` LIKE '%,2,%' OR `niveau_etudes_id` LIKE '%,2') AND domaines_id=2 ORDER BY ordre ASC
Ville :
- formation bac +3
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='3' OR `niveau_etudes_id` LIKE '3,%' OR `niveau_etudes_id` LIKE '%,3,%' OR `niveau_etudes_id` LIKE '%,3') AND domaines_id=2 ORDER BY ordre ASC
Ville :
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='4' OR `niveau_etudes_id` LIKE '4,%' OR `niveau_etudes_id` LIKE '%,4,%' OR `niveau_etudes_id` LIKE '%,4') AND domaines_id=2 ORDER BY ordre ASC
Ville :
- formation bac +5
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='5' OR `niveau_etudes_id` LIKE '5,%' OR `niveau_etudes_id` LIKE '%,5,%' OR `niveau_etudes_id` LIKE '%,5') AND domaines_id=4 ORDER BY ordre ASC
Ville :
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='1' OR `niveau_etudes_id` LIKE '1,%' OR `niveau_etudes_id` LIKE '%,1,%' OR `niveau_etudes_id` LIKE '%,1') AND domaines_id=4 ORDER BY ordre ASC
Ville :
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='2' OR `niveau_etudes_id` LIKE '2,%' OR `niveau_etudes_id` LIKE '%,2,%' OR `niveau_etudes_id` LIKE '%,2') AND domaines_id=4 ORDER BY ordre ASC
Ville :
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='3' OR `niveau_etudes_id` LIKE '3,%' OR `niveau_etudes_id` LIKE '%,3,%' OR `niveau_etudes_id` LIKE '%,3') AND domaines_id=4 ORDER BY ordre ASC
Ville :
- formation bac +4
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='4' OR `niveau_etudes_id` LIKE '4,%' OR `niveau_etudes_id` LIKE '%,4,%' OR `niveau_etudes_id` LIKE '%,4') AND domaines_id=4 ORDER BY ordre ASC
Ville :
- formation bac +5
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='5' OR `niveau_etudes_id` LIKE '5,%' OR `niveau_etudes_id` LIKE '%,5,%' OR `niveau_etudes_id` LIKE '%,5') AND domaines_id=6 ORDER BY ordre ASC
Ville :
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='1' OR `niveau_etudes_id` LIKE '1,%' OR `niveau_etudes_id` LIKE '%,1,%' OR `niveau_etudes_id` LIKE '%,1') AND domaines_id=6 ORDER BY ordre ASC
Ville :
- formation bac +2
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='2' OR `niveau_etudes_id` LIKE '2,%' OR `niveau_etudes_id` LIKE '%,2,%' OR `niveau_etudes_id` LIKE '%,2') AND domaines_id=6 ORDER BY ordre ASC
Ville :
- formation bac +3
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='3' OR `niveau_etudes_id` LIKE '3,%' OR `niveau_etudes_id` LIKE '%,3,%' OR `niveau_etudes_id` LIKE '%,3') AND domaines_id=6 ORDER BY ordre ASC
Ville :
- formation bac +4
SELECT * FROM `formation` WHERE `ecole_id_2` IS NOT NULL AND `ecole_id_2`!="" AND `ecole_id_2`<>"0" AND (`niveau_etudes_id`='4' OR `niveau_etudes_id` LIKE '4,%' OR `niveau_etudes_id` LIKE '%,4,%' OR `niveau_etudes_id` LIKE '%,4') AND domaines_id=6 ORDER BY ordre ASC
Ville :
- formation bac +5