Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Plusieurs servieces la personne

Autres annonces du voisin

Tout voir
Service repassage
Service : repassage

Saint-Mathieu... 34270

Je repasse a  mon domicile
Profil du voisin
Angela V

Saint-Mathieu-de-Treviers 34270

15€/h

Demander du repassage
Location instrument musique
Location : instrument musique

Saint-Mathieu... 34270

Piano yamaha
Profil du voisin
Angela V

Saint-Mathieu-de-Tréviers 34270

25€/jr

Louer l'instrument
Service entretien jardin
Service : entretien jardin

Saint-Mathieu... 34270

Service : etretient jardins
Profil du voisin
Angela V

Saint-Mathieu-de-Treviers 34270

15€/h

Demander ce jardinier
Service animations
Service : animations

Fontanes 34270

Ateliers de cuisine créative
Profil du voisin
Angela V

Fontanes 34270

65€

Réserver cette animation

Annonces similaires

Tout voir
Service service a personne
Service : service a personne

Pignan 34570

Service : ferrailleur du 34
Profil du voisin
Serge L

Pignan 34570

-- €

Demander un service
Service service a personne
Service : service a personne

Montpellier 34000

Service : aide a domicile
Profil du voisin
Marine C Voisin vérifié

Montpellier 34000

12€/h

Demander un service
Service service a personne
Service : service a personne

Montpellier 34000

Soins thérapeutiques corps & esprit com
Profil du voisin
A. V

Montpellier 34000

40€/h

Demander un service
Service service a personne
Service : service a personne

Montpellier 34000

Depannage service
Profil du voisin
Xavier C

Montpellier 34000

25€/h

Demander un service
Service service a personne
Service : service a personne

Castelnau-le-... 34170

