Mick évents sonorisation
DJ - Armentières (59)
DJ / Artiste solo
1 évaluation
1 artiste
Bondues (59)
Voir la zone de déplacement
Dispose de son propre matériel
100%
Des retours évaluent l’éxpérience
1 évaluation
Découvrez Luk Event, l'agence événementielle de référence pilotée par Lucas Brunet, qui promet de transformer chaque événement en une expérience mémorable. En tant que DJ Lu-K, Lucas apporte une ambiance musicale exceptionnelle, tandis que son expertise en sonorisation, éclairage et location de matériel assure des services impeccables. Que vous planifiez une soirée privée, un anniversaire, un mariage ou un événement d'entreprise, Luk Event s'engage à offrir des prestations sur mesure et un accompagnement personnalisé pour créer des moments inoubliables. Faites de votre événement une célébration unique avec Luk Event.
La tarification chez Luk Event est pensée pour s’adapter parfaitement à chaque événement, car nous savons que chaque projet est unique. Un devis personnalisé sera établi pour répondre précisément à vos besoins et à vos attentes. Nous proposons différents packs incluant les services de base en sonorisation, éclairage et animation, auxquels il est possible d’ajouter des options pour une expérience encore plus enrichie : jets de scène, machines à fumée (classique, lourde, brouillard), et autres effets visuels. Que vous optiez pour un pack clé en main ou une prestation entièrement personnalisée, Luk Event garantit une qualité de service exceptionnelle et un accompagnement adapté à votre budget.
Optez pour Luk Event et transformez vos événements en expériences inoubliables. Notre équipe est capable de sonoriser des salles accueillant jusqu'à 500 personnes avec une qualité optimale. Découvrez notre vaste gamme de matériels de sonorisation et d'éclairage professionnels, y compris des machines à effets, des jets de scènes (sparkular) et des machines à fumée variées (Classique, Lourde, Brouillard). Nous personnalisons nos équipements selon le lieu et l'occasion pour faire de chaque événement un moment unique. En choisissant Luk Event, vous assurez le succès de votre événement.
Lire la suite
Concerts
Prends ta place !
09
nov
Gratuit
Hallennes-lez-Haubourdin - 18H00
420 Rue des Bourreliers
Ils lui ont fait confiance
string(12500) "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:21:47" AS time)
AND end_provider_schedule > CAST("15:21:47" 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(50.700001))
* COS(RADIANS(lat_provider))
* COS(RADIANS(3.1 - lng_provider))
+ SIN(RADIANS(50.700001))
* 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 (60197,58917,49201,61697,49403)
GROUP BY id_provider
ORDER BY FIELD(id_provider, 60197,58917,49201,61697,49403)"