Kiwiiz : service & location entre voisins.
Utiliser ma position
Logo recherche

Indiquer un code postal ou une ville Indiquer un code postal

Flèche vers le champ lieu

Poster une annonce

Aide à tout faire

Autres annonces du voisin

Tout voir
Service maconnerie

Il y a + de 30j

Il y a + de 30j

Clôture petit muret

25€/heure

Villepinte
Service aide personne

Il y a + de 30j

Il y a + de 30j

Aide à  la personne âgée (7h)

140€/jour

Sevran
Location voiture sans permis

Il y a + de 30j

Il y a + de 30j

Loue chambre

400€/jour

Villepinte
Service entretien jardin

Il y a + de 30j

Il y a + de 30j

Service : Retourner la terre

20€/heure

Villepinte
Location coupe branches

Demande il y a + de 30j

Il y a + de 30j

Aide à tout faire

20€/jour

Villepinte

Annonces similaires

Tout voir
Service service a personne

Il y a + de 30j

Il y a + de 30j

Services divers

10€/jour

Guyancourt
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service divers

10€

Guyancourt
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Auxiliaire de vie

15€/heure

Meaux
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Auxiliaire de vie

15€/heure

Ulis
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Couturière

25€/heure

Saint-Ouen-l'Aumone
Service service a personne

Il y a + de 30j

Il y a + de 30j

Repassage a domicile

10€/heure

Acy-en-Multien
Service service a personne

Il y a + de 30j

Il y a + de 30j

Cuisine des plats africains

50€/heure

Villepinte
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Réception

50€/heure

Pontault-Combault
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service de repassage

25€/heure

Ablon-sur-Seine
Service service a personne

Il y a + de 30j

Il y a + de 30j

Couture retouches vêtements

10€/heure

Conflans-Sainte-Honorine

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

Poster une annonce
Retour
Fermer

Services entre voisins

