DJ

Musi-Ka

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

Saint-Pardoux-du-Breuil (47)

Voir la zone de déplacement

Dispose de son propre matériel


Présentation

Musi-Ka est une discomobile professionnelle inscrite au registre des entreprises, elle est implantée dans le Lot et Garonne à St Pardoux du Breuil commune proche de Marmande.
Nous mettons à votre disposition tout notre savoir faire et toute notre expérience pour transformer vos soirées en moments inoubliables.
Une sonorisation de qualité ainsi qu'une animation à la hauteur de vos attentes avec trois formules Son & Lumières à votre dispositions pour anniversaire, mariage, baptême, manifestation événementielle, soirée entre amis à organiser.
Musiques:
Nous adaptons notre programmation musicale en fonction de vos choix et du public.
Gratuits et à votre convenance:
Vidéoprojecteur avec grand écran pour passage avant le dessert d'un diaporama surprise préparée par le client ou invités.
Animations et jeux que vous aurez préalablement choisi lors de notre rdv préparatoire.
Karaoké sur grand écran avec 4 micros sans fils qui peut se faire à l'apéro ou pendant le repas pour distraire les convives (On le propose uniquement pour des anniversaires mais il n'y a pas d'obligation).
Sonorisation du cocktail apéritif hors salle de réception si moins de 40 mètres de la sonorisation principale.
Possibilité d'ajouter des titres musiques de votre choix
Options:
Film de votre soirée.
- Possibilité d'avoir la compilation des vidéos de votre soirée gratuitement, 3 à 4 heures de vidéo format MP4 HD sur clé USB 16 Go à regarder sur vos écrans multimédias.
Mariage Laïque.
- Pour se marier autrement, hors du cadre religieux, la cérémonie laïque est une alternative qui se développe de plus en plus, nous pouvons vous aider et sonorisé cette événement.
Ecoute et satisfaction du client:
Rendez-vous préparatoires, afin de vous conseiller et d’élaborer ensemble le déroulement de votre événement, nous construisons votre soirée sur mesure en tenant compte de vos goûts et de vos exigences musicales, des animations souhaitées, jusqu'aux surprises prévues par les invités, au cours de ces RDV nous vous présentons des photos et des vidéos de nos prestations passées (animations, jeux et musiques).
Le rendez-vous chez moi est gratuit et sans obligation d'engagement.
Coordination avec les différents intervenants:
Afin de vous laissez profiter au maximum de votre soirée, nous assurerons une parfaite coordination avec les différents intervenants présents, tout en gardant bien sur le déroulement que nous aurons convenu lors de nos rendez-vous.
Horaire:
Pour que nos devis soient aux plus justes de votre budget nous sommes obligés d'avoir une fourchette horaire de fin, cette limite est 4 heure du matin.
Il est possible d'avoir une fin plus tardive mais uniquement avec la formule MAX .

Les garanties:
- Engagement par contrat écrit.
- Questionnaire en double exemplaire.
- Assurance multirisque professionnelle.
- Respect de la réglementation sonore

Nous adaptons notre programmation musicale en fonction de vos choix et du public.
Gratuits et à votre convenance:
Vidéoprojecteur avec grand écran pour passage avant le dessert d'un diaporama surprise préparée par le client ou invités.
Animations et jeux que vous aurez préalablement choisi lors de notre rdv préparatoire.
Karaoké sur grand écran avec 4 micros sans fils qui peut se faire à l'apéro ou pendant le repas pour distraire les convives (On le propose uniquement pour des anniversaires mais il n'y a pas d'obligation).
Sonorisation du cocktail apéritif hors salle de réception si moins de 40 mètres de la sonorisation principale.
Possibilité d'ajouter des titres musiques de votre choix
Options:
Film de votre soirée.
- Possibilité d'avoir la compilation des vidéos de votre soirée gratuitement, 3 à 4 heures de vidéo format MP4 HD sur clé USB 16 Go à regarder sur vos écrans multimédias.

Lire la suite

string(12493) "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:38:00" AS time)
					AND end_provider_schedule > CAST("14:38:00" 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(44.483299))
					* COS(RADIANS(lat_provider))
					* COS(RADIANS(0.216667 - lng_provider))
					+ SIN(RADIANS(44.483299))
					* 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 (48701,58817,59006,48668)
			GROUP BY id_provider
			ORDER BY FIELD(id_provider, 48701,58817,59006,48668)"