Recherche mannequins mains pour ongles (
Profil du voisin
Voisin #88307

Castelnau-le-Lez 34170

-- €

Demander un service
Service service a personne
Service : service a personne

Plaissan 34230

Repassage à domicile
Profil du voisin
Eva F

Plaissan 34230

12€/h

Demander un service
Service service a personne
Service : service a personne

Mauguio 34130

Services à  la personne
Profil du voisin
Robert S

Mauguio 34130

22€/h

Demander un service
Service service a personne
Service : service a personne

Meze 34140

Service : utilitaire nacelle
Profil du voisin
Samuel B

Meze 34140

90€/h

Demander un service
Service service a personne
Service : service a personne

Montpellier 34000

Service : pressing a domicile
Profil du voisin
Wassila C

Montpellier 34000

-- €

Demander un service
Service service a personne
Service : service a personne

Nimes 30000

Services personnes agées et autres...
Profil du voisin
Bruno V Voisin vérifié

Nimes 30000

15€/h

Demander un service

Demande un service de service a la personne entre voisins ou proposer mes services de service a la personne.

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

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='service-a-personne' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='1092'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'service-a-personne' LIMIT 1

  5. 0.0001

    SELECT c.cate_id, 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

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

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='87174' 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` = 87174

  9. 0

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

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

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

  12. 0.0001

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

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

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

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

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

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

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

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

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

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

  23. 0.0001

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

  24. 0.0001

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

  25. 0

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

  26. 0

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

  27. 0.0001

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

  28. 0.0001

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

  29. 0.0001

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

  30. 0.0001

    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='87174' AND wish_id<>'431467' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

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

  32. 0.0001

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

  33. 0.0001

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

  34. 0.0001

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

  35. 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='998' LIMIT 0,1

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

  37. 0.0001

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

  38. 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='527' LIMIT 0,1

  39. 0.0001

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

  40. 0.0001

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

  41. 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='1199' LIMIT 0,1

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

  43. 0.0001

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

  44. 0.0001

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

  45. 0.0028

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((43.75*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((43.75*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.83333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>43.300339197041 AND ville_latitude_deg<44.199660802959 AND ville_longitude_deg>3.2108385100752 AND ville_longitude_deg<4.4558214899248 HAVING distance <= 50 ORDER BY distance ASC

  46. 0.0059

    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 (34270,34270,34270,34270,34270,34730,34270,34980,34730,34270,34820,34380,34980,34380,34820,34270,34380,34380,34380,34980,34980,34160,34160,34820,34270,34830,34380,34980,34270,34790,34830,34160,34570,34380,34160,34160,34920,34270,34170,34270,30260,34160,34160,34160,34160,34190,34990,34160,30260,34680,34570,34740,34380,34160,34160,34160,30170,34190,34130,34570,34160,34070,34080,34090,34000,34150,34670,34190,30260,30260,34150,34670,34160,30250,34190,30260,34880,34430,34570,34570,34570,34190,34380,34160,34400,34130,34190,30250,34190,30260,30250,34380,30250,34130,34130,34970,34400,34150,34400,30260,30250,34400,34130,34190,30250,30610,34470,30250,34150,30260,30170,34690,34190,30250,34400,34190,30170,30250,34150,30260,34130,30260,34190,30170,34660,34660,34750,30120,34230,30440,34400,30610,30440,30250,34150,34400,34250,30260,30250,34400,30170,30260,30170,30440,30111,34150,34230,30260,34400,30610,30660,30440,30440,30730,30610,34150,30670,34110,30170,30440,30260,34230,34520,30420,34230,34150,30170,30120,30260,34560,34280,34725,30120,30121,34590,34110,34725,34770,30610,30460,30870,30470,34725,34230,30140,30310,34520,30350,30350,34230,30460,30350,34800,30870,34725,30120,30120,30140,30460,30730,30114,30920,30220,30120,30114,34800,30440,30770,34560,30980,34725,30120,34230,30730,34800,30140,30350,30460,30740,34700,30350,30600,34560,30350,34520,34230,34230,30730,30980,34700,34800,34110,30570,30120,30770,30350,30120,30240,30350,30120,30620,30730,30120,34700,30570,30120,34230,30460,30220,34800,30140,34540,30820,30460,30350,34230,30730,30140,30350,30140,34700,30620,34800,30350,34700,34230,34140,30600,30120,34800,30190,30350,34230,30350,34800,30770,30720,34700,30350,34140,30540,34540,34520,34520,30190,34800,30770,30190,30140,34800,34800,30350,30140,34700,30620,34700,30640,30190,30270,30124,34230,30190,34230,30190,34520,30770,30360,34800,30770,34700,34230,30190,30190,34800,30570,34200,30124,34530,34700,30360,30140,30510,30122,34140,34700,34700,30140,30140,34120,34800,34700,30360,30380,30125,30360,34320,30900,30000,34120,30360,34530,30190,30190,34520,34800,30560,34700,30190,34520,30190,34800,34700,30140,30360,30190,12230,30132,34320,30360,30360,12230,34700,34800,30940,34800,48110,30360,48330,34520,30340,34850,30190,34720,30128,34320,30750,30100,30190,34810,34120,30480,30360,34120,12230,30190,30700,30360,30360,34650,30480,34320,48110,30230,34650,30800,13460,48110,30340,30340,30230,30700,34120,30750,34650,30190,30700,34320,34600,30110,34120) AND fami_id='3' AND cate_id='229' AND type_id='1' AND ssrubr_id='1092' AND wish_id<>'431467' AND wish_url='' ORDER BY rand() LIMIT 0,10

  47. 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='1092' LIMIT 0,1

  48. 0.0001

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

  49. 0.0001

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

  50. 0.0001

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

  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='1092' LIMIT 0,1

  52. 0.0001

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

  54. 0.0001

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

  55. 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='1092' LIMIT 0,1

  56. 0.0001

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

  58. 0.0001

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

  59. 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='1092' LIMIT 0,1

  60. 0.0001

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

  62. 0.0001

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

  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='1092' LIMIT 0,1

  64. 0.0001

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

  66. 0.0001

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

  67. 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='1092' LIMIT 0,1

  68. 0.0001

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

  70. 0.0001

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

  71. 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='1092' LIMIT 0,1

  72. 0.0001

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

  74. 0.0001

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

  75. 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='1092' LIMIT 0,1

  76. 0.0001

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

  78. 0.0001

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

  79. 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='1092' LIMIT 0,1

  80. 0.0001

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

  82. 0.0001

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

  83. 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='1092' LIMIT 0,1

  84. 0.0001

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

  86. 0.0001

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

  87. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1092

  88. 0.0008

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

  89. 0

    SELECT count(*) as nbwish FROM wish

  90. 0.0448

    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

90 requetes sql en 0.0624

Taille variable Globale : 57.95 KB