Stage de Récupération de Points MEXY

DEBUG2: SELECT date1, date2, boost_actif, nb_places_allouees, nb_boost_allouees, nb_boost, nb_inscrits, nb_preinscrits, prix, prix_avant_premium, prix_barre, prix_privilege, prix_concurrence, stage.reduction, stage.reduction_pap, stage.id, stage.id_externe, stage.id_membre, stage.pass_sanitaire, stage.boost_stage, option_visibilite, option_visibilite_new, annule, motCle, site.nom, site.ville, site.id_ville, site.adresse, site.departement, site.latitude, site.longitude, plan, site.code_postal, departement.prix_boost_max, membre.nom as nom_membre, membre.cb_actif, membre.taux_annulation, membre.types_paiement ,(6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) AS dist FROM stage, membre, departement, site WHERE membre.id <> 793 AND id_site = site.id AND site.departement = departement.code_departement AND date1 > '2026-07-07' AND nb_places_allouees > 0 AND annule = 0 AND stage.is_online = 1 AND stage.visible = 1 AND stage.id_membre = membre.id AND site.id_membre = membre.id AND (((6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) <= 40) OR (latitude='49.5008363' AND longitude='5.7841998')) ORDER BY date1 ASC, prix ASC LIMIT 100

DEBUG2: SELECT date1, date2, boost_actif, nb_places_allouees, nb_boost_allouees, nb_boost, nb_inscrits, nb_preinscrits, prix, prix_avant_premium, prix_barre, prix_privilege, prix_concurrence, stage.reduction, stage.reduction_pap, stage.id, stage.id_externe, stage.id_membre, stage.pass_sanitaire, stage.boost_stage, option_visibilite, option_visibilite_new, annule, motCle, site.nom, site.ville, site.id_ville, site.adresse, site.departement, site.latitude, site.longitude, plan, site.code_postal, departement.prix_boost_max, membre.nom as nom_membre, membre.cb_actif, membre.taux_annulation, membre.types_paiement ,(6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) AS dist FROM stage, membre, departement, site WHERE membre.id <> 793 AND id_site = site.id AND site.departement = departement.code_departement AND date1 > '2026-07-07' AND nb_places_allouees > 0 AND annule = 0 AND stage.is_online = 1 AND stage.visible = 1 AND stage.id_membre = membre.id AND site.id_membre = membre.id AND (((6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) <= 60) OR (latitude='49.5008363' AND longitude='5.7841998')) ORDER BY date1 ASC, prix ASC LIMIT 100

DEBUG2: SELECT date1, date2, boost_actif, nb_places_allouees, nb_boost_allouees, nb_boost, nb_inscrits, nb_preinscrits, prix, prix_avant_premium, prix_barre, prix_privilege, prix_concurrence, stage.reduction, stage.reduction_pap, stage.id, stage.id_externe, stage.id_membre, stage.pass_sanitaire, stage.boost_stage, option_visibilite, option_visibilite_new, annule, motCle, site.nom, site.ville, site.id_ville, site.adresse, site.departement, site.latitude, site.longitude, plan, site.code_postal, departement.prix_boost_max, membre.nom as nom_membre, membre.cb_actif, membre.taux_annulation, membre.types_paiement ,(6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) AS dist FROM stage, membre, departement, site WHERE membre.id <> 793 AND id_site = site.id AND site.departement = departement.code_departement AND date1 > '2026-07-07' AND nb_places_allouees > 0 AND annule = 0 AND stage.is_online = 1 AND stage.visible = 1 AND stage.id_membre = membre.id AND site.id_membre = membre.id AND (((6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) <= 80) OR (latitude='49.5008363' AND longitude='5.7841998')) ORDER BY date1 ASC, prix ASC LIMIT 100

