Indiquer un code postal ou une ville

Flèche vers le champ lieu

Location scooter à 78100 Saint-germain-en-laye


Retour
Fermer

Location › Véhicule

Lancez votre recherche pour voir les annonces.

Location scooter : 3 scooter scooters à louer entre particuliers à 78100 Saint-germain-en-laye Louer le scooter d'un particulier à proximité pour vos trajets. Partout en France, des particuliers proposent la location de leur scooter. Les scooters proposés à la location par des particuliers sont aussi bien des scooter 50cc que des scooter 125cc.
 ... voir la suite
<
1
2
3
4
5
>  >>
Demander à louer un scooter ou proposer un scooter en location entre particuliers.
Poster une annonce

   Scooter 50cc    Scooter 125cc    Maxi scoot    Scooter electrique    Scooter 3 roues    Scooter peugeot    Scooter piaggio    Scooter yamaha    Scooter honda    Scooter vespa
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='voiture'

  2. 0.0001

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

  3. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'

  4. 0.0001

    SELECT ville_nom FROM villes WHERE ville_cp='78100' AND ville_nom like '%saint%germain%en%laye%' ORDER BY ville_population_2012 DESC LIMIT 0,1

  5. 0.0014

    SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%scooter%' OR ssrubr_title like '%scooter%' OR ssrubr_slug like '%scooter%') AND cate_id='81' 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='78100'

  7. 0.002

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.08333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.720135678816 AND ville_latitude_deg<49.079864321184 AND ville_longitude_deg>1.8097197328734 AND ville_longitude_deg<2.3569402671266 HAVING distance <= 20 ORDER BY distance ASC

  8. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='scooter'

  9. 0.0018

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

  10. 0.0001

    SELECT * FROM texte WHERE cate_id=81

  11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='scooter' OR ssrubr_slug='scooter' OR (ssrubr_title like '%scooter%')) AND cate_id='81' 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 (81) ORDER BY ssrubr_order ASC

  15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='scooter' AND cate_id='81'

  16. 0.0001

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

  17. 0.0018

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.08333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.720135678816 AND ville_latitude_deg<49.079864321184 AND ville_longitude_deg>1.8097197328734 AND ville_longitude_deg<2.3569402671266 HAVING distance <= 20 ORDER BY distance ASC

  18. 0.0057

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.08333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.450339197041 AND ville_latitude_deg<49.349660802959 AND ville_longitude_deg>1.3992984337256 AND ville_longitude_deg<2.7673615662744 HAVING distance <= 50 ORDER BY distance ASC

  19. 0.0988

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='81' AND MATCH (wish_desc) AGAINST ('(+scooter*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (78100,78100,78230,78750,78112,78110,78560,78240,78160,78620,78300,78430,78240,78600,78380,78290,78360,78400,78870,78590,78955,78860,78600,78170,78260,78420,78630,78150,78590,78670,78670,92000,92500,78800,78150,78450,78500,78450,78810,78570,78700,78330,92380,78570,92420,92430,78540,95530,95870,78510,78121,78780,78210,92410,78630,78810,92150,92800,92210,78000,78480,78340,95370,78390,92250,92700,78580,92400,95240,92310,78220,95220,95610,95000,78130,78140,78920,95100,78850,78370,95280,92270,92200,92370,95110,92100,95000,95480,78190,95130,78580,92300,92600,78280,95000,95180,95490,78530,78350,78180,78410,78640,92360,92190,95250,78740,95130,78124,92110,78124,95800,78350,78740,78990,78580,92230,95120,78640,92130,95210,95218,78130,95300,78650,95310,78960,78117,78580,78640,93800,95650,78250,92140,78126,78410,92170,95550,95150,95450,95320,78250,93400,95230,78640,95600,92240,92320,95300,95520,78117,78114,95880,78410,78250,92390,93450,78250,95390,92350,78760,78470,95650,78410,78410,78470,78310,95740,95450,78320,91570,95580,95580,92220,92120,91400,95430,95680,92260,92330,78770,75016,75007,75014,75013,75012,75011,75000,75010,75009,75015,75005,75008,75004,75002,75006,75001,75116,75020,75019,75018,75017,75003,78250,78650,78770,93430,92290)

  20. 0.0558

    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.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.08333- 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='81' AND MATCH (wish_desc) AGAINST ('(+scooter*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (78100,78100,78230,78750,78112,78110,78560,78240,78160,78620,78300,78430,78240,78600,78380,78290,78360,78400,78870,78590,78955,78860,78600,78170,78260,78420,78630,78150,78590,78670,78670,92000,92500,78800,78150,78450,78500,78450,78810,78570,78700,78330,92380,78570,92420,92430,78540,95530,95870,78510,78121,78780,78210,92410,78630,78810,92150,92800,92210,78000,78480,78340,95370,78390,92250,92700,78580,92400,95240,92310,78220,95220,95610,95000,78130,78140,78920,95100,78850,78370,95280,92270,92200,92370,95110,92100,95000,95480,78190,95130,78580,92300,92600,78280,95000,95180,95490,78530,78350,78180,78410,78640,92360,92190,95250,78740,95130,78124,92110,78124,95800,78350,78740,78990,78580,92230,95120,78640,92130,95210,95218,78130,95300,78650,95310,78960,78117,78580,78640,93800,95650,78250,92140,78126,78410,92170,95550,95150,95450,95320,78250,93400,95230,78640,95600,92240,92320,95300,95520,78117,78114,95880,78410,78250,92390,93450,78250,95390,92350,78760,78470,95650,78410,78410,78470,78310,95740,95450,78320,91570,95580,95580,92220,92120,91400,95430,95680,92260,92330,78770,75016,75007,75014,75013,75012,75011,75000,75010,75009,75015,75005,75008,75004,75002,75006,75001,75116,75020,75019,75018,75017,75003,78250,78650,78770,93430,92290) 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='78100'

  22. 0.0018

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.08333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.720135678816 AND ville_latitude_deg<49.079864321184 AND ville_longitude_deg>1.8097197328734 AND ville_longitude_deg<2.3569402671266 HAVING distance <= 20 ORDER BY distance ASC

  23. 0.0057

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.08333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.450339197041 AND ville_latitude_deg<49.349660802959 AND ville_longitude_deg>1.3992984337256 AND ville_longitude_deg<2.7673615662744 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 = 7768 AND W.type_id = 1) OR (W.util_id != 7768 AND W.type_id = 2)) AND (`post_util_id` = 7768 OR `dest_util_id` = 7768) 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=7768 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 = 9017 AND W.type_id = 1) OR (W.util_id != 9017 AND W.type_id = 2)) AND (`post_util_id` = 9017 OR `dest_util_id` = 9017) 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=9017 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 = 10541 AND W.type_id = 1) OR (W.util_id != 10541 AND W.type_id = 2)) AND (`post_util_id` = 10541 OR `dest_util_id` = 10541) 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=10541 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 = 13459 AND W.type_id = 1) OR (W.util_id != 13459 AND W.type_id = 2)) AND (`post_util_id` = 13459 OR `dest_util_id` = 13459) 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=13459 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 = 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

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

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

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

  38. 0.0001

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

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

  40. 0.0001

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

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

  42. 0.0001

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

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

  44. 0.0001

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

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

  46. 0.0001

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

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

  48. 0.0001

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

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

  50. 0.0001

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

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

  52. 0.0001

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

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

  54. 0.0001

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

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

  56. 0.0001

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

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

  58. 0.0001

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

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

  60. 0.0001

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

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

  62. 0.0001

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

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

  64. 0.0001

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

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

  66. 0.0001

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

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

  68. 0.0001

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

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

  70. 0.0001

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

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

  72. 0.0001

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

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

  82. 0.0001

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

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

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

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

  102. 0.0001

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

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

  104. 0.0001

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

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

  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 = 159619 AND W.type_id = 1) OR (W.util_id != 159619 AND W.type_id = 2)) AND (`post_util_id` = 159619 OR `dest_util_id` = 159619) 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=159619 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 = 165076 AND W.type_id = 1) OR (W.util_id != 165076 AND W.type_id = 2)) AND (`post_util_id` = 165076 OR `dest_util_id` = 165076) 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=165076 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 = 165182 AND W.type_id = 1) OR (W.util_id != 165182 AND W.type_id = 2)) AND (`post_util_id` = 165182 OR `dest_util_id` = 165182) 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=165182 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 = 196210 AND W.type_id = 1) OR (W.util_id != 196210 AND W.type_id = 2)) AND (`post_util_id` = 196210 OR `dest_util_id` = 196210) 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=196210 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 = 200802 AND W.type_id = 1) OR (W.util_id != 200802 AND W.type_id = 2)) AND (`post_util_id` = 200802 OR `dest_util_id` = 200802) 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=200802 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 = 213025 AND W.type_id = 1) OR (W.util_id != 213025 AND W.type_id = 2)) AND (`post_util_id` = 213025 OR `dest_util_id` = 213025) 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=213025 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 = 218696 AND W.type_id = 1) OR (W.util_id != 218696 AND W.type_id = 2)) AND (`post_util_id` = 218696 OR `dest_util_id` = 218696) 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=218696 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 = 222780 AND W.type_id = 1) OR (W.util_id != 222780 AND W.type_id = 2)) AND (`post_util_id` = 222780 OR `dest_util_id` = 222780) 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=222780 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 = 218700 AND W.type_id = 1) OR (W.util_id != 218700 AND W.type_id = 2)) AND (`post_util_id` = 218700 OR `dest_util_id` = 218700) 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=218700 AND note_visu IN (1,3,4)

  124. 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 = 121485 AND W.type_id = 1) OR (W.util_id != 121485 AND W.type_id = 2)) AND (`post_util_id` = 121485 OR `dest_util_id` = 121485) 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=121485 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 = 243592 AND W.type_id = 1) OR (W.util_id != 243592 AND W.type_id = 2)) AND (`post_util_id` = 243592 OR `dest_util_id` = 243592) 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=243592 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 = 265827 AND W.type_id = 1) OR (W.util_id != 265827 AND W.type_id = 2)) AND (`post_util_id` = 265827 OR `dest_util_id` = 265827) 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=265827 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 = 266704 AND W.type_id = 1) OR (W.util_id != 266704 AND W.type_id = 2)) AND (`post_util_id` = 266704 OR `dest_util_id` = 266704) 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=266704 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 = 122717 AND W.type_id = 1) OR (W.util_id != 122717 AND W.type_id = 2)) AND (`post_util_id` = 122717 OR `dest_util_id` = 122717) 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=122717 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 = 290116 AND W.type_id = 1) OR (W.util_id != 290116 AND W.type_id = 2)) AND (`post_util_id` = 290116 OR `dest_util_id` = 290116) 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=290116 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 = 297177 AND W.type_id = 1) OR (W.util_id != 297177 AND W.type_id = 2)) AND (`post_util_id` = 297177 OR `dest_util_id` = 297177) 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=297177 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 = 298756 AND W.type_id = 1) OR (W.util_id != 298756 AND W.type_id = 2)) AND (`post_util_id` = 298756 OR `dest_util_id` = 298756) 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=298756 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 = 299387 AND W.type_id = 1) OR (W.util_id != 299387 AND W.type_id = 2)) AND (`post_util_id` = 299387 OR `dest_util_id` = 299387) 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=299387 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 = 299870 AND W.type_id = 1) OR (W.util_id != 299870 AND W.type_id = 2)) AND (`post_util_id` = 299870 OR `dest_util_id` = 299870) 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=299870 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 = 309394 AND W.type_id = 1) OR (W.util_id != 309394 AND W.type_id = 2)) AND (`post_util_id` = 309394 OR `dest_util_id` = 309394) 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=309394 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 = 309905 AND W.type_id = 1) OR (W.util_id != 309905 AND W.type_id = 2)) AND (`post_util_id` = 309905 OR `dest_util_id` = 309905) 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=309905 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 = 312410 AND W.type_id = 1) OR (W.util_id != 312410 AND W.type_id = 2)) AND (`post_util_id` = 312410 OR `dest_util_id` = 312410) 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=312410 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 = 313021 AND W.type_id = 1) OR (W.util_id != 313021 AND W.type_id = 2)) AND (`post_util_id` = 313021 OR `dest_util_id` = 313021) 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=313021 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 = 292022 AND W.type_id = 1) OR (W.util_id != 292022 AND W.type_id = 2)) AND (`post_util_id` = 292022 OR `dest_util_id` = 292022) 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=292022 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 = 320601 AND W.type_id = 1) OR (W.util_id != 320601 AND W.type_id = 2)) AND (`post_util_id` = 320601 OR `dest_util_id` = 320601) 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=320601 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 = 320601 AND W.type_id = 1) OR (W.util_id != 320601 AND W.type_id = 2)) AND (`post_util_id` = 320601 OR `dest_util_id` = 320601) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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

  158. 0.0001

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

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

  160. 0.0001

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

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

  162. 0.0001

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

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

  164. 0.0001

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

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

  166. 0.0001

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

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

  168. 0.0001

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

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

  170. 0.0001

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

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

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

  173. 0.0001

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

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

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

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

  181. 0.0001

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

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

  183. 0.0001

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

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

  185. 0.0001

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

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

  187. 0.0001

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

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

  189. 0.0001

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

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

  191. 0.0001

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

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

  193. 0.0001

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

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

  195. 0.0001

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

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

  197. 0.0001

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

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

  199. 0.0001

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

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

  201. 0.0001

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

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

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

  204. 0.0001

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

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

  206. 0.0001

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

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

  208. 0.0001

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

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

  210. 0.0001

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

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

  212. 0.0001

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

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

  214. 0.0001

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

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

  216. 0.0001

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

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

  218. 0.0001

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

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

  220. 0.0001

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

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

  222. 0.0001

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

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

  224. 0.0001

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

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

  226. 0.0001

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

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

  228. 0.0001

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

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

  230. 0.0001

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

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

  232. 0.0001

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

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

  234. 0.0001

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

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

  236. 0.0001

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

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

  238. 0.0001

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

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

  240. 0.0001

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

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

  242. 0.0001

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

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

  244. 0.0001

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

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

  246. 0.0001

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

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

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

  249. 0.0001

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

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

  251. 0.0001

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

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

  253. 0.0001

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

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

  255. 0.0001

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

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

  257. 0.0001

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

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

  259. 0.0001

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

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

  261. 0.0001

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

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

  263. 0.0001

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

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

  265. 0.0001

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

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

  267. 0.0001

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

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

  269. 0.0001

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

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

  271. 0.0001

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

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

  273. 0.0001

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

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

  275. 0.0001

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

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

  277. 0.0001

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

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

  279. 0.0001

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

  280. 0.0002

    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=81 AND ss.fami_id=5 ORDER BY ssrubr_order LIMIT 6,100

  281. 0.0003

    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='scooter' OR ssrubr_slug like '%scooter%' OR MATCH (ssrubr_slug) AGAINST ('(+scooter)')) AND sk.ssrubr_id='861' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

  282. 0.0001

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

  283. 0.0009

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

  284. 0

    SELECT count(*) as nbwish FROM wish

  285. 0.0631

    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

285 requetes sql en 0.267

Taille variable Globale : 132.11 KB