Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Aide aux courses

Autres annonces du voisin

Tout voir
Service garde enfants
Service garde enfants
GARDE D'ENFANTS
Profil du voisin
Sarah W

Horbourg-Wihr 68180

4€/h

Demander une garde
Service livraison
Service livraison
LIVRAISON DE COLIS
Profil du voisin
Sarah W

Horbourg-Wihr 68180

10€

Faire appel à ce coursier
Service repassage
Service repassage
SERVICE : AIDE AU REPASSAGE
Profil du voisin
Sarah W

Horbourg-Wihr 68180

12€/h

Demander du repassage
Service plat seul
Service plat seul
CUISINER DES PLATS
Profil du voisin
Sarah W

Horbourg-Wihr 68180

10€/pers.

Commander
Service manger pour le diner
Service manger pour le diner
MANGER CHEZ L'HABITANT
Profil du voisin
Sarah W

Horbourg-Wihr 68180

10€/pers.

Demander à manger
Service patisserie
Service patisserie
PATISSER POUR VOUS
Profil du voisin
Sarah W

Horbourg-Wihr 68180

8€/part

Commander
Service plat seul
Service plat seul
PLATS MAISON
Profil du voisin
Sarah W

Horbourg-Wihr 68180

10€/pers.

Commander
Service assistante maternelle
Service assistante maternelle
ASSISTANTE MATERNELLE AGRééE
Profil du voisin
Sarah W

Horbourg-Wihr 68180

4€/h

Demander ce service
Service promeneur garde de chien
Service promeneur garde de chien
SERVICE : PROMENADE DE CHIEN
Profil du voisin
Sarah W

Horbourg-Wihr 68180

7€/j

Demander un promeneur
Service secretariat
Service secretariat
SERVICE : SECRéTARIAT
Profil du voisin
Sarah W

Horbourg-Wihr 68180

12€/h

Demander un service
Service garde d'animaux
Service garde d'animaux
VISITE A VOS ANIMAUX DE COMPAGNIE
Profil du voisin
Sarah W

Horbourg-Wihr 68180

7€/j

Demander une garde

Annonces similaires

Tout voir
Service aide aux courses
Service aide aux courses
SERVICE : AIDE AUX COURSES
Profil du voisin
Voisin #418260

Staffelfelden 68850

14€/h

Demander une course
Service aide aux courses
Service aide aux courses
AIDE AUX COURSES
Profil du voisin
Claude M Voisin vérifié

Osthouse 67150

8€/h

Demander une course
Service aide aux courses
Service aide aux courses
PROPOSE DE FAIRE VOS COURSES
Profil du voisin
Jessica D

Daubensand 67150

10€

Demander une course
Service aide aux courses
Service aide aux courses
SERVICE : AIDE AUX COURSES
Profil du voisin
Joelle N

Benfeld 67230

10€/h

Demander une course
Service aide aux courses
Service aide aux courses
JE M'OCCUPE DE VOS COURSES
Profil du voisin
Voisin #111233

Pfastatt 68120

15€/h

Demander une course
Service aide aux courses
Service aide aux courses
AIDE à  LA PERSONNE
Profil du voisin
Joseph B

Ensisheim 68190

15€/h

Demander une course
Service aide aux courses
Service aide aux courses
SERVICE : COURSES à FAIRE
Profil du voisin
Oswin T
5.0

Colmar 68000

15€/h

Demander une course
5.0
Service aide aux courses
Service aide aux courses
AIDE AUX DéPLACEMENTS
Profil du voisin
Isabelle

Sausheim 68390

13€/h

Demander une course
Service aide aux courses
Service aide aux courses
SERVICE : AIDE AUX COURSES
Profil du voisin
Mélanie R

Wittelsheim 68310

15€/h

Demander une course
Service aide aux courses
Service aide aux courses
SERVICE : SERVICES DIVERS
Profil du voisin
Anthony A

Sigolsheim 68240

15€/h

Demander une course

