Indiquer un code postal ou une ville

Flèche vers le champ lieu

Service multi services à 95630 Mériel


Retour
Fermer

Service › Bricoleur

Lancez votre recherche pour voir les annonces.

Service multi services : 1 annonces de multi services entre particuliers à 95630 Mériel Besoin d'un homme, toutes mains, pour faire des petits bricolages et travaux divers ? Déposez votre annonce et décrivez les travaux de bricolage que vous souhaitez réaliser pour recevoir des offres de voisins bricoleurs (homme ou femme) prêt à tout faire.
 ... voir la suite
Service multi services
Service multi services
Satisfaction Garantie
Profil du voisin
Tony Z

19 km · Bois-Colombes 92270

25€/h

Service multi services
Service multi services
Service : Aide au quotidien
Profil du voisin
Voisin #165749

18 km · Gennevilliers 92230

20€/h

Service multi services
Service multi services
Service : Aide informatique
Profil du voisin
Steve C

18 km · Saint-Martin-du-Tertre 95270

20€/h

Service multi services
Service multi services
Service : Bricolage divers
Profil du voisin
Mourad

19 km · Houilles 78800

30€/h

Service multi services
Service multi services
Service : Tout travaux
Profil du voisin
Mourad Z

19 km · Carrieres-sur-Seine 78420

25€/h

Service multi services
Service multi services
Pose Porte , Fenetres, volets, portail .
Profil du voisin
Florinel B

19 km · Goussainville 95190

25€/h

Proposer mon aide

Louer du matériel ou proposer un service

Faire appel à mes voisins

Besoin d'un objet ou d'un service ?
Service multi services
Service multi services
Pose Porte , Fenetres, volets, portail .
Profil du voisin
Florinel B

19 km · Goussainville 95190

25€/h

Service multi services
Service multi services
Service : Aide rénove
Profil du voisin
Abdelkader K

19 km · Colombes 92700

25€/h

Service multi services
Service multi services
Bricolage, transport, courses
Profil du voisin
Abderrazak B

19 km · Villeneuve-la-Garenne 92390

30€/h

Service multi services
Service multi services
Bricoleur à  votre service
Profil du voisin
Voisin #74106

24 km · Andeville 60570

-- €

