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
5 € / part
Paiement 100% sécurisé
  • Service client réactif
  • Dépôt remboursé si annulé

Autres annonces du voisin

Tout voir
Service chef cuisinier

Demande il y a + de 30j

Il y a + de 30j

Service : coktail dinatoire

350€/heure

Montigny-le-Bretonneux

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 : 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
Service service a personne

Demande il y a + de 30j

Il y a + de 30j

Service : Repassage

50€/heure

Creteil

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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci

  2. 0.0001

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

  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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('78' USING utf8mb4) COLLATE utf8mb4_general_ci

  12. 0.0001

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

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

  15. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1092 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  18. 0.0001

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

  19. 0

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

  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='445280' AND wish_id<>'582899' 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='946' 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=445280 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 = 445280

  27. 0.0001

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

  28. 0.0072

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.03333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.317039197041 AND ville_latitude_deg<49.216360802959 AND ville_longitude_deg>1.3511160125509 AND ville_longitude_deg<2.7155439874491 HAVING distance <= 50 ORDER BY distance ASC

  29. 0.0131

    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 ('78180','78960','78280','78190','78390','78470','78470','78210','78114','78330','78320','78117','78117','78320','78990','78340','78530','78350','78450','78590','78460','78720','78720','78000','91190','78320','78370','78470','78310','78310','91190','78150','78860','91470','78460','78590','78150','78350','78760','78450','78870','78720','78220','91400','78690','78640','78690','91470','78620','78140','78160','91940','91190','78810','78720','78640','91440','78640','78490','78850','78170','78430','91400','92420','92430','92370','91430','91470','78112','78610','91400','92410','78380','78810','78290','78640','92310','78750','91470','78490','78490','91570','91940','92380','91430','78560','78490','91940','78240','78240','78121','78100','78650','78610','78400','91640','78230','78490','92210','78125','92360','92190','78490','78490','78110','78720','78650','78830','91120','78830','78630','92290','92350','91370','91140','91470','92140','78490','78770','92100','78610','91140','91640','92500','78124','78490','92130','92150','92800','92330','92260','78580','78300','91160','92320','91300','78580','78360','91640','78124','92000','78770','78770','78120','91160','91640','78120','91620','92160','78490','78940','92220','78630','78420','78600','92240','78610','78770','78955','91680','78770','78670','78670','91470','78800','78730','78730','92340','94260','91460','92170','91380','91160','91530','78580','78770','92200','91160','91620','92120','78890','92400','92250','94236','94235','94237','94239','94240','94234','94238','94233','94230','94232','94231','78490','78920','78600','78580','91680','91410','78940','94110','91320','91530','78260','78540','91310','91310','94250','78125','95870','78126','92700','91310','78500','78120','78910','94550','91420','94150','78130','78730','78770','91700','92300','91360','91310','78910','92270','78570','78510','78570','78410','91650','78480','91180','91340','91520','92600','92110','78125','91240','78700','91360','94800','91650','78580','95530','91650','91530','75008','75009','75010','75011','75013','75014','75116','75015','75017','75018','75019','75016','75020','75007','75001','75002','75003','75012','75004','75005','75006','75000','94270','91550','78410','78410','78410','78910','94320','78930','78910','91390','91600','78680','95100','78125','91290','91410','78410','91410','78730','78780','91530','94200','94205','95370','93400','78790','78790','91700','78790','91290','91220','91220','78910','78950','78930','92230','94400','78730','94390','78113','94310','95240','78550','78113','91260','78130','95110','91580','91630','78125','91200','91790','78125','95220','78250','95280','95000','95000','78910','91170','78970','95180','91630','94600','95130','91730','91910','78740','95610','94140','94290','78250','91580','78125','78740','91700','94220','93800','78113','94480','92390','93450','78930','91350','95210','95218','94160','91270','78250','78820','78550','78250','95480','95120','94700','91630','78440','78790','78125','91210','91630','95490','78660','91410','95000','95800','95130','93310','91730','78125','93200','93210','93170','78125','95450','91410','95250','78440','95880','91630','78550','93300','93120','78790','78250','28230','78125','78930','78930','91070','78790','93500','28230','94300','78550','94190','78930','91730','78790','91130','91000','95230','93430','91560','78113','78660','91580','78910','93100','78113','91230','78930','91410','95650','78200','94410','91080','95600','78440','78660','94000','78550','94460','95300','95320','93260','93230','95450','95450','95310','91580','78711','95360','78200','94340','95580','95580','78910','95150','95550','78250','95170','78520','78550','95390','78113','28320','91510','91510','93240','78790','28410','78660','94380','93380','91810','94450','28210','91450','78440','95680','78440','95650','95410','78200','95520','91410','91870','78200','93350','78200','28130','91090','95300','94130','93000','78200','78111','95160','91090','91000','91850','91770','95450','91410','28410','78440','28700','78440','78910','94120','95740','93130','28210','91710','94210','94340','94100','28410','93440','91330','78200','78440','28700','95430','91580','93110','28130','91540','28320','93140','91800','28210','91450','91150','95840','78660','95650','95650','95650','78660','95450','78790','94170','28410','91760','94470','95450','95540','95350','94430','78660','93150','93700','78980','28320','91410','95140','78200','95560','94500','95450','91150','78790','28210','78200','91540','78440','95350','78520','94360','28210','95840','95400','95200','95450','93250','28560','28260','94380','94370','91860','28410','78200','95500','91100','91540','91540','95330','78980','78440','28700','78200','91580','95400','91250','95570','78440','28320','94440','93360','91410','91780','91780','95630','95430','95450','91610','91150','91250','95300','95450','91410','78200','28700','91590','28210','95300','28560','93330','95440','28130','91800','28410','91100','94880','94880','94490','28410','95510','28700','91150','94440','91590','91280','28130','28320','91480','78980','93340','93320','95460','78520','95570','94350','94520','94520','95560','93220','28130','95500','28210','28210','95830','28130','91250','91780','95810','95830','95450','95760','95570','78710','91590','91750','28500','28410','95510','95560','91590','94420','28260','94440','28210','95450','95590','91590','78200','95420','95450','91480','95510','28130','28700','28130','95450','93160','28210','28700','28410','94510','95720','78520','28700','28500','28700','93460','28210','77380','77127','77170','91590','95810','95720','93600','95560','91250','91830','28130','28700','95500','28260','78980','93270','95620','28700','95640','95810','95640','28700','78270','95780','95420','95420','28700','28260','93190','93390','91750','95720','91590','95290','78270','95690','95640','91150','93370','78980','95500','91880','91830','77340','28700','95190','78270','28210','28500','95690','91590','28260','28260','28260','77420','95640','91740','95810','78980','78840','95720','95640','93420','95570','95810','95420','28130','95450','77150','28700','28260','28210','95510','77184','28130','93410','91740','77185','28500','27540','77500','95690','28700','95510','95270','95590','77181','93470','95270','95690','95660','95420','28700','77170','95190','95700','28570','95750','27640','28500','77150','77176','28210','91820','95260','95780','91150','78270','28500','95850','91890','95640','95640','91820','95420','95260','78840','28700','91690','77550','91690','77186','78980','28260','77240','93290','95270','28130','95750','28700','28300','91150','95190','95590','78270','95380','91690','28700','77680','91750','28700','28500','28300','77310','95420','95780','77177','77181','77166','78270','28700','95340','78270','28260','77200','77176','78270','28700','91150','95270','91720','95640','91930','95420','60240','95810','91740','77330','95420','95340','95510','28210','77360','27530','77270','27730','95850','95710','28500','95810','77550','28700','28310','77173','28500','95380','91150','28700','95420','95420','95270','91690','28700','77090','77183','27780','91840','77310','91690','28700','77240','60230','28300','95270','60240','27620','78270','91150','77166','91720','95270','91490','60240','28170','78270','95270','27630','95270','95270','28700','95380','77310','28300','77410','27620','60119','60119','91720','78270','78270','95380','28210','60240','77240','28500','91490','77600','95420','95340','60110','60240','28310','91150','95270','27750','77930','60240','95270','27730','28500','77400','27120','91490','78270','28700','27710','77135','77290','95670','28100','77350','95820','95710','95380','91690','28700','27640','28500','28310','28300','77400','77930','28520','28520','77550','91150','77111','95710','27620','95470','77164','77600','28630','77600','60530','77990','27730','77990','60540','60540') 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<>'582899' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

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

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

  33. 0.0002

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

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

  35. 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)

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

  37. 0.0001

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

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

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

  41. 0.0001

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

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

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

  45. 0.0001

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

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

  47. 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)

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

  49. 0.0001

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

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

  51. 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)

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

  53. 0.0001

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

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

  55. 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)

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

  57. 0.0001

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

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

  59. 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)

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

  61. 0.0001

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

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

  63. 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)

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

  65. 0.0001

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

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

  67. 0.0001

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

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

  69. 0.0001

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

  70. 0.0001

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

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

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

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

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

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

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

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

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

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

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

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

  83. 0.0016

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

  84. 0.0249

    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'

  85. 0.018

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

85 requetes sql en 0.0747

Taille variable Globale : 63.71 KB