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

Service : Couturière

Annonces similaires

Tout voir
Service service a personne

Demande il y a + de 30j

Il y a + de 30j

Service : Garde malade

50€/heure

Saint-Denis
Service service a personne

Demande il y a + de 30j

Il y a + de 30j

Besoin d'aide en urgence

200€/heure

Persan
Service service a personne

Demande il y a + de 30j

Il y a + de 30j

Repassage sérieux (2h)

40€

Savigny-le-Temple
Service service a personne

Demande il y a + de 30j

Il y a + de 30j

Recherche cuisinière

50€/heure

Paris
Service service a personne

Demande il y a + de 30j

Il y a + de 30j

Service : Epilation à la cire

30€/heure

Saint-Martin-du-Tertre
Service service a personne

Demande il y a + de 30j

Il y a + de 30j

Service : Courses-bricolage

15€/heure

Melun
Service service a personne

Demande il y a + de 30j

Il y a + de 30j

Service : Vieux canapé

-- €

Paris
Service service a personne

Demande il y a + de 30j

Il y a + de 30j

Accompagnement café (3h)

60€

5/5 Paris
Service service a personne

Demande il y a + de 30j

Il y a + de 30j

Service : électricien

25€/heure

Paris
Service service a personne

Demande il y a + de 30j

Il y a + de 30j

Diagnostic électronique d'une voiture

20€/heure

Longjumeau

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

    SHOW TABLES LIKE 'pays'

  3. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  4. 0.0003

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

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

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

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

  13. 0.0001

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

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

  15. 0.0001

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

  17. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='596550' 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` = 464490 AND util_tel != ''

  19. 0

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=464490 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 = 464490 AND W.type_id = 1) OR (W.util_id <> 464490 AND W.type_id = 2)) AND (M.post_util_id = 464490 OR M.dest_util_id = 464490) 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='464490' 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 = '596550'

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

  24. 0.0001

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

  25. 0.0172

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.95*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.95*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.51667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.500339197041 AND ville_latitude_deg<49.399660802959 AND ville_longitude_deg>1.8319532137498 AND ville_longitude_deg<3.2013867862502 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0161

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

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

  28. 0.0001

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

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

  30. 0.0001

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

  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='1092' 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=542938 AND note_visu IN (1,3,4)

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

  34. 0.0002

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

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

  36. 0.0001

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

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

  38. 0.0002

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

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

  40. 0.0001

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

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

  42. 0.0001

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

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

  44. 0.0001

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

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

  46. 0.0001

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

  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=498050 AND note_visu IN (1,3,4)

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

  50. 0.0001

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

  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=180373 AND note_visu IN (1,3,4)

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

  54. 0.0001

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

  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=473811 AND note_visu IN (1,3,4)

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

  58. 0.0001

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

  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=212263 AND note_visu IN (1,3,4)

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

  62. 0.0001

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

  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=248357 AND note_visu IN (1,3,4)

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

  66. 0.0001

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

  67. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1092

  68. 0

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

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

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

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

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

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

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

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

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

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

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

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

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

  81. 0.0011

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

  82. 0.0236

    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'

  83. 0.0182

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

83 requetes sql en 0.0851

Taille variable Globale : 63.24 KB