Lancez votre recherche pour voir les annonces.

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

    SHOW TABLES LIKE 'pays'

  3. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  4. 0.0002

    SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC

  5. 0.0001

    SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL

  6. 0.0004

    SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''

  7. 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='463521'

  8. 0.0001

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

  9. 0.0001

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

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

  11. 0.0001

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

  12. 0.0001

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

  13. 0

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

  14. 0.0001

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1092 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  18. 0

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

  19. 0

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=87233 LIMIT 1

  20. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 87233 AND W.type_id = 1) OR (W.util_id <> 87233 AND W.type_id = 2)) AND (M.post_util_id = 87233 OR M.dest_util_id = 87233) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  21. 0.0001

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

  22. 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 = '463521'

  23. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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='87233' AND wish_id<>'463521' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  24. 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='964' LIMIT 0,1

  25. 0.0001

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

  26. 0.0002

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

  27. 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='1020' LIMIT 0,1

  28. 0.0002

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

  29. 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='1094' LIMIT 0,1

  30. 0.0002

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

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

  32. 0.0003

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

  33. 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='22' LIMIT 0,1

  34. 0.0001

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

  35. 0.0001

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

  36. 0.0159

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.53333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.517039197041 AND ville_latitude_deg<49.416360802959 AND ville_longitude_deg>1.8483839280719 AND ville_longitude_deg<3.2182760719281 HAVING distance <= 50 ORDER BY distance ASC

  37. 0.0138

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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 ('93420','93600','93290','93270','95700','93410','95500','93390','93190','95500','95500','77290','77181','93470','77270','93700','93150','95500','95190','77990','95380','93320','93340','95380','93370','77181','77990','95140','95400','93440','93140','95720','95380','93220','93350','95380','93250','93000','77410','77410','77230','77290','77500','93130','95190','77230','93240','93360','77230','95720','95470','93460','95200','95400','93110','95380','93260','93230','77177','77230','77410','93380','93500','93120','95440','93300','77410','77410','95190','95350','77230','93330','95670','95470','93160','94170','95850','93200','93210','93100','95360','95720','77230','93310','94120','95410','77420','93170','77360','93430','77230','95460','95850','77230','77400','95350','77230','77410','95170','95720','95470','94360','94350','94300','77186','95160','93450','77410','92390','95470','60128','94130','77400','95270','77200','95270','77400','77230','95880','95270','95270','77185','95570','77400','95330','93400','77400','93800','94500','94420','95270','77280','77600','77410','94160','95230','77230','95570','77400','60128','94340','77230','77400','95580','95580','77165','92230','94410','77090','77183','77184','60330','95570','77600','77600','77165','77450','75007','75012','75011','75010','75005','95270','75013','75014','75017','75009','75008','75020','75019','75015','75016','75018','75003','75002','75116','75004','75001','75000','75006','95210','95218','77600','77410','77410','60950','60520','60560','94430','92110','95600','77165','77165','77410','94100','94340','94210','95270','94220','95680','92600','95270','95560','77144','95570','77230','77144','77700','77340','77600','95120','77450','92300','77450','94700','94200','94205','95270','95390','92270','95560','94140','77680','60520','94490','94880','94880','95560','77164','60330','94270','95110','60520','94510','95100','77165','77700','60580','94000','77450','95320','92700','95560','92200','60260','77600','92400','95130','92250','77450','95270','60950','94250','94800','77135','95130','94370','94380','77124','95590','77178','77700','94380','60330','77122','77450','94400','92170','95840','95270','92120','77450','95870','77178','77700','60950','95270','94110','77450','94600','95590','92240','94470','95150','95550','77330','77124','95240','77124','77100','60330','95840','94460','92150','92800','77100','60300','60300','94320','77165','77165','95740','77860','95250','78800','94235','94238','94237','94236','94234','94233','94232','94231','94240','94239','94230','95590','92220','92000','77700','92100','60270','95530','77124','95370','78500','92130','77174','77580','60440','60820','60300','60300','60300','94550','94440','95260','94310','94390','92320','92500','77860','77910','78420','60500','60300','94450','60500','92340','77139','60300','77860','77150','94190','95540','60440','95260','92140','60300','77150','92210','95220','77910','77100','95820','60440','94290','95480','92260','92330','95290','95430','60440','77174','95630','94150','92190','92360','95660','94440','77139','91330','94440','95340','77170','78600','95340','92350','60300','60740','95760','91560','60440','95620','78360','60460','77220','94260','95430','77580','77580','60340','94480','92380','77470','60300','77910','60340','60810','77173','91200','78400','77580','92410','92310','92160','92290','60300','94520','94520','77470','91800','77220','91320','77580','78600','77139','77139','92420','92430','77580','60530','60440','91230','60810','60230','91550','77470','92370','77910','77470','60810','91270','78170','91370','60530','77220','77610','60460','78290','78380','77580','78110','91800','95690','91860','78140','78700','77163','60700','91300','95310','78560','60530','77220','60440','95340','77170','95610','77470','91480','60160','77580','60530','78430','78230','77440','60800','78220','91210','95300','77470','77440','60440','95300','60660','77166','60810','91420','60530','77470','91480','91260','91570','77380','95300','95690','60100','60620','95690','77163','78100','60180','78150','60620','78150','60800','60800','77610','78260','78570','60810','60160','77139','78750','60530','91380','77220','91160','78780','77610','95000','60620','95690','78000','77163','91120','60540','78160','60540','91430','78350','95000','95300','60620','60660','60660','60810','91170','60550','77390','77440','78112','77580','77660','78870','60540','60870','77166','77440','60660','60660','78300','91160','77170','95810','91430','91450','95520','77515','77580','77440','77580','78620','60810','91600','91390','77610','60530','91140','77610','91130','91000','95650','60620','91360','78590','77660','78570','78955','60620','78530','78350','60620','60410','91350','77111','77440','95280','60800','77440','60540','91360','60800','91160','60870','60870','77127','91250','95490','60700','77580','78240','91400','60290','60700','91450','60540','60290','91000','91090','95810','77111','77610','95810','77440','77440','60700','91160','60800','95650','77145','60660','60800','78590','77610','91140','78240','60110','60250','60620','60410','77515','77120','95650','77515','78210','78117','60940','60940','78510','78670','78670','60410','60940','91280','91700','77515','78330','91250','77640','91700','77390','91400','60620','60140','60800','77550','60700','95000','60290','95800','77440','60730','60320','95810','95810','60620','60620','95810','60410','60250','91700','60730','60800','77540','60110','78860','91440','77550','91080','78540','78480','77120','77260','77260','91620','91190','77550','91070','60890','95180','60800','60129','78630','78450','77390','60620','78280','60410','91240','77390','60140','60620','91250','91100','78117','77840','95650','95650','60140','60730','60250','60117','95830','77550','91190','60570','91310','60290','91940','91620','77260','60110','60410','77390','77390','95810','91090','77440','78740','77515','91310','60290','91310','77131','60570','60250','91220','91220','78390','95450','78450','60890','95830','77440','60320','60730','60320','60700','95640','60890','60140','77176','60730','60129','78960','78180','77120','95640','91940','77390','78810','78114','60700','78740','60320','91190','91940','60700','60140','91100','60890','91460','77390','95450','77120','60710','60129','77120','78340','95450','60290','60119','60141','77950','77390','78130','77260','77540','77131','78470','60890','95450','78630','77640','60710','78190','91310','60175','60117','60800','77390','60250','78470','77950','77390','60140','91250','02810','91830','60117','60110','77176','60126','77540','77840','77240','60890','95640','78121','77120','77240','60127','95640','60129','77260','60250','60126','91640','77260','78920','60190','60600','91540','91540','95450','78130','91400','78810','60680','78250','78580','77720','77950','91540','95450','60250','60141','60119','60240','91180','77390','78370','77950','95640','78470','60250','77540','91810','78460','78410','60610','77240','78250','95640','95640','60600','60570','77390','77510','60190','60600','60190','77540','78250','77540','60190','60600','60840','60119','77260','60250','60880','77440','95450','60250','77720','60890','91290','77169','77120','78850','77169','60173','60117','60127','60430','78250','91630','60110','77120','78990','60600','02810','91540','91470','91290','60430','77138','77840','91680','60600','60149','60117','91630','91470','78250','77750','60790','60680','60680','02600','91710','77950','95450','95450','02460','91640','60370','78580','77115','77720','60190','77310','77540','91470','77310','91830','91520','91340','91630','77950','95640','78640','77730','78410','60600','91750','77350','60240','78580','78320','60123','02310','60370','78320','78720','60430','95750','77720','95450','91630','77000','77000','95450','78640','78460','77750','78124','60880','60880','60790','60430','60190','60790','91640','91680','60370','78124','02810','78720','60790','95450','77730','78410','77730','91470','78820') AND fami_id='3' AND cate_id='229' AND type_id='1' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='1092' AND wish_id<>'463521' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

  39. 0.0001

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

  40. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 546572 AND W.type_id = 1) OR (W.util_id <> 546572 AND W.type_id = 2)) AND (M.post_util_id = 546572 OR M.dest_util_id = 546572) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  41. 0.0001

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

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

  43. 0.0002

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

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

  45. 0.0001

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

  46. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 156664 AND W.type_id = 1) OR (W.util_id <> 156664 AND W.type_id = 2)) AND (M.post_util_id = 156664 OR M.dest_util_id = 156664) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  47. 0.0001

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

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

  49. 0.0001

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

  50. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 394922 AND W.type_id = 1) OR (W.util_id <> 394922 AND W.type_id = 2)) AND (M.post_util_id = 394922 OR M.dest_util_id = 394922) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  51. 0.0001

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

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

  53. 0.0001

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

  54. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 543116 AND W.type_id = 1) OR (W.util_id <> 543116 AND W.type_id = 2)) AND (M.post_util_id = 543116 OR M.dest_util_id = 543116) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  55. 0.0002

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

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

  57. 0.0001

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

  58. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 542662 AND W.type_id = 1) OR (W.util_id <> 542662 AND W.type_id = 2)) AND (M.post_util_id = 542662 OR M.dest_util_id = 542662) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  59. 0.0002

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

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

  61. 0.0001

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

  62. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 540324 AND W.type_id = 1) OR (W.util_id <> 540324 AND W.type_id = 2)) AND (M.post_util_id = 540324 OR M.dest_util_id = 540324) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  63. 0.0002

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

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

  65. 0.0001

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

  66. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 478519 AND W.type_id = 1) OR (W.util_id <> 478519 AND W.type_id = 2)) AND (M.post_util_id = 478519 OR M.dest_util_id = 478519) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  67. 0.0002

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

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

  69. 0.0001

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

  70. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 539337 AND W.type_id = 1) OR (W.util_id <> 539337 AND W.type_id = 2)) AND (M.post_util_id = 539337 OR M.dest_util_id = 539337) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  71. 0.0002

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

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

  73. 0.0001

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

  74. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 90640 AND W.type_id = 1) OR (W.util_id <> 90640 AND W.type_id = 2)) AND (M.post_util_id = 90640 OR M.dest_util_id = 90640) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  75. 0.0001

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

  76. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1092

  77. 0

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

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

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

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

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

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

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

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

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

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

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

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

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

  90. 0.0009

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

  91. 0.0268

    SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'

  92. 0.0206

    SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

92 requetes sql en 0.0884

Taille variable Globale : 62.71 KB