DJ
Clé en Main
2 évaluations
Blues
Métal
Pop
Rap
Rock
Soul
Variété Internationale
Zouk
Musique Africaine
RNB
Latino
Jazz
Bossa Nova
Country
Disco
Electro
Flamenco
Folk
Funk
Gospel
House
Musique traditionnelle
1 artiste
Urville (14)
Voir la zone de déplacement
Dispose de son propre matériel
Galerie photo
Présentation
100%
Des retours évaluent l’éxpérience
Ambiance de folie
2 évaluations
Christophe ALLAIN est un expert de l’animation de soirée avec plus de 25 ans d’expérience. Vous recherchez une animation originale et dynamique pour votre soirée ? Christophe ALLAIN est le professionnel qu’il vous faut pour mettre l’ambiance et créer une atmosphère festive unique. Avec sa solide expérience dans l’animation de soirée, il saura vous offrir un service de qualité et personnalisé.
Christophe est l'animateur idéal pour votre soirée. Il saura s'adapter à vos goûts musicaux et à vos souhaits pour vous offrir une expérience inoubliable. Que vous recherchiez de la musique festive ou relaxante, Christophe saura vous satisfaire.
Lire la suite
Avis (2)
Ils lui ont fait confiance
Foire aux questions
La Clé en Main offre une large gamme de styles musicaux, allant du blues à la bossa nova, en passant par le disco, l'électro, le jazz, et bien d'autres encore pour satisfaire tous les goûts.
Christophe Allain, de La Clé en Main, collabore étroitement avec chaque client pour sélectionner les chansons qui seront jouées, garantissant ainsi une ambiance parfaitement adaptée à vos attentes.
Avec plus de 25 ans d'expérience, Christophe Allain de La Clé en Main est un expert dans l'animation de soirées, offrant des prestations de qualité et personnalisées.
La Clé en Main est capable d'animer divers événements, tels que mariages, anniversaires, soirées privées, et bien d'autres, avec un minimum tarifaire de 800 euros.
Oui, La Clé en Main propose de rencontrer les clients avant l'événement pour discuter des besoins musicaux et garantir une prestation sur mesure.
Oui, les prestations en plein air ne posent aucun problème pour La Clé en Main, qui s'adapte à tous les environnements.
Le tarif minimum pour une prestation de La Clé en Main est de 800 euros, selon le type d'événement.
Oui, il est possible d'ajouter des heures supplémentaires à votre prestation, sous réserve de disponibilité et moyennant des frais supplémentaires.
Les clients de La Clé en Main apprécient particulièrement le professionnalisme et l'ambiance festive assurée par Christophe Allain, comme en témoignent les avis positifs.
Oui, La Clé en Main apporte tout le matériel nécessaire, incluant sonorisation et éclairage, pour garantir une prestation de qualité.
Il est recommandé de contacter La Clé en Main entre 18 mois et 1 an à l'avance pour obtenir un devis et valider votre prestation.
Oui, les frais de déplacement sont facturés par La Clé en Main.
La Clé en Main peut se déplacer jusqu'à 300 km pour animer vos événements.
Un espace de 4 mètres est nécessaire pour réaliser une prestation DJ avec La Clé en Main.
Oui, il est tout à fait possible de demander des chansons qui ne figurent pas dans le répertoire de La Clé en Main.
La Clé en Main est disponible du lundi au vendredi de 10h00 à 17h00 pour discuter de vos besoins.
Grâce à son expertise et à sa capacité d'adaptation, Christophe Allain de La Clé en Main crée une atmosphère festive unique, adaptée à chaque événement.
Les prestations de La Clé en Main incluent une diversité de styles musicaux, tels que le funk, la soul, le rock, le pop et bien d'autres, pour satisfaire toutes les préférences.
Les modalités de paiement pour une prestation de La Clé en Main peuvent être discutées lors de la prise de contact pour un devis personnalisé.
Oui, La Clé en Main offre diverses options de personnalisation pour ses prestations, afin de répondre précisément aux souhaits des clients.
string(13828) "SELECT
id_provider,
id_external_provider,
siret_provider,
guso_provider,
slug_provider,
lat_provider,
lng_provider,
address_provider,
id_country,
name_provider,
description_provider,
description_opening_provider,
description_service_provider,
description_access_provider,
description_environment_provider,
description_capacity_provider,
description_lodging_provider,
description_pricing_provider,
description_catering_provider,
description_hobbies_provider,
h1_provider,
meta_title_provider,
meta_description_provider,
area_provider,
id_site_provider,
id_formula_provider,
date_end_new_provider,
date_end_boost_golead_provider,
free_end_provider,
is_visible_provider,
is_invisible_golead_provider,
is_schedule_open_provider,
is_full_location_provider,
position_tmp_provider,
nb_picture_provider,
nb_video_provider,
nb_review_provider,
avg_score_provider,
last_review_content_provider,
id_service,
name_service_lang,
fa_service,
path_picture_service,
id_city,
code_city,
name_city_lang,
id_department,
code_department,
name_department_lang,
code_country,
name_country_lang,
position_subs_list,
id_subs_type_subs_list,
id_provider_promotion,
id_department_subs_provider_detail,
is_sydhev_provider,
is_historic_residence_provider,
is_rse_provider,
state_rse_provider,
is_assocem_provider,
memo_administrator_provider,
has_own_material,
cover_provider,
phone_provider,
is_ohmyague_provider,
is_privateaser_provider,
id_privateaser_provider,
created_at_provider,
updated_at_provider,
(
SELECT JSON_ARRAYAGG(id_typology)
FROM provider_typology
JOIN typology ON id_typology = id_typology_provider_typology
JOIN typology_lang ON id_typology_typology_lang = id_typology
WHERE id_provider_provider_typology = id_provider
AND is_deleted_typology_lang = FALSE
AND id_parent_typology IS NOT NULL
) as ids_typology,
(
SELECT GROUP_CONCAT(name_typology_lang SEPARATOR " / ")
FROM provider_typology
JOIN typology ON id_typology = id_typology_provider_typology
JOIN typology_lang ON id_typology_typology_lang = id_typology
WHERE id_provider_provider_typology = id_provider
AND is_deleted_typology_lang = FALSE
AND id_parent_typology IS NULL
) as typologys,
(
SELECT GROUP_CONCAT(name_typology_lang ORDER BY order_provider_typology ASC SEPARATOR " • " LIMIT 3)
FROM provider_typology
JOIN typology ON id_typology = id_typology_provider_typology
JOIN typology_lang ON id_typology_typology_lang = id_typology
WHERE id_provider_provider_typology = id_provider
AND is_deleted_typology_lang = FALSE
AND id_parent_typology IS NOT NULL
AND id_parent_typology <> 222
) as typologys_caterer,
(
SELECT GROUP_CONCAT(CONCAT(name_typology_lang, " ", emoji_typology) ORDER BY order_provider_typology ASC SEPARATOR " ,")
FROM provider_typology
JOIN typology ON id_typology = id_typology_provider_typology
JOIN typology_lang ON id_typology_typology_lang = id_typology
WHERE id_provider_provider_typology = id_provider
AND is_deleted_typology_lang = FALSE
AND id_parent_typology IS NOT NULL
AND is_exclusive_provider_typology = TRUE
) as exclusive_typologys_caterer,
(
SELECT GROUP_CONCAT(name_service_lang ORDER BY order_provider_dj_service ASC SEPARATOR "," LIMIT 3)
FROM provider_dj_service
JOIN service ON id_service = id_service_provider_dj_service
JOIN service_lang ON id_service_service_lang = id_service AND id_lang_service_lang = 1
WHERE id_provider_provider_dj_service = id_provider
) services,
(
SELECT score_review
FROM review
WHERE id_provider_review = id_provider
AND is_deleted_review = FALSE
GROUP BY score_review
ORDER BY COUNT(*) DESC
LIMIT 1
) as score_review,
(
SELECT avatar_user
FROM provider_user
JOIN user ON id_user = id_user_provider_user
WHERE id_provider_provider_user = id_provider
AND is_manager_provider_user = TRUE
) as avatar_user,
(
SELECT
1
FROM provider_user
JOIN visio_user ON id_user_visio_user = id_user_provider_user
JOIN user ON id_user = id_user_visio_user
WHERE id_provider_provider_user = id_provider
AND receive_visio_provider_user = TRUE
AND is_online_visio_user = TRUE
AND mail_user IS NOT NULL
LIMIT 1
) AS is_user_online_visio,
(
SELECT
1
FROM provider_user
JOIN user ON id_user = id_user_provider_user
WHERE id_provider_provider_user = id_provider
AND receive_visio_provider_user = TRUE
AND mail_user IS NOT NULL
LIMIT 1
) AS is_user_receive_visio,
(
SELECT
1
FROM provider_user
JOIN user ON id_user = id_user_provider_user
WHERE id_provider_provider_user = id_provider
AND receive_visio_provider_user = TRUE
AND login_at_user > DATE_SUB(NOW(), INTERVAL 30 MINUTE)
AND mail_user IS NOT NULL
LIMIT 1
) AS is_user_online,
(
SELECT
1
FROM provider_schedule
WHERE id_provider_provider_schedule = id_provider
AND day_provider_schedule = 3
AND start_provider_schedule < CAST("22:14:19" AS time)
AND end_provider_schedule > CAST("22:14:19" AS time)
LIMIT 1
) AS is_schedule_online,
(
SELECT
MIN(price_provider_package)
FROM provider_package
WHERE id_provider_provider_package = id_provider
) AS minimum_price_package,
(
SELECT
price_per_pax_provider_package
FROM provider_package
WHERE id_provider_provider_package = id_provider
ORDER BY price_provider_package ASC
LIMIT 1
) AS per_pax_provider_package,
(
SELECT
MIN(price_provider_capacity)
FROM provider_capacity
WHERE id_provider_provider_capacity = id_provider
AND only_provider_capacity = TRUE
) AS minimum_price_capacity,
(
SELECT
MAX(price_provider_capacity)
FROM provider_capacity
WHERE id_provider_provider_capacity = id_provider
AND only_provider_capacity = TRUE
) AS maximum_price_capacity,
COALESCE(
LEAST(
MIN(IFNULL(meeting_min_provider_capacity, 9223372036854775807)),
MIN(IFNULL(in_u_min_provider_capacity, 9223372036854775807)),
MIN(IFNULL(class_min_provider_capacity, 9223372036854775807)),
MIN(IFNULL(conference_min_provider_capacity, 9223372036854775807)),
MIN(IFNULL(seat_min_provider_capacity, 9223372036854775807)),
MIN(IFNULL(up_min_provider_capacity, 9223372036854775807))
),
IFNULL(meeting_min_provider_capacity, 9223372036854775807),
IFNULL(in_u_min_provider_capacity, 9223372036854775807),
IFNULL(class_min_provider_capacity, 9223372036854775807),
IFNULL(conference_min_provider_capacity, 9223372036854775807),
IFNULL(seat_min_provider_capacity, 9223372036854775807),
IFNULL(up_min_provider_capacity, 9223372036854775807)
) AS pax_min,
COALESCE(
GREATEST(
MAX(IFNULL(meeting_max_provider_capacity, 0)),
MAX(IFNULL(in_u_max_provider_capacity, 0)),
MAX(IFNULL(class_max_provider_capacity, 0)),
MAX(IFNULL(conference_max_provider_capacity, 0)),
MAX(IFNULL(seat_max_provider_capacity, 0)),
MAX(IFNULL(up_max_provider_capacity, 0))
),
IFNULL(meeting_max_provider_capacity, 0),
IFNULL(in_u_max_provider_capacity, 0),
IFNULL(class_max_provider_capacity, 0),
IFNULL(conference_max_provider_capacity, 0),
IFNULL(seat_max_provider_capacity, 0),
IFNULL(up_max_provider_capacity, 0)
) AS pax_max,
(
SELECT
name_provider_picture
FROM provider_picture
WHERE id_provider_provider_picture = id_provider
ORDER BY order_provider_picture ASC
LIMIT 1
) AS name_provider_picture,
(
SELECT
COUNT(*)
FROM provider_menu
WHERE id_provider_provider_menu = id_provider
) AS nb_menu,
is_recommended_provider,
cover_provider
, (
SELECT MIN(CAST(j.value AS UNSIGNED))
FROM provider_package pp2,
JSON_TABLE(pp2.price_duration_provider_package, '$.*' COLUMNS (
value VARCHAR(100) PATH '$'
)) AS j
WHERE pp2.id_provider_provider_package = p.id_provider
) AS minimum_price_duration , (SELECT MIN(minimum_price_provider_event) FROM provider_event WHERE id_provider_provider_event = id_provider AND minimum_price_provider_event > 0 AND minimum_price_provider_event IS NOT NULL) AS minimum_price_event , (SELECT MAX(minimum_price_provider_event) FROM provider_event WHERE id_provider_provider_event = id_provider AND minimum_price_provider_event > 0 AND minimum_price_provider_event IS NOT NULL) AS maximum_price_event ,(
SELECT
SUM(pax_provider_lodging * room_provider_lodging)
FROM provider_lodging
WHERE id_provider_provider_lodging = id_provider
) AS pax_lodging ,(
SELECT
MIN(price_provider_caterer_service)
FROM provider_caterer_service
WHERE id_provider_provider_caterer_service = id_provider
) AS minimum_price_caterer_service ,(
SELECT
MAX(price_provider_caterer_service)
FROM provider_caterer_service
WHERE id_provider_provider_caterer_service = id_provider
) AS maximum_price_caterer_service ,(111.045
* DEGREES(ACOS(COS(RADIANS(49.033298))
* COS(RADIANS(lat_provider))
* COS(RADIANS(-0.3 - lng_provider))
+ SIN(RADIANS(49.033298))
* SIN(RADIANS(lat_provider))))) AS distance
,(
SELECT id_typology
FROM typology
JOIN provider_typology ON id_typology_provider_typology = id_typology
WHERE id_provider_provider_typology = id_provider
ORDER BY order_provider_typology ASC
LIMIT 1
) AS id_typology
FROM
(
SELECT
*,
(111.045 * DEGREES(
ACOS(COS(RADIANS(49.033298)) *
COS(RADIANS(lat_provider)) *
COS(RADIANS(-0.3 - lng_provider)) +
SIN(RADIANS(49.033298)) *
SIN(RADIANS(lat_provider)))
)) AS distance
FROM provider
WHERE is_visible_provider = TRUE
AND id_service_provider = 150
AND id_site_provider = 4
HAVING (FLOOR(distance) <= 300 OR FLOOR(distance) <= area_provider)
) AS p
JOIN service ON id_service = id_service_provider
JOIN service_lang ON id_service_service_lang = id_service AND id_lang_service_lang = 1
JOIN city ON id_city = id_city_provider
JOIN city_lang ON id_city_city_lang = id_city AND id_lang_city_lang = 1
JOIN department ON id_department = id_department_city
JOIN department_lang ON id_department_department_lang = id_department AND id_lang_department_lang = 1
JOIN region ON id_region = id_region_department
JOIN region_lang ON id_region_region_lang = id_region AND id_lang_region_lang = 1
JOIN country ON id_country = id_country_region
JOIN country_lang ON id_country_country_lang = id_country AND id_lang_country_lang = 1
LEFT JOIN subs_provider ON id_provider_subs_provider = id_provider AND is_activated_subs_provider = TRUE
LEFT JOIN subs_provider_detail ON id_subs_provider_subs_provider_detail = id_subs_provider AND is_activated_subs_provider_detail = TRUE
LEFT JOIN subs_list ON id_subs_list = id_subs_list_subs_provider_detail AND id_subs_type_subs_list IN (5,1,2,3)
LEFT JOIN provider_capacity ON id_provider_provider_capacity = id_provider JOIN provider_promotion ON id_provider_provider_promotion = id_provider AND start_at_provider_promotion < NOW() AND end_at_provider_promotion > NOW()
WHERE is_visible_provider = TRUE
AND id_site_provider = 4 AND EXISTS (SELECT 1 FROM provider_event WHERE id_provider_provider_event = id_provider) AND id_service_provider = 150 AND (position_subs_list IS NOT NULL OR id_formula_provider IN (5,2,3)) AND id_provider NOT IN (48816)
GROUP BY id_provider
HAVING 1
ORDER BY
CASE
WHEN (id_formula_provider = 4 AND id_city_provider = 5222) THEN 1
ELSE 2
END,
CASE
WHEN (id_formula_provider = 4) THEN 1
WHEN (id_formula_provider = 3) THEN 2
WHEN (id_formula_provider = 2) THEN 3
WHEN (id_formula_provider = 5) THEN 4
ELSE 5
END,
distance ASC,
ISNULL(position_subs_list) ASC,
position_subs_list ASC,
CASE
WHEN name_provider_picture IS NOT NULL THEN 1
ELSE 2
END,
position_tmp_provider ASC
LIMIT 0, 5"