DJ
Magic'lyne Sono
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
Beauzac (43)
Voir la zone de déplacement
Dispose de son propre matériel
Présentation
Vous souhaitez confier l'animation de votre réception de mariage ou tout autres évènements à un professionnel de l'événementiel ? La société Magic'Lyne Sono assure la bonne ambiance de votre soirée et vous garantit une soirée inoubliable.
Magic'Lyne Sono vous propose d'animer en musique la soirée dansante de tout vos évènements.Nous nous tenons à votre écoute pour vous conseiller sur l'organisation de votre soirée, et mettrons tout en oeuvre pour vous proposer une prestation personnalisée.
Magic'Lyne Sono se chargera de l'installation du matériel sonore et visuel.Son animateur dispose d'un répertoire de musique variée en genres et en rythmes pour satisfaire les goûts de chacun,toutes générations confondues.
Magic'Lyne Sono aura le plaisir de vous accompagner en musique sur les lieux de votre choix.
A vos soirées inoubliables
Lire la suite
string(12492) "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("14:37:07" AS time)
AND end_provider_schedule > CAST("14:37:07" 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(45.25))
* COS(RADIANS(lat_provider))
* COS(RADIANS(4.1 - lng_provider))
+ SIN(RADIANS(45.25))
* 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 (66165,66889,52705,49080,48647)
GROUP BY id_provider
ORDER BY FIELD(id_provider, 66165,66889,52705,49080,48647)"