DEBUG2: SELECT date1, date2, boost_actif, nb_places_allouees, nb_boost_allouees, nb_boost, nb_inscrits, nb_preinscrits, prix, prix_avant_premium, prix_barre, prix_privilege, prix_concurrence, stage.reduction, stage.reduction_pap, stage.id, stage.id_externe, stage.id_membre, stage.pass_sanitaire, stage.boost_stage, option_visibilite, option_visibilite_new, annule, motCle, site.nom, site.ville, site.id_ville, site.adresse, site.departement, site.latitude, site.longitude, plan, site.code_postal, departement.prix_boost_max, membre.nom as nom_membre, membre.cb_actif, membre.taux_annulation, membre.types_paiement ,(6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) AS dist FROM stage, membre, departement, site WHERE membre.id <> 793 AND id_site = site.id AND site.departement = departement.code_departement AND date1 > '2026-07-07' AND nb_places_allouees > 0 AND annule = 0 AND stage.is_online = 1 AND stage.visible = 1 AND stage.id_membre = membre.id AND site.id_membre = membre.id AND (((6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) <= 100) OR (latitude='49.5008363' AND longitude='5.7841998')) ORDER BY date1 ASC, prix ASC LIMIT 100

DEBUG2: SELECT date1, date2, boost_actif, nb_places_allouees, nb_boost_allouees, nb_boost, nb_inscrits, nb_preinscrits, prix, prix_avant_premium, prix_barre, prix_privilege, prix_concurrence, stage.reduction, stage.reduction_pap, stage.id, stage.id_externe, stage.id_membre, stage.pass_sanitaire, stage.boost_stage, option_visibilite, option_visibilite_new, annule, motCle, site.nom, site.ville, site.id_ville, site.adresse, site.departement, site.latitude, site.longitude, plan, site.code_postal, departement.prix_boost_max, membre.nom as nom_membre, membre.cb_actif, membre.taux_annulation, membre.types_paiement ,(6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) AS dist FROM stage, membre, departement, site WHERE membre.id <> 793 AND id_site = site.id AND site.departement = departement.code_departement AND date1 > '2026-07-07' AND nb_places_allouees > 0 AND annule = 0 AND stage.is_online = 1 AND stage.visible = 1 AND stage.id_membre = membre.id AND site.id_membre = membre.id AND (((6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) <= 120) OR (latitude='49.5008363' AND longitude='5.7841998')) AND stage.id NOT IN (330315,330320,330322,330584,328947,328946) ORDER BY date1 ASC, prix ASC LIMIT 40

DEBUG2: SELECT date1, date2, boost_actif, nb_places_allouees, nb_boost_allouees, nb_boost, nb_inscrits, nb_preinscrits, prix, prix_avant_premium, prix_barre, prix_privilege, prix_concurrence, stage.reduction, stage.reduction_pap, stage.id, stage.id_externe, stage.id_membre, stage.pass_sanitaire, stage.boost_stage, option_visibilite, option_visibilite_new, annule, motCle, site.nom, site.ville, site.id_ville, site.adresse, site.departement, site.latitude, site.longitude, plan, site.code_postal, departement.prix_boost_max, membre.nom as nom_membre, membre.cb_actif, membre.taux_annulation, membre.types_paiement ,(6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) AS dist FROM stage, membre, departement, site WHERE membre.id <> 793 AND id_site = site.id AND site.departement = departement.code_departement AND date1 > '2026-07-07' AND nb_places_allouees > 0 AND annule = 0 AND stage.is_online = 1 AND stage.visible = 1 AND stage.id_membre = membre.id AND site.id_membre = membre.id AND (((6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) <= 140) OR (latitude='49.5008363' AND longitude='5.7841998')) AND stage.id NOT IN (330315,330320,330322,330584,328947,328946) ORDER BY date1 ASC, prix ASC LIMIT 40

