Casino Drive

Casino Drive Mandelieu-la-napoule ( 06210 )

Pour joindre par téléphone Casino Drive de Mandelieu-la-napoule : 04.92.97.74.00

l'adresse de ce drive est : Casino Drive Mandelieu-la-napoule
cc géant casino 21 route de fréjus quartier minelle
06210 Mandelieu-la-napoule

Les heures d'ouverture et de fermeture : non communiqué

Carte géographique du drive Mandelieu-la-napoule :

(default) 3 queries took 33 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Drive`.`id`, `Drive`.`store_id`, `Drive`.`adresse`, `Drive`.`code_postal`, `Drive`.`ville`, `Drive`.`slug_ville`, `Drive`.`telephone`, `Drive`.`horaire`, `Drive`.`department_id`, `Department`.`id`, `Department`.`name`, `Department`.`slug`, `Department`.`num_dpt`, `Department`.`region_id`, `Store`.`id`, `Store`.`name`, `Store`.`slug`, `Store`.`url`, `Store`.`content`, `Store`.`pub` FROM `drives`.`drives` AS `Drive` LEFT JOIN `drives`.`departments` AS `Department` ON (`Drive`.`department_id` = `Department`.`id`) LEFT JOIN `drives`.`stores` AS `Store` ON (`Drive`.`store_id` = `Store`.`id`) WHERE `Drive`.`id` = 126 LIMIT 11120
2SELECT `Region`.`id`, `Region`.`name`, `Region`.`slug`, `Region`.`content`, `Region`.`contenu` FROM `drives`.`regions` AS `Region` WHERE `Region`.`id` = 21 110
3SELECT `Drive`.`id`, `Drive`.`store_id`, `Drive`.`adresse`, `Drive`.`code_postal`, `Drive`.`ville`, `Drive`.`slug_ville`, `Drive`.`telephone`, `Drive`.`horaire`, `Drive`.`department_id`, `Department`.`slug`, `Store`.`name`, `Store`.`slug`, `Store`.`url` FROM `drives`.`drives` AS `Drive` inner JOIN `drives`.`departments` AS `Dep` ON (`Dep`.`id` = `Drive`.`department_id`) inner JOIN `drives`.`regions` AS `Region` ON (`Region`.`id` = `Dep`.`region_id`) LEFT JOIN `drives`.`departments` AS `Department` ON (`Drive`.`department_id` = `Department`.`id`) LEFT JOIN `drives`.`stores` AS `Store` ON (`Drive`.`store_id` = `Store`.`id`) WHERE `Department`.`slug` = 'alpes-maritimes' ORDER BY rand() ASC LIMIT 22213