DJ
TMD Musics
30 évaluations
1 artiste
Orgon (13)
Voir la zone de déplacement
Dispose de son propre matériel
Présentation
50%
Des retours évaluent l’éxpérience
30 évaluations
Le jour de votre prestation vous souhaitez un DJ/animateur expérimenté et de qualité ? TMD MUSICS vous offre ses services et met son talent à votre disposition. Il fera danser tous les âges, à tout moment. Offrez-vous une soirée inoubliable grâce à TMD MUSICS.
TONY M DJ c’est un DJ mais c’est aussi une présence joviale, conviviale, sympa. Une personne agréable qui deviendra un véritable allié pour le plus beau jour de votre vie et ou tous vos evenements. Quel que soit le style de soirée que vous souhaitez, il sera là pour vous.
D’un petit Anniversaire au Mariage de Prestige, TMD MUSICS répond à toutes vos exigences. Il organisera votre soirée de A à Z afin que tout soit comme vous le souhaitiez. Des prestations de qualité à des prix serrés, n’hésitez pas à les contacter !
TMD MUSICS vous propose des prestations d'exception pour chacun de vos événements. Que ce soit pour un anniversaire mémorable ou un mariage de prestige, nous assurons une organisation complète de votre soirée pour un événement qui vous ressemble. Profitez de services de haute qualité à des tarifs compétitifs. Contactez TMD MUSICS dès maintenant pour obtenir un devis gratuit et sans engagement.
Lire la suite
Avis (30)
Ils lui ont fait confiance
Foire aux questions
string(13834) "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("23:24:47" AS time)
AND end_provider_schedule > CAST("23:24: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(43.783298))
* COS(RADIANS(lat_provider))
* COS(RADIANS(5.03333 - lng_provider))
+ SIN(RADIANS(43.783298))
* 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(43.783298)) *
COS(RADIANS(lat_provider)) *
COS(RADIANS(5.03333 - lng_provider)) +
SIN(RADIANS(43.783298)) *
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 (49264)
GROUP BY id_provider
HAVING 1
ORDER BY
CASE
WHEN (id_formula_provider = 4 AND id_city_provider = 4413) 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"