DEBUG2: SELECT date1, date2, boost_actif, nb_places_allouees, nb_boost_allouees, nb_boost, nb_inscrits, nb_preinscrits, prix, prix_avant_premium, prix_barre, prix_privilege, prix_concurrence, stage.reduction, stage.reduction_pap, stage.id, stage.id_externe, stage.id_membre, stage.pass_sanitaire, stage.boost_stage, option_visibilite, option_visibilite_new, annule, motCle, site.nom, site.ville, site.id_ville, site.adresse, site.departement, site.latitude, site.longitude, plan, site.code_postal, departement.prix_boost_max, membre.nom as nom_membre, membre.cb_actif, membre.taux_annulation, membre.types_paiement ,(6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) AS dist FROM stage, membre, departement, site WHERE membre.id <> 793 AND id_site = site.id AND site.departement = departement.code_departement AND date1 > '2026-07-07' AND nb_places_allouees > 0 AND annule = 0 AND stage.is_online = 1 AND stage.visible = 1 AND stage.id_membre = membre.id AND site.id_membre = membre.id AND (((6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) <= 160) OR (latitude='49.5008363' AND longitude='5.7841998')) AND stage.id NOT IN (330315,330320,330322,330584,328947,328946) ORDER BY date1 ASC, prix ASC LIMIT 40

DEBUG2: SELECT date1, date2, boost_actif, nb_places_allouees, nb_boost_allouees, nb_boost, nb_inscrits, nb_preinscrits, prix, prix_avant_premium, prix_barre, prix_privilege, prix_concurrence, stage.reduction, stage.reduction_pap, stage.id, stage.id_externe, stage.id_membre, stage.pass_sanitaire, stage.boost_stage, option_visibilite, option_visibilite_new, annule, motCle, site.nom, site.ville, site.id_ville, site.adresse, site.departement, site.latitude, site.longitude, plan, site.code_postal, departement.prix_boost_max, membre.nom as nom_membre, membre.cb_actif, membre.taux_annulation, membre.types_paiement ,(6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) AS dist FROM stage, membre, departement, site WHERE membre.id <> 793 AND id_site = site.id AND site.departement = departement.code_departement AND date1 > '2026-07-07' AND nb_places_allouees > 0 AND annule = 0 AND stage.is_online = 1 AND stage.visible = 1 AND stage.id_membre = membre.id AND site.id_membre = membre.id AND (((6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) <= 180) OR (latitude='49.5008363' AND longitude='5.7841998')) AND stage.id NOT IN (330315,330320,330322,330584,328947,328946) ORDER BY date1 ASC, prix ASC LIMIT 40

DEBUG2: SELECT date1, date2, boost_actif, nb_places_allouees, nb_boost_allouees, nb_boost, nb_inscrits, nb_preinscrits, prix, prix_avant_premium, prix_barre, prix_privilege, prix_concurrence, stage.reduction, stage.reduction_pap, stage.id, stage.id_externe, stage.id_membre, stage.pass_sanitaire, stage.boost_stage, option_visibilite, option_visibilite_new, annule, motCle, site.nom, site.ville, site.id_ville, site.adresse, site.departement, site.latitude, site.longitude, plan, site.code_postal, departement.prix_boost_max, membre.nom as nom_membre, membre.cb_actif, membre.taux_annulation, membre.types_paiement ,(6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) AS dist FROM stage, membre, departement, site WHERE membre.id <> 793 AND id_site = site.id AND site.departement = departement.code_departement AND date1 > '2026-07-07' AND nb_places_allouees > 0 AND annule = 0 AND stage.is_online = 1 AND stage.visible = 1 AND stage.id_membre = membre.id AND site.id_membre = membre.id AND (((6366*acos(cos(radians(49.5008363))*cos(radians(`latitude`))*cos(radians(`longitude`) - radians(5.7841998))+sin(radians(49.5008363))*sin(radians(`latitude`)))) <= 200) OR (latitude='49.5008363' AND longitude='5.7841998')) AND stage.id NOT IN (330315,330320,330322,330584,328947,328946) ORDER BY date1 ASC, prix ASC LIMIT 40