Indiquer un code postal ou une ville

Flèche vers le champ lieu

Location vélo à 93160 Noisy-le-grand


Retour
Fermer

Location › Materiel sport

Lancez votre recherche pour voir les annonces.

Location vélo : 2 vélo vélos à louer entre particuliers à 93160 Noisy-le-grand Pour aller au travail, visiter une ville ou faire des balades en forêts, le vélo est le moyen de transport le plus prisé. La location de velo entre particuliers, c'est pas cher et écologique ! Vous pouvez choisir et louer un vélo électrique ou louer un vélo simple selon votre usage. La location de vélo entre particuliers est possible pour une journée ou plusieurs semaines. Trouvez en location un velo électrique, un velo sportif (velo gravel, velo vtt, velo vtc, un velo de ville (velo tandem), tricycle et même louer un velo enfant.
 ... voir la suite
<
1
2
3
>>
Demander à louer un velo ou proposer un velo en location entre particuliers.
Poster une annonce

   Vtt    Vtc    Velo electrique    Velo enfant    Gravel    Velo femme    Velo homme    Velo de route    Velo cargo    Remorque velo
Trouver

Trouver
Demandes des voisins

Demandes

 créer une annonce
Messagerie

Messages

 Mon profil

Profil

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wall.php

  1. 0.0002

    SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='materiel-sportif'

  2. 0.0001

    SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=95

  3. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='93'

  4. 0.0001

    SELECT ville_nom FROM villes WHERE ville_cp='93160' AND ville_nom like '%noisy%le%grand%' ORDER BY ville_population_2012 DESC LIMIT 0,1

  5. 0.0015

    SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%velos%' OR ssrubr_title like '%velos%' OR ssrubr_slug like '%velos%') AND cate_id='95' ORDER BY ssrubr_id LIMIT 0,1

  6. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='93160'

  7. 0.0021

    SELECT ville_cp, ROUND((((acos(sin((48.85*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.85*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.56667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.670135678816 AND ville_latitude_deg<49.029864321184 AND ville_longitude_deg>2.2933330625247 AND ville_longitude_deg<2.8400069374753 HAVING distance <= 20 ORDER BY distance ASC

  8. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='velos'

  9. 0.0006

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='95'AND MATCH (wish_title,wish_desc) AGAINST ('+velos*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '93160%'

  10. 0.0001

    SELECT * FROM texte WHERE cate_id=95

  11. 0.0003

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='velos' OR ssrubr_slug='velos' OR (ssrubr_title like '%velos%')) AND cate_id='95' ORDER BY ssrubr_id LIMIT 0,1

  12. 0.0001

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  13. 0.0001

    SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC

  14. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (95) ORDER BY ssrubr_order ASC

  15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='velos' AND cate_id='95'

  16. 0.0001

    SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='93160'

  17. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.85*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.85*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.56667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.670135678816 AND ville_latitude_deg<49.029864321184 AND ville_longitude_deg>2.2933330625247 AND ville_longitude_deg<2.8400069374753 HAVING distance <= 20 ORDER BY distance ASC

  18. 0.0053

    SELECT ville_cp, ROUND((((acos(sin((48.85*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.85*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.56667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.400339197041 AND ville_latitude_deg<49.299660802959 AND ville_longitude_deg>1.8833217637462 AND ville_longitude_deg<3.2500182362538 HAVING distance <= 50 ORDER BY distance ASC

  19. 0.0351

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='95' AND MATCH (wish_desc) AGAINST ('(+velos*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (93160,93160,93460,94350,77420,93330,94420,77185,94360,93360,77500,93220,77186,94170,94500,77184,93370,77200,94120,77177,93250,77360,93110,94130,77340,93340,93320,94430,94340,94210,94100,93470,94880,93190,94490,94880,94510,77181,93390,77090,77183,93130,94340,77680,77181,77600,77400,94410,93140,93410,77400,94380,94370,93270,77410,77600,94300,77600,77400,93100,77270,93000,94000,93260,93230,77164,94380,77600,77400,93170,94160,77135,94700,77400,94220,93600,94470,77330,93290,77400,94140,93150,93700,77600,93310,77400,94440,93420,77410,94460,93500,77150,77600,77144,77150,94205,94200,94400,94450,93350,94600,77410,94440,77170,77410,94440,77144,77700,94270,77290,77410,93120,93300,94190,91330,93440,94800,77700,77410,95500,75010,75009,75011,75020,75003,75008,75012,75001,75006,75004,75000,75002,75005,75017,75013,75019,75007,75014,75015,75016,75116,75018,94320,77450,94310,94390,77173,94520,94520,77450,95140,94290,95700,95500,91560,91800,93240,77174,94250,77410,95500,77220,93200,93210,77700,93400,94110,77290,95500,77410,77220,94550,77700,77700,95400,94480,94233,94239,94231,94232,94237,94230,94236,94234,94240,94235,94238,92120,77990,91800,91230,77170,91860,77450,91480,91200,77230,77410,94150,92390,93450,77410,93380,77220,92170,77450,77174,92240,77230,95190,77166,91270,77220)

  20. 0.0386

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.85*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.85*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.56667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='95' AND MATCH (wish_desc) AGAINST ('(+velos*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (93160,93160,93460,94350,77420,93330,94420,77185,94360,93360,77500,93220,77186,94170,94500,77184,93370,77200,94120,77177,93250,77360,93110,94130,77340,93340,93320,94430,94340,94210,94100,93470,94880,93190,94490,94880,94510,77181,93390,77090,77183,93130,94340,77680,77181,77600,77400,94410,93140,93410,77400,94380,94370,93270,77410,77600,94300,77600,77400,93100,77270,93000,94000,93260,93230,77164,94380,77600,77400,93170,94160,77135,94700,77400,94220,93600,94470,77330,93290,77400,94140,93150,93700,77600,93310,77400,94440,93420,77410,94460,93500,77150,77600,77144,77150,94205,94200,94400,94450,93350,94600,77410,94440,77170,77410,94440,77144,77700,94270,77290,77410,93120,93300,94190,91330,93440,94800,77700,77410,95500,75010,75009,75011,75020,75003,75008,75012,75001,75006,75004,75000,75002,75005,75017,75013,75019,75007,75014,75015,75016,75116,75018,94320,77450,94310,94390,77173,94520,94520,77450,95140,94290,95700,95500,91560,91800,93240,77174,94250,77410,95500,77220,93200,93210,77700,93400,94110,77290,95500,77410,77220,94550,77700,77700,95400,94480,94233,94239,94231,94232,94237,94230,94236,94234,94240,94235,94238,92120,77990,91800,91230,77170,91860,77450,91480,91200,77230,77410,94150,92390,93450,77410,93380,77220,92170,77450,77174,92240,77230,95190,77166,91270,77220) AND type_id=1 GROUP BY wish_id

  21. 0.0001

    SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='93160'

  22. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.85*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.85*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.56667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.670135678816 AND ville_latitude_deg<49.029864321184 AND ville_longitude_deg>2.2933330625247 AND ville_longitude_deg<2.8400069374753 HAVING distance <= 20 ORDER BY distance ASC

  23. 0.0055

    SELECT ville_cp, ROUND((((acos(sin((48.85*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.85*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.56667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.400339197041 AND ville_latitude_deg<49.299660802959 AND ville_longitude_deg>1.8833217637462 AND ville_longitude_deg<3.2500182362538 HAVING distance <= 50 ORDER BY distance ASC

  24. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 15931 AND W.type_id = 1) OR (W.util_id != 15931 AND W.type_id = 2)) AND (`post_util_id` = 15931 OR `dest_util_id` = 15931) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  25. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=15931 AND note_visu IN (1,3,4)

  26. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 54246 AND W.type_id = 1) OR (W.util_id != 54246 AND W.type_id = 2)) AND (`post_util_id` = 54246 OR `dest_util_id` = 54246) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  27. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=54246 AND note_visu IN (1,3,4)

  28. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 61058 AND W.type_id = 1) OR (W.util_id != 61058 AND W.type_id = 2)) AND (`post_util_id` = 61058 OR `dest_util_id` = 61058) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  29. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=61058 AND note_visu IN (1,3,4)

  30. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 61819 AND W.type_id = 1) OR (W.util_id != 61819 AND W.type_id = 2)) AND (`post_util_id` = 61819 OR `dest_util_id` = 61819) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  31. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=61819 AND note_visu IN (1,3,4)

  32. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 7368 AND W.type_id = 1) OR (W.util_id != 7368 AND W.type_id = 2)) AND (`post_util_id` = 7368 OR `dest_util_id` = 7368) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  33. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=7368 AND note_visu IN (1,3,4)

  34. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 74385 AND W.type_id = 1) OR (W.util_id != 74385 AND W.type_id = 2)) AND (`post_util_id` = 74385 OR `dest_util_id` = 74385) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  35. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=74385 AND note_visu IN (1,3,4)

  36. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 88476 AND W.type_id = 1) OR (W.util_id != 88476 AND W.type_id = 2)) AND (`post_util_id` = 88476 OR `dest_util_id` = 88476) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  37. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=88476 AND note_visu IN (1,3,4)

  38. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 89710 AND W.type_id = 1) OR (W.util_id != 89710 AND W.type_id = 2)) AND (`post_util_id` = 89710 OR `dest_util_id` = 89710) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  39. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=89710 AND note_visu IN (1,3,4)

  40. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 104876 AND W.type_id = 1) OR (W.util_id != 104876 AND W.type_id = 2)) AND (`post_util_id` = 104876 OR `dest_util_id` = 104876) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  41. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=104876 AND note_visu IN (1,3,4)

  42. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 134358 AND W.type_id = 1) OR (W.util_id != 134358 AND W.type_id = 2)) AND (`post_util_id` = 134358 OR `dest_util_id` = 134358) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  43. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=134358 AND note_visu IN (1,3,4)

  44. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 159329 AND W.type_id = 1) OR (W.util_id != 159329 AND W.type_id = 2)) AND (`post_util_id` = 159329 OR `dest_util_id` = 159329) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  45. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=159329 AND note_visu IN (1,3,4)

  46. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 10531 AND W.type_id = 1) OR (W.util_id != 10531 AND W.type_id = 2)) AND (`post_util_id` = 10531 OR `dest_util_id` = 10531) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  47. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=10531 AND note_visu IN (1,3,4)

  48. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 175595 AND W.type_id = 1) OR (W.util_id != 175595 AND W.type_id = 2)) AND (`post_util_id` = 175595 OR `dest_util_id` = 175595) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  49. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=175595 AND note_visu IN (1,3,4)

  50. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 175755 AND W.type_id = 1) OR (W.util_id != 175755 AND W.type_id = 2)) AND (`post_util_id` = 175755 OR `dest_util_id` = 175755) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  51. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=175755 AND note_visu IN (1,3,4)

  52. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 181056 AND W.type_id = 1) OR (W.util_id != 181056 AND W.type_id = 2)) AND (`post_util_id` = 181056 OR `dest_util_id` = 181056) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  53. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=181056 AND note_visu IN (1,3,4)

  54. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 186130 AND W.type_id = 1) OR (W.util_id != 186130 AND W.type_id = 2)) AND (`post_util_id` = 186130 OR `dest_util_id` = 186130) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  55. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=186130 AND note_visu IN (1,3,4)

  56. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 176421 AND W.type_id = 1) OR (W.util_id != 176421 AND W.type_id = 2)) AND (`post_util_id` = 176421 OR `dest_util_id` = 176421) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  57. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=176421 AND note_visu IN (1,3,4)

  58. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 193572 AND W.type_id = 1) OR (W.util_id != 193572 AND W.type_id = 2)) AND (`post_util_id` = 193572 OR `dest_util_id` = 193572) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  59. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=193572 AND note_visu IN (1,3,4)

  60. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 211210 AND W.type_id = 1) OR (W.util_id != 211210 AND W.type_id = 2)) AND (`post_util_id` = 211210 OR `dest_util_id` = 211210) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  61. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=211210 AND note_visu IN (1,3,4)

  62. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 217772 AND W.type_id = 1) OR (W.util_id != 217772 AND W.type_id = 2)) AND (`post_util_id` = 217772 OR `dest_util_id` = 217772) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  63. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=217772 AND note_visu IN (1,3,4)

  64. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 226024 AND W.type_id = 1) OR (W.util_id != 226024 AND W.type_id = 2)) AND (`post_util_id` = 226024 OR `dest_util_id` = 226024) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  65. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=226024 AND note_visu IN (1,3,4)

  66. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 228912 AND W.type_id = 1) OR (W.util_id != 228912 AND W.type_id = 2)) AND (`post_util_id` = 228912 OR `dest_util_id` = 228912) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  67. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=228912 AND note_visu IN (1,3,4)

  68. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 241461 AND W.type_id = 1) OR (W.util_id != 241461 AND W.type_id = 2)) AND (`post_util_id` = 241461 OR `dest_util_id` = 241461) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  69. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=241461 AND note_visu IN (1,3,4)

  70. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 243751 AND W.type_id = 1) OR (W.util_id != 243751 AND W.type_id = 2)) AND (`post_util_id` = 243751 OR `dest_util_id` = 243751) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  71. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=243751 AND note_visu IN (1,3,4)

  72. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 241461 AND W.type_id = 1) OR (W.util_id != 241461 AND W.type_id = 2)) AND (`post_util_id` = 241461 OR `dest_util_id` = 241461) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  73. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 257395 AND W.type_id = 1) OR (W.util_id != 257395 AND W.type_id = 2)) AND (`post_util_id` = 257395 OR `dest_util_id` = 257395) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  74. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=257395 AND note_visu IN (1,3,4)

  75. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 56859 AND W.type_id = 1) OR (W.util_id != 56859 AND W.type_id = 2)) AND (`post_util_id` = 56859 OR `dest_util_id` = 56859) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  76. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=56859 AND note_visu IN (1,3,4)

  77. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 282456 AND W.type_id = 1) OR (W.util_id != 282456 AND W.type_id = 2)) AND (`post_util_id` = 282456 OR `dest_util_id` = 282456) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  78. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=282456 AND note_visu IN (1,3,4)

  79. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 284669 AND W.type_id = 1) OR (W.util_id != 284669 AND W.type_id = 2)) AND (`post_util_id` = 284669 OR `dest_util_id` = 284669) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  80. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=284669 AND note_visu IN (1,3,4)

  81. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 284669 AND W.type_id = 1) OR (W.util_id != 284669 AND W.type_id = 2)) AND (`post_util_id` = 284669 OR `dest_util_id` = 284669) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  82. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 284669 AND W.type_id = 1) OR (W.util_id != 284669 AND W.type_id = 2)) AND (`post_util_id` = 284669 OR `dest_util_id` = 284669) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  83. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 288808 AND W.type_id = 1) OR (W.util_id != 288808 AND W.type_id = 2)) AND (`post_util_id` = 288808 OR `dest_util_id` = 288808) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  84. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=288808 AND note_visu IN (1,3,4)

  85. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 262908 AND W.type_id = 1) OR (W.util_id != 262908 AND W.type_id = 2)) AND (`post_util_id` = 262908 OR `dest_util_id` = 262908) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  86. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=262908 AND note_visu IN (1,3,4)

  87. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 299138 AND W.type_id = 1) OR (W.util_id != 299138 AND W.type_id = 2)) AND (`post_util_id` = 299138 OR `dest_util_id` = 299138) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  88. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=299138 AND note_visu IN (1,3,4)

  89. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 299138 AND W.type_id = 1) OR (W.util_id != 299138 AND W.type_id = 2)) AND (`post_util_id` = 299138 OR `dest_util_id` = 299138) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  90. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 306614 AND W.type_id = 1) OR (W.util_id != 306614 AND W.type_id = 2)) AND (`post_util_id` = 306614 OR `dest_util_id` = 306614) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  91. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=306614 AND note_visu IN (1,3,4)

  92. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 306993 AND W.type_id = 1) OR (W.util_id != 306993 AND W.type_id = 2)) AND (`post_util_id` = 306993 OR `dest_util_id` = 306993) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  93. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=306993 AND note_visu IN (1,3,4)

  94. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 309277 AND W.type_id = 1) OR (W.util_id != 309277 AND W.type_id = 2)) AND (`post_util_id` = 309277 OR `dest_util_id` = 309277) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  95. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=309277 AND note_visu IN (1,3,4)

  96. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 118634 AND W.type_id = 1) OR (W.util_id != 118634 AND W.type_id = 2)) AND (`post_util_id` = 118634 OR `dest_util_id` = 118634) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  97. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=118634 AND note_visu IN (1,3,4)

  98. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 309911 AND W.type_id = 1) OR (W.util_id != 309911 AND W.type_id = 2)) AND (`post_util_id` = 309911 OR `dest_util_id` = 309911) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  99. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=309911 AND note_visu IN (1,3,4)

  100. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 313233 AND W.type_id = 1) OR (W.util_id != 313233 AND W.type_id = 2)) AND (`post_util_id` = 313233 OR `dest_util_id` = 313233) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  101. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=313233 AND note_visu IN (1,3,4)

  102. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 315470 AND W.type_id = 1) OR (W.util_id != 315470 AND W.type_id = 2)) AND (`post_util_id` = 315470 OR `dest_util_id` = 315470) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  103. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=315470 AND note_visu IN (1,3,4)

  104. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 316300 AND W.type_id = 1) OR (W.util_id != 316300 AND W.type_id = 2)) AND (`post_util_id` = 316300 OR `dest_util_id` = 316300) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  105. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=316300 AND note_visu IN (1,3,4)

  106. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 322816 AND W.type_id = 1) OR (W.util_id != 322816 AND W.type_id = 2)) AND (`post_util_id` = 322816 OR `dest_util_id` = 322816) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  107. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=322816 AND note_visu IN (1,3,4)

  108. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 324085 AND W.type_id = 1) OR (W.util_id != 324085 AND W.type_id = 2)) AND (`post_util_id` = 324085 OR `dest_util_id` = 324085) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  109. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=324085 AND note_visu IN (1,3,4)

  110. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 326795 AND W.type_id = 1) OR (W.util_id != 326795 AND W.type_id = 2)) AND (`post_util_id` = 326795 OR `dest_util_id` = 326795) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  111. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=326795 AND note_visu IN (1,3,4)

  112. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 326795 AND W.type_id = 1) OR (W.util_id != 326795 AND W.type_id = 2)) AND (`post_util_id` = 326795 OR `dest_util_id` = 326795) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  113. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 326795 AND W.type_id = 1) OR (W.util_id != 326795 AND W.type_id = 2)) AND (`post_util_id` = 326795 OR `dest_util_id` = 326795) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  114. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 339823 AND W.type_id = 1) OR (W.util_id != 339823 AND W.type_id = 2)) AND (`post_util_id` = 339823 OR `dest_util_id` = 339823) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  115. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=339823 AND note_visu IN (1,3,4)

  116. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 346683 AND W.type_id = 1) OR (W.util_id != 346683 AND W.type_id = 2)) AND (`post_util_id` = 346683 OR `dest_util_id` = 346683) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  117. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=346683 AND note_visu IN (1,3,4)

  118. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 336495 AND W.type_id = 1) OR (W.util_id != 336495 AND W.type_id = 2)) AND (`post_util_id` = 336495 OR `dest_util_id` = 336495) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  119. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=336495 AND note_visu IN (1,3,4)

  120. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 357715 AND W.type_id = 1) OR (W.util_id != 357715 AND W.type_id = 2)) AND (`post_util_id` = 357715 OR `dest_util_id` = 357715) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  121. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=357715 AND note_visu IN (1,3,4)

  122. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 356653 AND W.type_id = 1) OR (W.util_id != 356653 AND W.type_id = 2)) AND (`post_util_id` = 356653 OR `dest_util_id` = 356653) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  123. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=356653 AND note_visu IN (1,3,4)

  124. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 359855 AND W.type_id = 1) OR (W.util_id != 359855 AND W.type_id = 2)) AND (`post_util_id` = 359855 OR `dest_util_id` = 359855) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  125. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=359855 AND note_visu IN (1,3,4)

  126. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 371481 AND W.type_id = 1) OR (W.util_id != 371481 AND W.type_id = 2)) AND (`post_util_id` = 371481 OR `dest_util_id` = 371481) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  127. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=371481 AND note_visu IN (1,3,4)

  128. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 377797 AND W.type_id = 1) OR (W.util_id != 377797 AND W.type_id = 2)) AND (`post_util_id` = 377797 OR `dest_util_id` = 377797) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  129. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=377797 AND note_visu IN (1,3,4)

  130. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 380808 AND W.type_id = 1) OR (W.util_id != 380808 AND W.type_id = 2)) AND (`post_util_id` = 380808 OR `dest_util_id` = 380808) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  131. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=380808 AND note_visu IN (1,3,4)

  132. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 383999 AND W.type_id = 1) OR (W.util_id != 383999 AND W.type_id = 2)) AND (`post_util_id` = 383999 OR `dest_util_id` = 383999) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  133. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=383999 AND note_visu IN (1,3,4)

  134. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 396639 AND W.type_id = 1) OR (W.util_id != 396639 AND W.type_id = 2)) AND (`post_util_id` = 396639 OR `dest_util_id` = 396639) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  135. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=396639 AND note_visu IN (1,3,4)

  136. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 397250 AND W.type_id = 1) OR (W.util_id != 397250 AND W.type_id = 2)) AND (`post_util_id` = 397250 OR `dest_util_id` = 397250) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  137. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=397250 AND note_visu IN (1,3,4)

  138. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 389173 AND W.type_id = 1) OR (W.util_id != 389173 AND W.type_id = 2)) AND (`post_util_id` = 389173 OR `dest_util_id` = 389173) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  139. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=389173 AND note_visu IN (1,3,4)

  140. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 298354 AND W.type_id = 1) OR (W.util_id != 298354 AND W.type_id = 2)) AND (`post_util_id` = 298354 OR `dest_util_id` = 298354) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  141. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=298354 AND note_visu IN (1,3,4)

  142. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 328769 AND W.type_id = 1) OR (W.util_id != 328769 AND W.type_id = 2)) AND (`post_util_id` = 328769 OR `dest_util_id` = 328769) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  143. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=328769 AND note_visu IN (1,3,4)

  144. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 421500 AND W.type_id = 1) OR (W.util_id != 421500 AND W.type_id = 2)) AND (`post_util_id` = 421500 OR `dest_util_id` = 421500) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  145. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=421500 AND note_visu IN (1,3,4)

  146. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 349998 AND W.type_id = 1) OR (W.util_id != 349998 AND W.type_id = 2)) AND (`post_util_id` = 349998 OR `dest_util_id` = 349998) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  147. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=349998 AND note_visu IN (1,3,4)

  148. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 454156 AND W.type_id = 1) OR (W.util_id != 454156 AND W.type_id = 2)) AND (`post_util_id` = 454156 OR `dest_util_id` = 454156) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  149. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=454156 AND note_visu IN (1,3,4)

  150. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 459696 AND W.type_id = 1) OR (W.util_id != 459696 AND W.type_id = 2)) AND (`post_util_id` = 459696 OR `dest_util_id` = 459696) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  151. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=459696 AND note_visu IN (1,3,4)

  152. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 468160 AND W.type_id = 1) OR (W.util_id != 468160 AND W.type_id = 2)) AND (`post_util_id` = 468160 OR `dest_util_id` = 468160) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  153. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=468160 AND note_visu IN (1,3,4)

  154. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 471749 AND W.type_id = 1) OR (W.util_id != 471749 AND W.type_id = 2)) AND (`post_util_id` = 471749 OR `dest_util_id` = 471749) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  155. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=471749 AND note_visu IN (1,3,4)

  156. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 475055 AND W.type_id = 1) OR (W.util_id != 475055 AND W.type_id = 2)) AND (`post_util_id` = 475055 OR `dest_util_id` = 475055) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  157. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=475055 AND note_visu IN (1,3,4)

  158. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 484273 AND W.type_id = 1) OR (W.util_id != 484273 AND W.type_id = 2)) AND (`post_util_id` = 484273 OR `dest_util_id` = 484273) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  159. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=484273 AND note_visu IN (1,3,4)

  160. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 513578 AND W.type_id = 1) OR (W.util_id != 513578 AND W.type_id = 2)) AND (`post_util_id` = 513578 OR `dest_util_id` = 513578) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  161. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=513578 AND note_visu IN (1,3,4)

  162. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 516557 AND W.type_id = 1) OR (W.util_id != 516557 AND W.type_id = 2)) AND (`post_util_id` = 516557 OR `dest_util_id` = 516557) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  163. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=516557 AND note_visu IN (1,3,4)

  164. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 528427 AND W.type_id = 1) OR (W.util_id != 528427 AND W.type_id = 2)) AND (`post_util_id` = 528427 OR `dest_util_id` = 528427) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  165. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=528427 AND note_visu IN (1,3,4)

  166. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 530486 AND W.type_id = 1) OR (W.util_id != 530486 AND W.type_id = 2)) AND (`post_util_id` = 530486 OR `dest_util_id` = 530486) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  167. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=530486 AND note_visu IN (1,3,4)

  168. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 260718 AND W.type_id = 1) OR (W.util_id != 260718 AND W.type_id = 2)) AND (`post_util_id` = 260718 OR `dest_util_id` = 260718) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  169. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=260718 AND note_visu IN (1,3,4)

  170. 0.0003

    SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND ss.cate_id=95 AND ss.fami_id=5 ORDER BY ssrubr_order LIMIT 6,100

  171. 0.0002

    SELECT ss.fami_id, fami_url, ss.cate_id, cate_title_slug, keywords_title FROM `ssrubr_keywords` sk, ssrubr ss, category c, family f WHERE sk.ssrubr_id=ss.ssrubr_id AND ss.cate_id=c.cate_id AND c.fami_id=f.fami_id AND (ssrubr_slug='velos' OR ssrubr_slug like '%velos%' OR MATCH (ssrubr_slug) AGAINST ('(+velos)')) AND sk.ssrubr_id='788' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

  172. 0.0001

    SELECT * FROM actu WHERE ssrubr_id='788' AND actu_niveau=0 ORDER BY actu_ordre DESC

  173. 0.0009

    SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7

  174. 0

    SELECT count(*) as nbwish FROM wish

  175. 0.0472

    SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC

175 requetes sql en 0.1574

Taille variable Globale : 107.33 KB