LF-ChampagneArdenne
DJ - Troyes (10)
Disco
Afro
RNB
DJ
SMA Éven't
14 évaluations
Blues
Métal
Pop
Rap
Rock
Soul
Variété Internationale
Zouk
Musique Africaine
Latino
Jazz
House
Bossa Nova
Country
Disco
Electro
Flamenco
Folk
Funk
Gospel
RNB
1 artiste
Dampierre (10)
Voir la zone de déplacement
Dispose de son propre matériel
Galerie vidéo
(10)
(48)
Galerie vidéo
(10)
(48)
Présentation
93%
Des retours évaluent l’éxpérience
Coup de coeur
14 évaluations
SMA éven't, anciennement connue sous le nom de BEN Animation, est spécialisée dans la prestation DJ professionnel pour divers événements tels que les cérémonies de mariage/PACS, les anniversaires, les soirées d'association, les réunions de comité d'entreprise, les soirées à thème, et le réveillon du Nouvel An. Fournissant un travail de qualité avec un matériel professionnel, SMA éven't s'engage à faire de votre événement une expérience inoubliable. Avec un service centré sur la satisfaction client, nous assurons un suivi étroit pour garantir le déroulement fluide de votre événement.
Frais de déplacement 0.80€/km TTC
Afin d'assurer le succès de votre événement, SMA Event sera votre conseiller dédié tout au long de la planification, fournissant des solutions personnalisées à vos exigences.
MARIAGE : Le service complet de SMA Event inclut la sonorisation de votre cérémonie, de votre vin d'honneur et de vos cocktails, ainsi que de la célébration du jour le plus mémorable de votre vie. Pour une expérience personnalisée, SMA Event fera vibrer la soirée, entrainant vos invités dans une danse jusqu'aux premières lueurs de l'aube.
SMA Event se distingue non seulement par son DJ professionnel fiable, ponctuel et à l'écoute de ses clients, mais également par son matériel de qualité supérieure en matière de sonorisation, d'éclairage et d'effets spéciaux.
De plus, SMA Event propose un vaste éventail d'options pour enrichir votre cérémonie :
DJ professionnel pour soirée
Concepteur d'événements
Mise en scène lumineuse de votre événement
Sonorisation de votre lieu de réception
Lire la suite
Avis (14)
Ils lui ont fait confiance
Vous aimerez aussi...
string(12504) "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 = 4
AND start_provider_schedule < CAST("15:05:03" AS time)
AND end_provider_schedule > CAST("15:05:03" 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(48.549999))
* COS(RADIANS(lat_provider))
* COS(RADIANS(4.36667 - lng_provider))
+ SIN(RADIANS(48.549999))
* 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 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 id_provider IN (61697,49201,58917,60197,48604)
GROUP BY id_provider
ORDER BY FIELD(id_provider, 61697,49201,58917,60197,48604)"