<
1
2
>>
Demander un service / jobbing de bricolage ou proposer un service de bricolage entre particuliers.
Poster une annonce

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='3' AND cate_title_slug='bricolage'

  2. 0.0001

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

  3. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='95'

  4. 0.0001

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

  5. 0.0002

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

  7. 0.0024

    SELECT ville_cp, ROUND((((acos(sin((49.0833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.903435678816 AND ville_latitude_deg<49.263164321184 AND ville_longitude_deg>1.9253812201763 AND ville_longitude_deg<2.4746187798237 HAVING distance <= 20 ORDER BY distance ASC

  8. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='multi services'

  9. 0.0003

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='50'AND MATCH (wish_title,wish_desc) AGAINST ('+multi services*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '95630%'

  10. 0.0001

    SELECT * FROM texte WHERE cate_id=50

  11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='multi services' OR ssrubr_slug='multi-services' OR (ssrubr_title like '%multi services%')) AND cate_id='50' 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.0002

    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='3' 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 (50) ORDER BY ssrubr_order ASC

  15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='multi-services' AND cate_id='50'

  16. 0.0001

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

  17. 0.0022

    SELECT ville_cp, ROUND((((acos(sin((49.0833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.903435678816 AND ville_latitude_deg<49.263164321184 AND ville_longitude_deg>1.9253812201763 AND ville_longitude_deg<2.4746187798237 HAVING distance <= 20 ORDER BY distance ASC

  18. 0.0071

    SELECT ville_cp, ROUND((((acos(sin((49.0833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.633639197041 AND ville_latitude_deg<49.532960802959 AND ville_longitude_deg>1.5134471302414 AND ville_longitude_deg<2.8865528697586 HAVING distance <= 50 ORDER BY distance ASC

  19. 0.1021

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='50' AND MATCH (wish_desc) AGAINST ('(+multi +services*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (95630,95430,95630,95540,95760,95840,95430,95740,95620,95290,95840,95300,95690,95550,95150,95590,95560,95690,95660,95310,95260,95250,95300,95560,95300,95480,95690,95570,95300,95590,95810,95260,95320,95690,95560,95560,95390,95340,95590,95340,95220,95680,95130,95650,95520,60230,95810,95610,95810,95570,95270,95600,95240,95270,95000,95330,95370,95130,95570,95340,95580,95580,95120,95570,95810,95000,95270,95810,95650,95820,60530,95530,60540,60540,95350,95810,78700,95230,95270,95270,95490,95460,95160,78780,95110,95830,60530,95650,95280,60820,95210,60110,95218,95650,95650,95720,95810,95170,78570,60540,78500,60530,60110,95830,60540,95270,95720,78600,95100,95640,95440,95350,95880,95640,95410,95800,95450,95270,60530,78260,95270,95400,95200,95000,78570,60540,95870,95720,93800,60119,95360,60530,95450,95850,60530,78600,95640,93430,60110,95270,95640,95180,60460,93380,60530,92230,95850,95640,95190,95270,95270,60240,78510,78800,60260,95720,78740,78420,95450,95190,60119,60570,60175,92700,78360,95640,95640,95450,92270,78955,60460,60270,93450,92390,78480,95400,95450,95450,95270,78740,95450,60110,60119,78300,93240)

  20. 0.0632

    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((49.0833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- 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='3' AND cate_id='50' AND MATCH (wish_desc) AGAINST ('(+multi +services*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (95630,95430,95630,95540,95760,95840,95430,95740,95620,95290,95840,95300,95690,95550,95150,95590,95560,95690,95660,95310,95260,95250,95300,95560,95300,95480,95690,95570,95300,95590,95810,95260,95320,95690,95560,95560,95390,95340,95590,95340,95220,95680,95130,95650,95520,60230,95810,95610,95810,95570,95270,95600,95240,95270,95000,95330,95370,95130,95570,95340,95580,95580,95120,95570,95810,95000,95270,95810,95650,95820,60530,95530,60540,60540,95350,95810,78700,95230,95270,95270,95490,95460,95160,78780,95110,95830,60530,95650,95280,60820,95210,60110,95218,95650,95650,95720,95810,95170,78570,60540,78500,60530,60110,95830,60540,95270,95720,78600,95100,95640,95440,95350,95880,95640,95410,95800,95450,95270,60530,78260,95270,95400,95200,95000,78570,60540,95870,95720,93800,60119,95360,60530,95450,95850,60530,78600,95640,93430,60110,95270,95640,95180,60460,93380,60530,92230,95850,95640,95190,95270,95270,60240,78510,78800,60260,95720,78740,78420,95450,95190,60119,60570,60175,92700,78360,95640,95640,95450,92270,78955,60460,60270,93450,92390,78480,95400,95450,95450,95270,78740,95450,60110,60119,78300,93240) 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='95630'

  22. 0.0016

    SELECT ville_cp, ROUND((((acos(sin((49.0833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.903435678816 AND ville_latitude_deg<49.263164321184 AND ville_longitude_deg>1.9253812201763 AND ville_longitude_deg<2.4746187798237 HAVING distance <= 20 ORDER BY distance ASC

  23. 0.0057

    SELECT ville_cp, ROUND((((acos(sin((49.0833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.633639197041 AND ville_latitude_deg<49.532960802959 AND ville_longitude_deg>1.5134471302414 AND ville_longitude_deg<2.8865528697586 HAVING distance <= 50 ORDER BY distance ASC

  24. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 3270 AND W.type_id = 1) OR (W.util_id != 3270 AND W.type_id = 2)) AND (`post_util_id` = 3270 OR `dest_util_id` = 3270) 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=3270 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 = 18960 AND W.type_id = 1) OR (W.util_id != 18960 AND W.type_id = 2)) AND (`post_util_id` = 18960 OR `dest_util_id` = 18960) 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=18960 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 = 24766 AND W.type_id = 1) OR (W.util_id != 24766 AND W.type_id = 2)) AND (`post_util_id` = 24766 OR `dest_util_id` = 24766) 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=24766 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 = 45855 AND W.type_id = 1) OR (W.util_id != 45855 AND W.type_id = 2)) AND (`post_util_id` = 45855 OR `dest_util_id` = 45855) 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=45855 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 = 52370 AND W.type_id = 1) OR (W.util_id != 52370 AND W.type_id = 2)) AND (`post_util_id` = 52370 OR `dest_util_id` = 52370) 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=52370 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 = 52495 AND W.type_id = 1) OR (W.util_id != 52495 AND W.type_id = 2)) AND (`post_util_id` = 52495 OR `dest_util_id` = 52495) 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=52495 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 = 60620 AND W.type_id = 1) OR (W.util_id != 60620 AND W.type_id = 2)) AND (`post_util_id` = 60620 OR `dest_util_id` = 60620) 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=60620 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 = 52404 AND W.type_id = 1) OR (W.util_id != 52404 AND W.type_id = 2)) AND (`post_util_id` = 52404 OR `dest_util_id` = 52404) 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=52404 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 = 69878 AND W.type_id = 1) OR (W.util_id != 69878 AND W.type_id = 2)) AND (`post_util_id` = 69878 OR `dest_util_id` = 69878) 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=69878 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 = 70508 AND W.type_id = 1) OR (W.util_id != 70508 AND W.type_id = 2)) AND (`post_util_id` = 70508 OR `dest_util_id` = 70508) 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=70508 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 = 74106 AND W.type_id = 1) OR (W.util_id != 74106 AND W.type_id = 2)) AND (`post_util_id` = 74106 OR `dest_util_id` = 74106) 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=74106 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 = 75947 AND W.type_id = 1) OR (W.util_id != 75947 AND W.type_id = 2)) AND (`post_util_id` = 75947 OR `dest_util_id` = 75947) 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=75947 AND note_visu IN (1,3,4)

  48. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 64499 AND W.type_id = 1) OR (W.util_id != 64499 AND W.type_id = 2)) AND (`post_util_id` = 64499 OR `dest_util_id` = 64499) 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=64499 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 = 75492 AND W.type_id = 1) OR (W.util_id != 75492 AND W.type_id = 2)) AND (`post_util_id` = 75492 OR `dest_util_id` = 75492) 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=75492 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 = 84027 AND W.type_id = 1) OR (W.util_id != 84027 AND W.type_id = 2)) AND (`post_util_id` = 84027 OR `dest_util_id` = 84027) 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=84027 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 = 90469 AND W.type_id = 1) OR (W.util_id != 90469 AND W.type_id = 2)) AND (`post_util_id` = 90469 OR `dest_util_id` = 90469) 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=90469 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 = 107181 AND W.type_id = 1) OR (W.util_id != 107181 AND W.type_id = 2)) AND (`post_util_id` = 107181 OR `dest_util_id` = 107181) 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=107181 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 = 109798 AND W.type_id = 1) OR (W.util_id != 109798 AND W.type_id = 2)) AND (`post_util_id` = 109798 OR `dest_util_id` = 109798) 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=109798 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 = 120032 AND W.type_id = 1) OR (W.util_id != 120032 AND W.type_id = 2)) AND (`post_util_id` = 120032 OR `dest_util_id` = 120032) 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=120032 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 = 118403 AND W.type_id = 1) OR (W.util_id != 118403 AND W.type_id = 2)) AND (`post_util_id` = 118403 OR `dest_util_id` = 118403) 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=118403 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 = 132965 AND W.type_id = 1) OR (W.util_id != 132965 AND W.type_id = 2)) AND (`post_util_id` = 132965 OR `dest_util_id` = 132965) 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=132965 AND note_visu IN (1,3,4)

  66. 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 = 104588 AND W.type_id = 1) OR (W.util_id != 104588 AND W.type_id = 2)) AND (`post_util_id` = 104588 OR `dest_util_id` = 104588) 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=104588 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 = 108503 AND W.type_id = 1) OR (W.util_id != 108503 AND W.type_id = 2)) AND (`post_util_id` = 108503 OR `dest_util_id` = 108503) 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=108503 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 = 154380 AND W.type_id = 1) OR (W.util_id != 154380 AND W.type_id = 2)) AND (`post_util_id` = 154380 OR `dest_util_id` = 154380) 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=154380 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 = 165668 AND W.type_id = 1) OR (W.util_id != 165668 AND W.type_id = 2)) AND (`post_util_id` = 165668 OR `dest_util_id` = 165668) 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=165668 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 = 165749 AND W.type_id = 1) OR (W.util_id != 165749 AND W.type_id = 2)) AND (`post_util_id` = 165749 OR `dest_util_id` = 165749) 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=165749 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 = 169814 AND W.type_id = 1) OR (W.util_id != 169814 AND W.type_id = 2)) AND (`post_util_id` = 169814 OR `dest_util_id` = 169814) 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=169814 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 = 169814 AND W.type_id = 1) OR (W.util_id != 169814 AND W.type_id = 2)) AND (`post_util_id` = 169814 OR `dest_util_id` = 169814) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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

  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 = 87008 AND W.type_id = 1) OR (W.util_id != 87008 AND W.type_id = 2)) AND (`post_util_id` = 87008 OR `dest_util_id` = 87008) 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=87008 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 = 211905 AND W.type_id = 1) OR (W.util_id != 211905 AND W.type_id = 2)) AND (`post_util_id` = 211905 OR `dest_util_id` = 211905) 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=211905 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 = 219987 AND W.type_id = 1) OR (W.util_id != 219987 AND W.type_id = 2)) AND (`post_util_id` = 219987 OR `dest_util_id` = 219987) 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=219987 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 = 230178 AND W.type_id = 1) OR (W.util_id != 230178 AND W.type_id = 2)) AND (`post_util_id` = 230178 OR `dest_util_id` = 230178) 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=230178 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 = 230745 AND W.type_id = 1) OR (W.util_id != 230745 AND W.type_id = 2)) AND (`post_util_id` = 230745 OR `dest_util_id` = 230745) 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=230745 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 = 220211 AND W.type_id = 1) OR (W.util_id != 220211 AND W.type_id = 2)) AND (`post_util_id` = 220211 OR `dest_util_id` = 220211) 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=220211 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 = 255866 AND W.type_id = 1) OR (W.util_id != 255866 AND W.type_id = 2)) AND (`post_util_id` = 255866 OR `dest_util_id` = 255866) 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=255866 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 = 249432 AND W.type_id = 1) OR (W.util_id != 249432 AND W.type_id = 2)) AND (`post_util_id` = 249432 OR `dest_util_id` = 249432) 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=249432 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 = 88343 AND W.type_id = 1) OR (W.util_id != 88343 AND W.type_id = 2)) AND (`post_util_id` = 88343 OR `dest_util_id` = 88343) 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=88343 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 = 283221 AND W.type_id = 1) OR (W.util_id != 283221 AND W.type_id = 2)) AND (`post_util_id` = 283221 OR `dest_util_id` = 283221) 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=283221 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 = 308873 AND W.type_id = 1) OR (W.util_id != 308873 AND W.type_id = 2)) AND (`post_util_id` = 308873 OR `dest_util_id` = 308873) 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=308873 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 = 314947 AND W.type_id = 1) OR (W.util_id != 314947 AND W.type_id = 2)) AND (`post_util_id` = 314947 OR `dest_util_id` = 314947) 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=314947 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 = 316215 AND W.type_id = 1) OR (W.util_id != 316215 AND W.type_id = 2)) AND (`post_util_id` = 316215 OR `dest_util_id` = 316215) 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=316215 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 = 316215 AND W.type_id = 1) OR (W.util_id != 316215 AND W.type_id = 2)) AND (`post_util_id` = 316215 OR `dest_util_id` = 316215) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  111. 0.0001

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

  112. 0.0001

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

  113. 0.0001

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

  114. 0.0001

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

  115. 0.0001

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

  116. 0.0001

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

  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 = 409233 AND W.type_id = 1) OR (W.util_id != 409233 AND W.type_id = 2)) AND (`post_util_id` = 409233 OR `dest_util_id` = 409233) 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=409233 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 = 420060 AND W.type_id = 1) OR (W.util_id != 420060 AND W.type_id = 2)) AND (`post_util_id` = 420060 OR `dest_util_id` = 420060) 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=420060 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 = 423970 AND W.type_id = 1) OR (W.util_id != 423970 AND W.type_id = 2)) AND (`post_util_id` = 423970 OR `dest_util_id` = 423970) 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=423970 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 = 425905 AND W.type_id = 1) OR (W.util_id != 425905 AND W.type_id = 2)) AND (`post_util_id` = 425905 OR `dest_util_id` = 425905) 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=425905 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 = 427298 AND W.type_id = 1) OR (W.util_id != 427298 AND W.type_id = 2)) AND (`post_util_id` = 427298 OR `dest_util_id` = 427298) 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=427298 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 = 434739 AND W.type_id = 1) OR (W.util_id != 434739 AND W.type_id = 2)) AND (`post_util_id` = 434739 OR `dest_util_id` = 434739) 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=434739 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 = 411337 AND W.type_id = 1) OR (W.util_id != 411337 AND W.type_id = 2)) AND (`post_util_id` = 411337 OR `dest_util_id` = 411337) 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=411337 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 = 460345 AND W.type_id = 1) OR (W.util_id != 460345 AND W.type_id = 2)) AND (`post_util_id` = 460345 OR `dest_util_id` = 460345) 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=460345 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 = 460617 AND W.type_id = 1) OR (W.util_id != 460617 AND W.type_id = 2)) AND (`post_util_id` = 460617 OR `dest_util_id` = 460617) 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=460617 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 = 383494 AND W.type_id = 1) OR (W.util_id != 383494 AND W.type_id = 2)) AND (`post_util_id` = 383494 OR `dest_util_id` = 383494) 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=383494 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 = 485628 AND W.type_id = 1) OR (W.util_id != 485628 AND W.type_id = 2)) AND (`post_util_id` = 485628 OR `dest_util_id` = 485628) 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=485628 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 = 487891 AND W.type_id = 1) OR (W.util_id != 487891 AND W.type_id = 2)) AND (`post_util_id` = 487891 OR `dest_util_id` = 487891) 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=487891 AND note_visu IN (1,3,4)

  141. 0.0001

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

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

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

  156. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='595' LIMIT 0,1

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

  158. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 427298

  159. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='595' LIMIT 0,1

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

  161. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 165749

  162. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='595' LIMIT 0,1

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

  164. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 409233

  165. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='595' LIMIT 0,1

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

  167. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 527678

  168. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='595' LIMIT 0,1

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

  170. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 425905

  171. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='595' LIMIT 0,1

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

  173. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 169814

  174. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='595' LIMIT 0,1

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

  176. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 169814

  177. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='595' LIMIT 0,1

  178. 0.0001

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

  179. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 230745

  180. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='595' LIMIT 0,1

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

  182. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 383494

  183. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='595' LIMIT 0,1

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

  185. 0.0002

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 74106

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

  187. 0.0001

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

  188. 0.0001

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

  189. 0.0016

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

  190. 0

    SELECT count(*) as nbwish FROM wish

  191. 0.0545

    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

191 requetes sql en 0.2605

Taille variable Globale : 82.86 KB