Demande un service d'aide aux courses entre voisins ou proposer mes services d'aide aux courses.

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='276439'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='aide-aux-courses' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='958'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'aide-aux-courses' LIMIT 1

  5. 0.0001

    SELECT c.cate_id, c.cate_title, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='3' AND c.cate_id='229'

  6. 0.0001

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='68'

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='63175' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  8. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 63175

  9. 0.0001

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

  10. 0.0003

    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

  11. 0.0003

    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

  12. 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 (38) ORDER BY ssrubr_order ASC

  13. 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 (45) ORDER BY ssrubr_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 (231) ORDER BY ssrubr_order ASC

  15. 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 (47) ORDER BY ssrubr_order ASC

  16. 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 (42) ORDER BY ssrubr_order ASC

  17. 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 (37) ORDER BY ssrubr_order ASC

  18. 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 (43) ORDER BY ssrubr_order ASC

  19. 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 (39) ORDER BY ssrubr_order ASC

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

  21. 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 (230) ORDER BY ssrubr_order ASC

  22. 0.0001

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 276439

  23. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=958 LIMIT 1

  24. 0.0001

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='276439'

  25. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='276439' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  26. 0.0001

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 63175 AND util_tel != ''

  27. 0.0001

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 63175 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''

  28. 0.0003

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

  29. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='63175' AND note_visu IN (1,3,4)

  30. 0.0003

    SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '276439'

  31. 0.0005

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='63175' AND wish_id<>'276439' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  32. 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='1008' LIMIT 0,1

  33. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=63175 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 = 63175 AND W.type_id = 1) OR (W.util_id != 63175 AND W.type_id = 2)) AND (`post_util_id` = 63175 OR `dest_util_id` = 63175) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  35. 0.0003

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

  36. 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='959' LIMIT 0,1

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

  38. 0.0002

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

  39. 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='938' LIMIT 0,1

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

  41. 0.0002

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

  42. 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='1104' LIMIT 0,1

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

  44. 0.0002

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

  45. 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='907' LIMIT 0,1

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

  47. 0.0002

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

  48. 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='1027' LIMIT 0,1

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

  50. 0.0002

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

  51. 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='1104' LIMIT 0,1

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

  53. 0.0002

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

  54. 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='941' LIMIT 0,1

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

  56. 0.0002

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

  57. 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='1210' LIMIT 0,1

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

  59. 0.0002

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

  60. 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='1134' LIMIT 0,1

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

  62. 0.0002

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

  63. 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='1016' LIMIT 0,1

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

  65. 0.0002

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

  66. 0.0001

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

  67. 0.0049

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.0795*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.0795*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((7.39445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.629839197041 AND ville_latitude_deg<48.529160802959 AND ville_longitude_deg>6.7213977443539 AND ville_longitude_deg<8.0675022556461 HAVING distance <= 50 ORDER BY distance ASC

  68. 0.0107

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND wish_cp IN (68180,68000,68280,68320,68320,68320,68125,68320,68320,68280,68320,68920,68320,68320,68280,68127,68040,68280,68420,68320,68320,68150,68230,68920,68230,68230,68320,68980,68420,68240,68770,68420,68630,68630,68600,68420,68420,68240,68320,68600,68420,68250,68320,68150,68340,68970,68320,68970,68340,68230,68230,68420,68240,68600,67390,68250,68600,68600,68600,68250,68127,68750,67390,68600,68250,68250,68600,68150,68230,68250,68910,67390,68230,68590,68600,68600,68140,67390,68600,68140,68740,68570,67600,67390,67390,68590,68250,68570,68240,68590,67390,68370,68250,68890,68590,68740,68650,68150,67600,68230,67600,68250,68140,68140,68140,68600,68500,67390,67390,67600,68500,68500,68890,67730,68740,68740,68500,67600,67390,68740,67390,68140,68140,68500,68140,68660,68740,68740,68190,68530,67750,68650,68380,68500,68610,67600,68190,68380,67730,67390,68190,68740,67920,68610,68660,67650,68160,68160,68530,68360,67220,68540,67820,68610,68380,68500,68380,67390,67600,68540,67600,67600,68500,68840,67220,67220,68500,88230,68500,68740,68500,67220,67600,68390,68270,88520,67650,67220,68380,67650,68490,67220,67220,68500,67220,67220,67220,67220,68270,88230,88520,67220,88520,67230,67680,67140,67230,67230,67230,67220,67220,68700,88520,67220,68850,68310,68390,68260,68490,88490,88230,68760,67220,67860,67140,67140,88490,88230,67680,88490,67230,67220,68690,88100,88520,88520,68390,88650,67230,88490,68110,88490,68820,68120,68700,68700,68490,88650,67140,68120,67220,67140,67140,67140,68700,68760,88490,88490,67860,68170,67230,88650,88490,88100,67420,67230,67860,88400,68830,68470,68550,68490,68820,67140,68460,68690,68550,68620,67420,67140,88100,88100,67140,88580,67230,88430,88650,67140,67420,67140,68470,68800,68400,88490,68200,68100,88100,67420,68800,88100,88490,67130,68470,67230,68470,67140,68790,67130,88400,68800,67140,67230,68700,67150,67130,68440,68950,67210,67150,67420,88250,67230,88430,67150,68700,67420,68800,68121,68470,88430,68470,67130,67150,67210,68520,88100,88210,88210,68800,68990,68440,68440,68700,67130,88210,88210,68350,67130,67150,68350,68290,68290,67130,68720,67530,67530,88100,67150,68490,68680,67210,88430,88210,67130,67420,88210,67130,88640,67210,68440,68440,88310,88430,68520,68720,67150,67210,68290,67570,68116,67210,88310,88210,68520,88210,68780,68440,68440,68290,67150,88400,68990,68290,88210,68680,67150,68290,67530,67130,68440,68210,68720,68720,88470,88210,88210,67870,68290,68290,68780,88210,68780,68290,67150,68510,88120,68720,68440,88640,88210,88210,88210,88600,68290,68510,88540,88470,68290,88640,67130,88600,68780,67150,88430,67880,67190,67130,88210,68720,67560,68780,67190,67190,68720,68210,68720,68210,68780,68720,88600,67130,88210,68510,68510,68510,68510,88530,67210,67130,67150,68130,68210,68210,68290,88640,68720,88120,88120,67880,68720,68720,68130,68780,68210,88640,67280,88600,88290,88420,68210,88600,88120,67130,88530,90360,67113,90110,88600,90360,67640,67115,88470,68130,88470,88640,67130,68210,88480,68510,68510,68510,67120,67130,68130,67640,67640,90170,68210,68870,68870,90110) AND fami_id='3' AND cate_id='229' AND type_id='1' AND ssrubr_id='958' AND wish_id<>'276439' AND wish_url='' ORDER BY rand() LIMIT 0,10

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

  70. 0.0001

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

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

  72. 0.0002

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

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

  74. 0.0001

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

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

  76. 0.0002

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

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

  78. 0.0001

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

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

  80. 0.0002

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

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

  82. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=222841 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 = 222841 AND W.type_id = 1) OR (W.util_id != 222841 AND W.type_id = 2)) AND (`post_util_id` = 222841 OR `dest_util_id` = 222841) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  84. 0.0002

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

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

  86. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=111233 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 = 111233 AND W.type_id = 1) OR (W.util_id != 111233 AND W.type_id = 2)) AND (`post_util_id` = 111233 OR `dest_util_id` = 111233) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  88. 0.0002

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

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

  90. 0.0001

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

  91. 0.0001

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

  92. 0.0002

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

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

  94. 0.0001

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

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

  96. 0.0002

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

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

  98. 0.0001

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

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

  100. 0.0002

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

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

  102. 0.0001

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

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

  104. 0.0002

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

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

  106. 0.0001

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

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

  108. 0.0003

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

  109. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 958

  110. 0.0017

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

  111. 0

    SELECT count(*) as nbwish FROM wish

  112. 0.0615

    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

112 requetes sql en 0.0949

Taille variable Globale : 57.99 KB