Indiquer un code postal ou une ville

Flèche vers le champ lieu

Location vélo à 75020 Paris


Retour
Fermer

Location › Materiel sport

Lancez votre recherche pour voir les annonces.

Location vélo : 11 vélo vélos à louer entre particuliers à 75020 Paris 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
4
>>
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.0001

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

  2. 0

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

  3. 0

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='75'

  4. 0.0001

    SELECT ville_nom FROM villes WHERE ville_cp='75020' AND ville_nom like '%paris%' ORDER BY ville_population_2012 DESC LIMIT 0,1

  5. 0.0016

    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='75020'

  7. 0.0021

    SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.680135678816 AND ville_latitude_deg<49.039864321184 AND ville_longitude_deg>2.0710584569437 AND ville_longitude_deg<2.6178415430563 HAVING distance <= 20 ORDER BY distance ASC

  8. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='velos'

  9. 0.0008

    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 '75020%'

  10. 0.0001

    SELECT * FROM texte WHERE cate_id=95

  11. 0.0002

    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

    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

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

  17. 0.0006

    SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.797047487586 AND ville_latitude_deg<48.922952512414 AND ville_longitude_deg>2.2487630978401 AND ville_longitude_deg<2.4401369021599 HAVING distance <= 7 ORDER BY distance ASC

  18. 0.0055

    SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.410339197041 AND ville_latitude_deg<49.309660802959 AND ville_longitude_deg>1.6609652486165 AND ville_longitude_deg<3.0279347513835 HAVING distance <= 50 ORDER BY distance ASC

  19. 0.0408

    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 (75020,75007,75002,75000,75001,75017,75006,75116,75020,75018,75015,75019,75003,75004,75014,75013,75012,75011,75010,75009,75008,75016,75005,92170,93400,93310,94250,94270,92120,93170,92110,94205,94200,92240,93500,94160,92200,92300,93100,94300,94110,94800,93120,93300,93230,93260,92600,94220,92220,92130,92100,92400,92320,92800,92150,93450,92390,92250,93200,93210,92270,94140,94233,94235,94231,94232,94236,94237,94234,94230,94239,94238,94240,92140,92230,93000,93130,94700,92700,94400,92360,92190,92210,94410,92260,92330,92340,93350,93140,94340,93110,94120,92350,93800,94550,93240,94130,94320,92500,93430,93700,93150,93440,94170,92000,92310,94600,93250,92290,92410,95360,92380,93380,95880,95100,94150,78800,94000,95870,94260,92370,93360,92160,95218,95210,92420,92430,94390,94310,94360,95140,94100,94210,94340,78420,93320,93340,91370,94500,95500,78140,95410,95110,95170,93330,93220,95230,91320,94430,78170,78400,94380,78220,95400,91300,95120,94290,94460,94350,91570,78500,78290,78380,78360,95160,95350,95500,95400,95200,95580,95580,95130,91550,93270,94190,93600,95600,93460,93190,93390,93160,91200,78150,78350,78430,95530,94480,78000,93370,78560,91430,78150,94420,78110,94380,94370,95240,94490,94880,94880,91120,78600,94450,95350,95130,94470,91430,95440,91560,91420,95500,95680,78600,95370,91160,91380,93410,93420,95390,78230,91270,93470,77181,95500,95720,78530,78350,91160,77420,95320,77500,91140,78160,78870,91400,78750,95330,95460,91230,94510,95190,91330,78100,91260,95720)

  20. 0.0404

    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.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- 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 (75020,75007,75002,75000,75001,75017,75006,75116,75020,75018,75015,75019,75003,75004,75014,75013,75012,75011,75010,75009,75008,75016,75005,92170,93400,93310,94250,94270,92120,93170,92110,94205,94200,92240,93500,94160,92200,92300,93100,94300,94110,94800,93120,93300,93230,93260,92600,94220,92220,92130,92100,92400,92320,92800,92150,93450,92390,92250,93200,93210,92270,94140,94233,94235,94231,94232,94236,94237,94234,94230,94239,94238,94240,92140,92230,93000,93130,94700,92700,94400,92360,92190,92210,94410,92260,92330,92340,93350,93140,94340,93110,94120,92350,93800,94550,93240,94130,94320,92500,93430,93700,93150,93440,94170,92000,92310,94600,93250,92290,92410,95360,92380,93380,95880,95100,94150,78800,94000,95870,94260,92370,93360,92160,95218,95210,92420,92430,94390,94310,94360,95140,94100,94210,94340,78420,93320,93340,91370,94500,95500,78140,95410,95110,95170,93330,93220,95230,91320,94430,78170,78400,94380,78220,95400,91300,95120,94290,94460,94350,91570,78500,78290,78380,78360,95160,95350,95500,95400,95200,95580,95580,95130,91550,93270,94190,93600,95600,93460,93190,93390,93160,91200,78150,78350,78430,95530,94480,78000,93370,78560,91430,78150,94420,78110,94380,94370,95240,94490,94880,94880,91120,78600,94450,95350,95130,94470,91430,95440,91560,91420,95500,95680,78600,95370,91160,91380,93410,93420,95390,78230,91270,93470,77181,95500,95720,78530,78350,91160,77420,95320,77500,91140,78160,78870,91400,78750,95330,95460,91230,94510,95190,91330,78100,91260,95720) 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='75020'

  22. 0.0006

    SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.797047487586 AND ville_latitude_deg<48.922952512414 AND ville_longitude_deg>2.2487630978401 AND ville_longitude_deg<2.4401369021599 HAVING distance <= 7 ORDER BY distance ASC

  23. 0.0057

    SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.410339197041 AND ville_latitude_deg<49.309660802959 AND ville_longitude_deg>1.6609652486165 AND ville_longitude_deg<3.0279347513835 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 = 11895 AND W.type_id = 1) OR (W.util_id != 11895 AND W.type_id = 2)) AND (`post_util_id` = 11895 OR `dest_util_id` = 11895) 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=11895 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 = 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

  27. 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)

  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 = 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

  29. 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)

  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 = 54419 AND W.type_id = 1) OR (W.util_id != 54419 AND W.type_id = 2)) AND (`post_util_id` = 54419 OR `dest_util_id` = 54419) 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=54419 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 = 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

  33. 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)

  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 = 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

  35. 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)

  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 = 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

  37. 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)

  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 = 67487 AND W.type_id = 1) OR (W.util_id != 67487 AND W.type_id = 2)) AND (`post_util_id` = 67487 OR `dest_util_id` = 67487) 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=67487 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 = 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

  41. 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)

  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 = 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

  43. 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)

  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 = 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

  45. 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)

  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 = 90168 AND W.type_id = 1) OR (W.util_id != 90168 AND W.type_id = 2)) AND (`post_util_id` = 90168 OR `dest_util_id` = 90168) 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=90168 AND note_visu IN (1,3,4)

  48. 0.0007

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 93477 AND W.type_id = 1) OR (W.util_id != 93477 AND W.type_id = 2)) AND (`post_util_id` = 93477 OR `dest_util_id` = 93477) 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=93477 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 = 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

  51. 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)

  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 = 60419 AND W.type_id = 1) OR (W.util_id != 60419 AND W.type_id = 2)) AND (`post_util_id` = 60419 OR `dest_util_id` = 60419) 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=60419 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 = 128030 AND W.type_id = 1) OR (W.util_id != 128030 AND W.type_id = 2)) AND (`post_util_id` = 128030 OR `dest_util_id` = 128030) 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=128030 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 = 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

  57. 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)

  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 = 149482 AND W.type_id = 1) OR (W.util_id != 149482 AND W.type_id = 2)) AND (`post_util_id` = 149482 OR `dest_util_id` = 149482) 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=149482 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 = 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

  61. 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)

  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 = 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

  63. 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)

  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 = 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

  65. 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)

  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 = 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

  67. 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)

  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 = 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

  69. 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)

  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 = 182915 AND W.type_id = 1) OR (W.util_id != 182915 AND W.type_id = 2)) AND (`post_util_id` = 182915 OR `dest_util_id` = 182915) 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=182915 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 = 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

  73. 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)

  74. 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

  75. 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)

  76. 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

  77. 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)

  78. 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 = 195495 AND W.type_id = 1) OR (W.util_id != 195495 AND W.type_id = 2)) AND (`post_util_id` = 195495 OR `dest_util_id` = 195495) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  79. 0.0001

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

  80. 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

  81. 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)

  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 = 214478 AND W.type_id = 1) OR (W.util_id != 214478 AND W.type_id = 2)) AND (`post_util_id` = 214478 OR `dest_util_id` = 214478) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  83. 0.0001

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

  84. 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

  85. 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)

  86. 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

  87. 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)

  88. 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 = 230510 AND W.type_id = 1) OR (W.util_id != 230510 AND W.type_id = 2)) AND (`post_util_id` = 230510 OR `dest_util_id` = 230510) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  89. 0.0001

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

  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 = 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

  91. 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)

  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 = 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

  93. 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)

  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 = 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

  95. 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 = 259647 AND W.type_id = 1) OR (W.util_id != 259647 AND W.type_id = 2)) AND (`post_util_id` = 259647 OR `dest_util_id` = 259647) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  96. 0.0001

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

  97. 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

  98. 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)

  99. 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 = 259647 AND W.type_id = 1) OR (W.util_id != 259647 AND W.type_id = 2)) AND (`post_util_id` = 259647 OR `dest_util_id` = 259647) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  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 = 279570 AND W.type_id = 1) OR (W.util_id != 279570 AND W.type_id = 2)) AND (`post_util_id` = 279570 OR `dest_util_id` = 279570) 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=279570 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 = 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

  103. 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)

  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 = 283353 AND W.type_id = 1) OR (W.util_id != 283353 AND W.type_id = 2)) AND (`post_util_id` = 283353 OR `dest_util_id` = 283353) 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=283353 AND note_visu IN (1,3,4)

  106. 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

  107. 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)

  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 = 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

  109. 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

  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 = 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

  111. 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)

  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 = 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

  113. 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)

  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 = 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

  115. 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)

  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 = 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

  117. 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 = 304207 AND W.type_id = 1) OR (W.util_id != 304207 AND W.type_id = 2)) AND (`post_util_id` = 304207 OR `dest_util_id` = 304207) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  118. 0.0001

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

  119. 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 = 305635 AND W.type_id = 1) OR (W.util_id != 305635 AND W.type_id = 2)) AND (`post_util_id` = 305635 OR `dest_util_id` = 305635) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  120. 0.0001

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

  121. 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

  122. 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)

  123. 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

  124. 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)

  125. 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 = 308482 AND W.type_id = 1) OR (W.util_id != 308482 AND W.type_id = 2)) AND (`post_util_id` = 308482 OR `dest_util_id` = 308482) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  126. 0.0001

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

  127. 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

  128. 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)

  129. 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

  130. 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)

  131. 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

  132. 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)

  133. 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 = 310713 AND W.type_id = 1) OR (W.util_id != 310713 AND W.type_id = 2)) AND (`post_util_id` = 310713 OR `dest_util_id` = 310713) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  134. 0.0001

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

  135. 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

  136. 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)

  137. 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

  138. 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)

  139. 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 = 320092 AND W.type_id = 1) OR (W.util_id != 320092 AND W.type_id = 2)) AND (`post_util_id` = 320092 OR `dest_util_id` = 320092) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  140. 0.0001

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

  141. 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

  142. 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)

  143. 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

  144. 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)

  145. 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

  146. 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)

  147. 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

  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 = 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

  149. 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 = 276505 AND W.type_id = 1) OR (W.util_id != 276505 AND W.type_id = 2)) AND (`post_util_id` = 276505 OR `dest_util_id` = 276505) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  150. 0.0001

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

  151. 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 = 276505 AND W.type_id = 1) OR (W.util_id != 276505 AND W.type_id = 2)) AND (`post_util_id` = 276505 OR `dest_util_id` = 276505) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  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 = 337073 AND W.type_id = 1) OR (W.util_id != 337073 AND W.type_id = 2)) AND (`post_util_id` = 337073 OR `dest_util_id` = 337073) 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=337073 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 = 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

  155. 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)

  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 = 339914 AND W.type_id = 1) OR (W.util_id != 339914 AND W.type_id = 2)) AND (`post_util_id` = 339914 OR `dest_util_id` = 339914) 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=339914 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 = 338356 AND W.type_id = 1) OR (W.util_id != 338356 AND W.type_id = 2)) AND (`post_util_id` = 338356 OR `dest_util_id` = 338356) 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=338356 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 = 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

  161. 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)

  162. 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 = 347908 AND W.type_id = 1) OR (W.util_id != 347908 AND W.type_id = 2)) AND (`post_util_id` = 347908 OR `dest_util_id` = 347908) 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=347908 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 = 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

  165. 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)

  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 = 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

  167. 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)

  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 = 358515 AND W.type_id = 1) OR (W.util_id != 358515 AND W.type_id = 2)) AND (`post_util_id` = 358515 OR `dest_util_id` = 358515) 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=358515 AND note_visu IN (1,3,4)

  170. 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 = 358515 AND W.type_id = 1) OR (W.util_id != 358515 AND W.type_id = 2)) AND (`post_util_id` = 358515 OR `dest_util_id` = 358515) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  171. 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 = 368532 AND W.type_id = 1) OR (W.util_id != 368532 AND W.type_id = 2)) AND (`post_util_id` = 368532 OR `dest_util_id` = 368532) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  172. 0.0001

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

  173. 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

  174. 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)

  175. 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

  176. 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)

  177. 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

  178. 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)

  179. 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

  180. 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)

  181. 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 = 384804 AND W.type_id = 1) OR (W.util_id != 384804 AND W.type_id = 2)) AND (`post_util_id` = 384804 OR `dest_util_id` = 384804) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  182. 0.0001

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

  183. 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

  184. 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)

  185. 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

  186. 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)

  187. 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

  188. 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)

  189. 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

  190. 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)

  191. 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

  192. 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)

  193. 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 = 420057 AND W.type_id = 1) OR (W.util_id != 420057 AND W.type_id = 2)) AND (`post_util_id` = 420057 OR `dest_util_id` = 420057) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  194. 0.0001

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

  195. 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 = 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

  196. 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)

  197. 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 = 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

  198. 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)

  199. 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 = 436961 AND W.type_id = 1) OR (W.util_id != 436961 AND W.type_id = 2)) AND (`post_util_id` = 436961 OR `dest_util_id` = 436961) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  200. 0.0001

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

  201. 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 = 327254 AND W.type_id = 1) OR (W.util_id != 327254 AND W.type_id = 2)) AND (`post_util_id` = 327254 OR `dest_util_id` = 327254) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  202. 0.0001

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

  203. 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 = 327254 AND W.type_id = 1) OR (W.util_id != 327254 AND W.type_id = 2)) AND (`post_util_id` = 327254 OR `dest_util_id` = 327254) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  204. 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 = 438540 AND W.type_id = 1) OR (W.util_id != 438540 AND W.type_id = 2)) AND (`post_util_id` = 438540 OR `dest_util_id` = 438540) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  205. 0.0001

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

  206. 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

  207. 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)

  208. 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

  209. 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)

  210. 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

  211. 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)

  212. 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

  213. 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)

  214. 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

  215. 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)

  216. 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

  217. 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)

  218. 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 = 382184 AND W.type_id = 1) OR (W.util_id != 382184 AND W.type_id = 2)) AND (`post_util_id` = 382184 OR `dest_util_id` = 382184) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  219. 0.0001

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

  220. 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 = 400482 AND W.type_id = 1) OR (W.util_id != 400482 AND W.type_id = 2)) AND (`post_util_id` = 400482 OR `dest_util_id` = 400482) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  221. 0.0001

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

  222. 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

  223. 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)

  224. 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 = 515147 AND W.type_id = 1) OR (W.util_id != 515147 AND W.type_id = 2)) AND (`post_util_id` = 515147 OR `dest_util_id` = 515147) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  225. 0.0001

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

  226. 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

  227. 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)

  228. 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 = 528388 AND W.type_id = 1) OR (W.util_id != 528388 AND W.type_id = 2)) AND (`post_util_id` = 528388 OR `dest_util_id` = 528388) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  229. 0.0001

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

  230. 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

  231. 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)

  232. 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

  233. 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)

  234. 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

  235. 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)

  236. 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

  237. 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

  238. 0.0001

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

  239. 0.0016

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

  240. 0

    SELECT count(*) as nbwish FROM wish

  241. 0.0508

    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

241 requetes sql en 0.1748

Taille variable Globale : 122 KB