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

Annonces similaires

Tout voir
Service service a personne

Il y a + de 30j

Il y a + de 30j

Aide handicap/ visite domicile /aide div

12€/heure

Boves
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Repassage

50€/heure

Pas-en-Artois
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Propose mon aide

50€/heure

Amiens
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Propose mon aide

50€/heure

Amiens
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Travaux couture

-- €

Amiens
Service service a personne

Il y a + de 30j

Il y a + de 30j

Aide à domicile/ nounou/ aide aux devoir

10€/heure

Amiens
Service service a personne

Il y a + de 30j

Il y a + de 30j

électricien confirmé

20€/heure

Maignelay-Montigny
Service service a personne

Il y a + de 30j

Il y a + de 30j

Repassage à mon domicile

15€/heure

Suzoy
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Repasse et couture

15€/heure

Suzoy
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Aide a la personne

25€/heure

Rivery

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

    SHOW TABLES LIKE 'pays'

  3. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  4. 0.0004

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

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

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

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

  8. 0.0015

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

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

  10. 0.0002

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('80' USING utf8mb4) COLLATE utf8mb4_general_ci

  11. 0.0001

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

  12. 0.0002

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

  13. 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 = 268942

  14. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1092 LIMIT 1

  15. 0.0002

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

  16. 0.0001

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

  17. 0.0001

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

  18. 0.0001

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

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

  20. 0.0001

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

  21. 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 = '268942'

  22. 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='52201' AND wish_id<>'268942' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  23. 0.0001

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

  24. 0.0198

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.7939*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.7939*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.75445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.344239197041 AND ville_latitude_deg<50.243560802959 AND ville_longitude_deg>2.0578764113489 AND ville_longitude_deg<3.4510235886511 HAVING distance <= 50 ORDER BY distance ASC

  25. 0.0169

    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 ('80170','80170','80170','80320','80170','80700','80320','80700','80170','80170','80320','80320','80700','80700','80170','80700','80320','80320','80170','80320','80340','80320','80700','80700','80170','80320','80700','80910','80131','80700','80190','80170','80170','80131','80200','80320','80190','80700','80700','80131','80700','80340','80200','80320','80500','80910','80320','80320','80118','80200','80190','80700','80700','80190','80700','80200','80121','80170','80700','80190','80200','80700','80720','80700','80190','80170','80700','80190','80340','80170','80700','80340','80340','80190','80190','80200','80134','80500','80110','80200','80200','80340','80190','80110','80500','80200','80980','80200','80700','80340','80700','80200','80340','60310','80190','80700','80190','80190','80720','80700','80800','80700','80190','80500','80190','80190','80700','80200','60310','80110','80700','80720','80110','80500','80800','80500','80500','80110','80190','80200','80200','80110','80400','80190','80800','80340','80200','80340','80340','80200','80110','80700','80700','80500','80340','60310','80340','80400','80190','80400','80930','80400','80400','80800','60310','80500','80500','80110','80500','80340','80500','80400','80200','80800','80400','80400','80700','60310','80200','80500','80700','80110','60310','80200','80110','80800','60640','80400','80500','80400','80200','80500','80380','80500','80500','80360','80200','80300','80110','80200','80110','80110','80360','80800','60310','80300','80500','80800','80800','80360','80400','80500','80200','60310','80400','80200','80380','80200','80110','80500','80400','80110','80500','80300','80300','80300','80500','80110','60310','80400','80360','60490','80300','60640','80200','80800','60490','80110','60640','60310','80360','60310','80113','80810','80250','80200','60640','80400','80200','80110','80400','80500','60640','80380','80800','80800','80300','80800','60310','80300','80400','80300','80250','80800','80110','60490','80300','80500','80110','80200','80500','80200','80400','60310','60490','80113','60310','60490','80200','60640','80200','80500','80800','02590','80200','60310','80300','60400','60420','60490','60400','80200','80300','60310','80250','60640','80500','80240','80250','80440','80500','80240','60640','80800','80300','02590','60400','02590','02590','80300','60310','60490','02480','80240','80360','60420','80500','80440','80300','60310','60310','80360','80760','80300','80360','02590','02590','80360','80800','02490','02490','80500','80440','02590','60640','80240','80400','80250','80240','80500','60420','80800','60640','80300','60640','62450','80300','80440','80250','80300','80440','80240','80300','60400','80800','80300','80115','60420','60420','80240','02480','60310','60490','80250','60490','60400','60420','80360','80240','60400','60490','02480','80440','80300','60310','60490','80250','80250','60490','60420','60420','62450','80360','80250','60400','60400','60420','60120','80250','80250','02590','80450','60420','02590','02590','02480','80300','02480','80240','80240','80300','80115','60640','80260','80360','02640','60400','60640','60640','60420','80360','80360','80260','60310','60120','02300','60120','60157','60400','80300','80250','02490','80240','60420','80260','80300','60490','80260','02640','80560','80560','80300','80360','80330','80330','60120','60400','80250','02490','80240','80240','80250','02480','80260','80260','80300','62450','02490','80250','80300','60400','60400','02300','60640','80450','60120','62450','02590','02480','60490','02480','60420','80250','02590','60490','60138','02480','02300','80250','62450','80240','80360','80240','60490','62450','60420','80560','80560','80680','80560','60400','80680','60420','60400','60420','60400','62124','80560','80300','02490','60400','62450','80112','80360','80560','80300','62450','60162','60162','60420','80300','02300','60490','62124','80240','80260','62124','60400','80300','02520','80240','60120','02680','60120','02790','60190','60400','02490','60150','60150','02490','62450','60420','80560','60150','60120','80260','60170','80680','80680','60170','80260','80360','80300','80300','60120','02760','60420','80122','80260','80560','62450','80136','60120','80240','60120','62450','60170','02680','02680','80560','60400','02680','60120','62450','60113','02300','02300','02300','60120','80260','62124','80000','80080','80090','60150','62450','80260','80560','60190','80260','60130','60190','02760','60190','80260','60400','60400','02440','62124','80260','80160','02490','60400','62450','02420','80560','80250','80250','60400','02480','80740','80480','02300','60150','80560','02420','02300','60130','62121','60120','62121','80560','62124','60170','60150','62116','62124','60170','80560','62450','80680','80160','02420','80740','02490','80260','60130','60420','60113','60113','60130','02100','62450','80160','60190','02300','02440','60150','60150','02300','60190','02680','80260','02430','80160','02100','62111','60190','62450','80480','80480','02300','60120','60120','62124','60150','62124','60170','60120','80560','62450','60130','80480','02300','02300','80560','80480','62124','62121','60130','60150','62121','80480','62111','80560','62116','80600','02420','02690','62124','60400','60120','62121','62121','60400','02700','60190','02700','02100','02420','62111','59231','60120','60190','02440','02440','80560','02300','60200','60200','80160','62111','80560','80260','80160','59297','60130','02440','02300','62124','80160','60150','60130','02420','60190','80560','60170','60120','62124','62159','02420','62116','80260','80560','80730','80730','80470','80160','80160','80160','60190','60190','80730','02300','62147','02700','62147','80160','60130','02440','60120','59231','62159','60190','02300','60480','80260','80560','62124','02420','60280','02690','60170','02300','60190','02100','02300','02440','60120','60190','02100','62760','80260','02420','80600','80160','80560','62147','02100','60750','80160','60480','02420','60130','02300','62116','60120','62121','02100','80470','62116','60130','60130','59266','02100','02300','02300','62111','62121','02240','60130','60130','02300','62760','62159','80470','60200','59231','62147','60120','80160','02420','60200','60120','80260','62111','02700','80480','60130','02420','60400','80470','62760','62111','60190','80540','62760','02420','60190','60190','02240','59266','02420','59159','80260','60480','02700','62147','80540','60120','60120','02720','80260','60130','62760','62128','02100','02100','02420','02300','62760','62121','60170','60120','62116','80160','62121','62760','62760','62760','02300','02800','02420','02300','60190','62111','80470','60130','60680','62128','60350','80160','80310','02300','59266','60480','60190','60480','02240','02610','60153','59267','60480','02720','02800','02800','60600','62111','60130','02700','02240','62128','62128','80670','60480','02110','62158','62860','60130','60600','62175','62175','62175','62175','60480','02240','62760','62760','80540','02240','02110','60600','02420','80600','62128','60130','02100','80630','62760','62147','60120','80540','60880','60880','60360','02300','60680','60680','80670','60360','02670','02110','62123','60350','80160','62128','62760','80540','60480','60190','02290','02800','02300','60480','60600','62760','62860','60350','02240','02800','60350','02700','02240','80290','02720','62860','62147','60350','80310','80310','60480','60190','60480','02670','62158','80650','02110','80600','02800','60600','80160','59258','60350','62173','62175','02700','62128','59159','80160','80160','60480','62182','59142','60190','60190','62173','59400','60600','80540','60130','62760','60350','02800','60880','02240','80540','60360','02240','60350','02700','02110','62123','80670','02800','02800','80540','62760','62123','02300','60680','60350','60350','80710','02110','62860','60510','60190','80670','80310','80310','62128','60360','60120','62158','02240','59241','80540','80670','60600','62173','62217','80160','02110','59159','80600','62182','62128','62173','62158','59258','02290','62128','60600','62158','62158','60480','59127','60480','02800','62860','59267','60480','60126','60610','62123','62123','60126','60480','62128','60600','80310','59127','80750','80600','62123','60710','80160','80670','60600','02110','02380','80670','62217','60710') AND fami_id='3' AND cate_id='229' AND type_id='1' AND ssrubr_id='1092' AND wish_id<>'268942' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

  27. 0.0001

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

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

  29. 0.0002

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

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

  32. 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 = 486873 AND W.type_id = 1) OR (W.util_id <> 486873 AND W.type_id = 2)) AND (M.post_util_id = 486873 OR M.dest_util_id = 486873) 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 = 486873

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

  37. 0.0002

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

  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 abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 495242

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

  41. 0.0001

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

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

  43. 0.0002

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

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

  47. 0.0002

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

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

  50. 0.0003

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

  51. 0.0002

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

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

  54. 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 = 134758 AND W.type_id = 1) OR (W.util_id <> 134758 AND W.type_id = 2)) AND (M.post_util_id = 134758 OR M.dest_util_id = 134758) 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 = 134758

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

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

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

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

  61. 0.0002

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

  62. 0.0001

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

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

  64. 0.0003

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (50) ORDER BY ssrubr_order ASC

  65. 0.0003

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (38) ORDER BY ssrubr_order ASC

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

  67. 0.0003

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (231) ORDER BY ssrubr_order ASC

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

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

  70. 0.0003

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (37) ORDER BY ssrubr_order ASC

  71. 0.0003

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (43) ORDER BY ssrubr_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 (39) ORDER BY ssrubr_order ASC

  73. 0.0005

    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

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

  75. 0.0017

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

  76. 0.0401

    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'

  77. 0.0256

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

77 requetes sql en 0.1473

Taille variable Globale : 61.22 KB