Indiquer un code postal ou une ville

Flèche vers le champ lieu

Service aide aux courses à 78820 Juziers


Retour
Fermer

Service › Services divers

Lancez votre recherche pour voir les annonces.

Service aide aux courses : 1 annonces de aide aux courses entre particuliers à 78820 Juziers Un particulier vous aide pour faire vos courses ou fait les courses pour vous avec livraison (parfois en même temps que les siennes). Demander de l'aide ou une livraison de courses c'est possible, voyez les détails avec votre voisin grâce au chat privé du site. Vous trouverez un voisin qui cherche à faire les courses et les livrer pour ses voisins ou se propose comme chauffeur pour faire les courses avec livraison à domicile.
 ... voir la suite
Service aide aux courses
Service aide aux courses
Service : Aide à domicile
Profil du voisin
Annick D

20 km · Magnanville 78200

14€/h

Service aide aux courses
Service aide aux courses
Recherche travail vers mantes ou les alentour
Profil du voisin
Annick D

20 km · Magnanville 78200

14€/h

Service aide aux courses
Service aide aux courses
Aide aux courses
Profil du voisin
Celina

20 km · Mantes-la-Jolie 78200

-- €

Service aide aux courses
Service aide aux courses
Je me propose pour faire vos courses
Profil du voisin
Jérémy B

27 km · Bonnieres-sur-Seine 78270

13€/h

<
1
2
>>
Demander un service / jobbing d'aide aux courses ou proposer un service d'aide aux courses 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='services-divers'

  2. 0.0001

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

  3. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'

  4. 0.0001

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

  5. 0.0001

    SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%aide%aux%courses%' OR ssrubr_title like '%aide%aux%courses%' OR ssrubr_slug like '%aide%aux%courses%') AND cate_id='229' 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='78820'

  7. 0.0019

    SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.85- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.820135678816 AND ville_latitude_deg<49.179864321184 AND ville_longitude_deg>1.575840802952 AND ville_longitude_deg<2.124159197048 HAVING distance <= 20 ORDER BY distance ASC

  8. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='course; aide aux courses'

  9. 0.0002

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='229'AND MATCH (wish_title,wish_desc) AGAINST ('+course; aide aux courses*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '78820%'

  10. 0.0001

    SELECT * FROM texte WHERE cate_id=229

  11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='course; aide aux courses' OR ssrubr_slug='course;-aide-aux-courses' OR (ssrubr_title like '%course; aide aux courses%')) AND cate_id='229' 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 (229) ORDER BY ssrubr_order ASC

  15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='aide-aux-courses' AND cate_id='229'

  16. 0.0001

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

  17. 0.0018

    SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.85- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.820135678816 AND ville_latitude_deg<49.179864321184 AND ville_longitude_deg>1.575840802952 AND ville_longitude_deg<2.124159197048 HAVING distance <= 20 ORDER BY distance ASC

  18. 0.0058

    SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.85- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.550339197041 AND ville_latitude_deg<49.449660802959 AND ville_longitude_deg>1.1645960970883 AND ville_longitude_deg<2.5354039029117 HAVING distance <= 50 ORDER BY distance ASC

  19. 0.0661

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='229' AND MATCH (wish_desc) AGAINST ('(+course; +aide +aux +courses*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (78820,78820,78250,78440,78250,78410,78250,78410,95450,78250,78440,78250,78440,78130,78970,78440,78410,78250,78440,78440,78410,78410,78440,78680,78130,78440,78920,78126,78580,95450,78740,78440,95450,78440,78440,78740,78520,95510,95450,78580,95450,95450,78930,78630,95180,78200,78520,78480,95450,95510,78200,78540,78711,78580,78580,95450,78930,95000,78510,95420,95450,78124,78930,95510,78930,78580,78930,78520,95800,95420,95420,78670,78670,78200,78124,78770,95780,78930,78930,95650,95450,78630,95450,78200,95280,78570,95450,95490,95510,95450,78790,78790,78121,95650,78770,95450,95650,78955,78200,78200,95420,95450,95420,78770,78200,78770,95510,95650,78840,78790,95640,78770,95420,78270,78200,78780,78710,78520,95000,78570,78810,78790,95000,78270,78260,95780,78200,78200,78300,78240,78790,95640,95640,95420,78650,95750,95830,78200,78770,78810,78270,95420,78850,78240,78790,95520,95420,78910,95420,95710,95830,95650,95780,95510,78700,95610,95420,78650,78980,78770,78910,78640,78840,95300,78200,78910,95640,78450,78790,95750,95420,27630,78790,95300,78270,78200,95710)

  20. 0.0651

    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*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.85- 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='229' AND MATCH (wish_desc) AGAINST ('(+course; +aide +aux +courses*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (78820,78820,78250,78440,78250,78410,78250,78410,95450,78250,78440,78250,78440,78130,78970,78440,78410,78250,78440,78440,78410,78410,78440,78680,78130,78440,78920,78126,78580,95450,78740,78440,95450,78440,78440,78740,78520,95510,95450,78580,95450,95450,78930,78630,95180,78200,78520,78480,95450,95510,78200,78540,78711,78580,78580,95450,78930,95000,78510,95420,95450,78124,78930,95510,78930,78580,78930,78520,95800,95420,95420,78670,78670,78200,78124,78770,95780,78930,78930,95650,95450,78630,95450,78200,95280,78570,95450,95490,95510,95450,78790,78790,78121,95650,78770,95450,95650,78955,78200,78200,95420,95450,95420,78770,78200,78770,95510,95650,78840,78790,95640,78770,95420,78270,78200,78780,78710,78520,95000,78570,78810,78790,95000,78270,78260,95780,78200,78200,78300,78240,78790,95640,95640,95420,78650,95750,95830,78200,78770,78810,78270,95420,78850,78240,78790,95520,95420,78910,95420,95710,95830,95650,95780,95510,78700,95610,95420,78650,78980,78770,78910,78640,78840,95300,78200,78910,95640,78450,78790,95750,95420,27630,78790,95300,78270,78200,95710) 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='78820'

  22. 0.0016

    SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.85- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.820135678816 AND ville_latitude_deg<49.179864321184 AND ville_longitude_deg>1.575840802952 AND ville_longitude_deg<2.124159197048 HAVING distance <= 20 ORDER BY distance ASC

  23. 0.0058

    SELECT ville_cp, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.85- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.550339197041 AND ville_latitude_deg<49.449660802959 AND ville_longitude_deg>1.1645960970883 AND ville_longitude_deg<2.5354039029117 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 = 33375 AND W.type_id = 1) OR (W.util_id != 33375 AND W.type_id = 2)) AND (`post_util_id` = 33375 OR `dest_util_id` = 33375) 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=33375 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 = 43811 AND W.type_id = 1) OR (W.util_id != 43811 AND W.type_id = 2)) AND (`post_util_id` = 43811 OR `dest_util_id` = 43811) 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=43811 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 = 57848 AND W.type_id = 1) OR (W.util_id != 57848 AND W.type_id = 2)) AND (`post_util_id` = 57848 OR `dest_util_id` = 57848) 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=57848 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 = 74976 AND W.type_id = 1) OR (W.util_id != 74976 AND W.type_id = 2)) AND (`post_util_id` = 74976 OR `dest_util_id` = 74976) 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=74976 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 = 30966 AND W.type_id = 1) OR (W.util_id != 30966 AND W.type_id = 2)) AND (`post_util_id` = 30966 OR `dest_util_id` = 30966) 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=30966 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 = 92457 AND W.type_id = 1) OR (W.util_id != 92457 AND W.type_id = 2)) AND (`post_util_id` = 92457 OR `dest_util_id` = 92457) 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=92457 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 = 94994 AND W.type_id = 1) OR (W.util_id != 94994 AND W.type_id = 2)) AND (`post_util_id` = 94994 OR `dest_util_id` = 94994) 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=94994 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 = 112150 AND W.type_id = 1) OR (W.util_id != 112150 AND W.type_id = 2)) AND (`post_util_id` = 112150 OR `dest_util_id` = 112150) 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=112150 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 = 116824 AND W.type_id = 1) OR (W.util_id != 116824 AND W.type_id = 2)) AND (`post_util_id` = 116824 OR `dest_util_id` = 116824) 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=116824 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 = 116823 AND W.type_id = 1) OR (W.util_id != 116823 AND W.type_id = 2)) AND (`post_util_id` = 116823 OR `dest_util_id` = 116823) 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=116823 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 = 121590 AND W.type_id = 1) OR (W.util_id != 121590 AND W.type_id = 2)) AND (`post_util_id` = 121590 OR `dest_util_id` = 121590) 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=121590 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 = 129521 AND W.type_id = 1) OR (W.util_id != 129521 AND W.type_id = 2)) AND (`post_util_id` = 129521 OR `dest_util_id` = 129521) 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=129521 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 = 94994 AND W.type_id = 1) OR (W.util_id != 94994 AND W.type_id = 2)) AND (`post_util_id` = 94994 OR `dest_util_id` = 94994) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  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 = 90044 AND W.type_id = 1) OR (W.util_id != 90044 AND W.type_id = 2)) AND (`post_util_id` = 90044 OR `dest_util_id` = 90044) 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=90044 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 = 65684 AND W.type_id = 1) OR (W.util_id != 65684 AND W.type_id = 2)) AND (`post_util_id` = 65684 OR `dest_util_id` = 65684) 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=65684 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 = 159272 AND W.type_id = 1) OR (W.util_id != 159272 AND W.type_id = 2)) AND (`post_util_id` = 159272 OR `dest_util_id` = 159272) 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=159272 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 = 159996 AND W.type_id = 1) OR (W.util_id != 159996 AND W.type_id = 2)) AND (`post_util_id` = 159996 OR `dest_util_id` = 159996) 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=159996 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 = 171028 AND W.type_id = 1) OR (W.util_id != 171028 AND W.type_id = 2)) AND (`post_util_id` = 171028 OR `dest_util_id` = 171028) 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=171028 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 = 177537 AND W.type_id = 1) OR (W.util_id != 177537 AND W.type_id = 2)) AND (`post_util_id` = 177537 OR `dest_util_id` = 177537) 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=177537 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 = 139006 AND W.type_id = 1) OR (W.util_id != 139006 AND W.type_id = 2)) AND (`post_util_id` = 139006 OR `dest_util_id` = 139006) 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=139006 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 = 203445 AND W.type_id = 1) OR (W.util_id != 203445 AND W.type_id = 2)) AND (`post_util_id` = 203445 OR `dest_util_id` = 203445) 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=203445 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 = 203336 AND W.type_id = 1) OR (W.util_id != 203336 AND W.type_id = 2)) AND (`post_util_id` = 203336 OR `dest_util_id` = 203336) 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=203336 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 = 204168 AND W.type_id = 1) OR (W.util_id != 204168 AND W.type_id = 2)) AND (`post_util_id` = 204168 OR `dest_util_id` = 204168) 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=204168 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 = 205352 AND W.type_id = 1) OR (W.util_id != 205352 AND W.type_id = 2)) AND (`post_util_id` = 205352 OR `dest_util_id` = 205352) 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=205352 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 = 106470 AND W.type_id = 1) OR (W.util_id != 106470 AND W.type_id = 2)) AND (`post_util_id` = 106470 OR `dest_util_id` = 106470) 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=106470 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 = 218178 AND W.type_id = 1) OR (W.util_id != 218178 AND W.type_id = 2)) AND (`post_util_id` = 218178 OR `dest_util_id` = 218178) 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=218178 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 = 220393 AND W.type_id = 1) OR (W.util_id != 220393 AND W.type_id = 2)) AND (`post_util_id` = 220393 OR `dest_util_id` = 220393) 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=220393 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 = 206030 AND W.type_id = 1) OR (W.util_id != 206030 AND W.type_id = 2)) AND (`post_util_id` = 206030 OR `dest_util_id` = 206030) 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=206030 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 = 226074 AND W.type_id = 1) OR (W.util_id != 226074 AND W.type_id = 2)) AND (`post_util_id` = 226074 OR `dest_util_id` = 226074) 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=226074 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 = 256034 AND W.type_id = 1) OR (W.util_id != 256034 AND W.type_id = 2)) AND (`post_util_id` = 256034 OR `dest_util_id` = 256034) 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=256034 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 = 261320 AND W.type_id = 1) OR (W.util_id != 261320 AND W.type_id = 2)) AND (`post_util_id` = 261320 OR `dest_util_id` = 261320) 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=261320 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 = 261320 AND W.type_id = 1) OR (W.util_id != 261320 AND W.type_id = 2)) AND (`post_util_id` = 261320 OR `dest_util_id` = 261320) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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

  95. 0.0001

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

  96. 0.0001

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

  97. 0.0001

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

  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 = 64982 AND W.type_id = 1) OR (W.util_id != 64982 AND W.type_id = 2)) AND (`post_util_id` = 64982 OR `dest_util_id` = 64982) 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=64982 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 = 251617 AND W.type_id = 1) OR (W.util_id != 251617 AND W.type_id = 2)) AND (`post_util_id` = 251617 OR `dest_util_id` = 251617) 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=251617 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 = 357302 AND W.type_id = 1) OR (W.util_id != 357302 AND W.type_id = 2)) AND (`post_util_id` = 357302 OR `dest_util_id` = 357302) 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=357302 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 = 358934 AND W.type_id = 1) OR (W.util_id != 358934 AND W.type_id = 2)) AND (`post_util_id` = 358934 OR `dest_util_id` = 358934) 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=358934 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 = 359082 AND W.type_id = 1) OR (W.util_id != 359082 AND W.type_id = 2)) AND (`post_util_id` = 359082 OR `dest_util_id` = 359082) 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=359082 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 = 371199 AND W.type_id = 1) OR (W.util_id != 371199 AND W.type_id = 2)) AND (`post_util_id` = 371199 OR `dest_util_id` = 371199) 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=371199 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 = 385048 AND W.type_id = 1) OR (W.util_id != 385048 AND W.type_id = 2)) AND (`post_util_id` = 385048 OR `dest_util_id` = 385048) 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=385048 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 = 385048 AND W.type_id = 1) OR (W.util_id != 385048 AND W.type_id = 2)) AND (`post_util_id` = 385048 OR `dest_util_id` = 385048) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  113. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 397170 AND W.type_id = 1) OR (W.util_id != 397170 AND W.type_id = 2)) AND (`post_util_id` = 397170 OR `dest_util_id` = 397170) 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=397170 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 = 402391 AND W.type_id = 1) OR (W.util_id != 402391 AND W.type_id = 2)) AND (`post_util_id` = 402391 OR `dest_util_id` = 402391) 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=402391 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 = 427031 AND W.type_id = 1) OR (W.util_id != 427031 AND W.type_id = 2)) AND (`post_util_id` = 427031 OR `dest_util_id` = 427031) 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=427031 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 = 428507 AND W.type_id = 1) OR (W.util_id != 428507 AND W.type_id = 2)) AND (`post_util_id` = 428507 OR `dest_util_id` = 428507) 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=428507 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 = 192278 AND W.type_id = 1) OR (W.util_id != 192278 AND W.type_id = 2)) AND (`post_util_id` = 192278 OR `dest_util_id` = 192278) 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=192278 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 = 436445 AND W.type_id = 1) OR (W.util_id != 436445 AND W.type_id = 2)) AND (`post_util_id` = 436445 OR `dest_util_id` = 436445) 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=436445 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 = 470062 AND W.type_id = 1) OR (W.util_id != 470062 AND W.type_id = 2)) AND (`post_util_id` = 470062 OR `dest_util_id` = 470062) 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=470062 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 = 131556 AND W.type_id = 1) OR (W.util_id != 131556 AND W.type_id = 2)) AND (`post_util_id` = 131556 OR `dest_util_id` = 131556) 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=131556 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 = 426042 AND W.type_id = 1) OR (W.util_id != 426042 AND W.type_id = 2)) AND (`post_util_id` = 426042 OR `dest_util_id` = 426042) 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=426042 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 = 416075 AND W.type_id = 1) OR (W.util_id != 416075 AND W.type_id = 2)) AND (`post_util_id` = 416075 OR `dest_util_id` = 416075) 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=416075 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 = 416075 AND W.type_id = 1) OR (W.util_id != 416075 AND W.type_id = 2)) AND (`post_util_id` = 416075 OR `dest_util_id` = 416075) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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

  145. 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='958' LIMIT 0,1

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

  147. 0.0002

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

  148. 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='958' LIMIT 0,1

  149. 0.0001

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

  150. 0.0002

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

  151. 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='958' LIMIT 0,1

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

  153. 0.0002

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

  154. 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='958' LIMIT 0,1

  155. 0.0001

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

  156. 0.0001

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

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

  158. 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='course; aide aux courses' OR ssrubr_slug like '%course; aide aux courses%' OR MATCH (ssrubr_slug) AGAINST ('(+course; +aide +aux +courses)')) AND sk.ssrubr_id='958' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

  159. 0.0001

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

  160. 0.0009

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

  161. 0

    SELECT count(*) as nbwish FROM wish

  162. 0.0478

    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

162 requetes sql en 0.213

Taille variable Globale : 79.43 KB