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 a la personne

Autres annonces du voisin

Tout voir
Service repassage

Il y a + de 30j

Il y a + de 30j

Repassage à  mon domicile

13€/heure

Rainneville
Service menage

Il y a + de 30j

Il y a + de 30j

Menage : toutes taches ménagères

15€/heure

Rainneville

Annonces similaires

Tout voir
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service d aide a la personne

20€/heure

Rivery
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide aux seniors

11€/heure

Beaurains
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide à la personne

20€/heure

Ailly-sur-Noye
Service aide personne

Il y a + de 30j

Il y a + de 30j

Repassage de paniers

20€/heure

Warsy
Service aide personne

Il y a + de 30j

Il y a + de 30j

Entretien de votre intérieur

20€/heure

Abbeville
Service aide personne

Il y a + de 30j

Il y a + de 30j

Repassage à domicile

12€/heure

Amiens
Service aide personne

Il y a + de 30j

Il y a + de 30j

Bricolage,petites réparations,transport.

20€/heure

Gamaches
Service aide personne

Il y a + de 30j

Il y a + de 30j

Prendre soin

20€/heure

Amiens
Service aide personne

Il y a + de 30j

Il y a + de 30j

Aide personne

20€/heure

Amiens
Service aide personne

Il y a + de 30j

Il y a + de 30j

Aide multiple

10€/heure

Amiens

Demande un service d'aide a la personne entre voisins ou proposer mes services d'aide 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.0006

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='aide-personne' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='1020'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'aide-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='80'

  12. 0.0001

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

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1020 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  18. 0.0001

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

  19. 0

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

  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='48770' AND wish_id<>'265743' 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='938' 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=48770 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 = 48770

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

  28. 0.0003

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

  29. 0.0002

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

  30. 0.0197

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.28333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.517039197041 AND ville_latitude_deg<50.416360802959 AND ville_longitude_deg>1.5842588806145 AND ville_longitude_deg<2.9824011193855 HAVING distance <= 50 ORDER BY distance ASC

  31. 0.0123

    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 ('80260','80260','80260','80260','80260','80260','80260','80260','80260','80310','80470','80136','80260','80730','80730','80470','80260','80260','80000','80080','80090','80670','80260','80470','80470','80650','80670','80260','80260','80260','80260','80480','80310','80310','80260','80115','80470','80670','80730','80450','80310','80260','80260','80670','80260','80480','80480','80670','80450','80310','80260','80260','80260','80800','80330','80330','80850','80115','80480','80610','80670','80560','80440','80670','80540','80440','80310','80610','80560','80800','80780','80540','80480','80800','80560','80560','80440','80750','80680','80310','80800','80630','80480','80420','80420','80310','80600','80540','80600','80540','80800','80310','80310','80540','80800','80620','80800','80310','80680','80620','80480','80750','80300','80310','80800','80800','80540','80160','80300','80310','80540','80380','80440','80600','80113','80560','80540','80690','80560','80540','80620','80560','80540','80680','80600','80370','80680','80600','80620','80620','80370','62760','80620','80380','80830','80800','80600','80160','80160','80160','80830','80370','62760','80110','80890','80440','80800','80800','80560','80690','80560','80380','80560','80800','80370','62760','80113','80300','80680','62760','80600','80160','80620','80300','80600','80250','80160','80600','80540','80560','80540','80620','80110','80250','80110','80560','80300','80300','80270','80300','80300','80250','80300','80710','80110','80370','80370','62760','80160','80440','80690','80690','80690','80510','80290','80800','80600','80160','80600','80560','80560','80800','80710','80600','80510','62760','80270','80540','80110','80560','80370','80560','80800','80620','80620','80560','80110','80370','80270','80560','80300','80690','80720','80290','80110','62760','80250','80160','80600','80270','80300','80300','80270','80250','62760','80800','80250','80510','80640','80300','80135','80540','80300','80600','80160','80720','80560','80540','80270','80135','80560','80290','80110','80370','62760','80160','62760','80370','62760','80600','80600','80600','80560','80160','80510','80250','80290','80800','80370','80370','80370','80110','80110','80300','80270','80370','80490','80270','80800','80160','80110','80370','80135','80560','62760','62760','62760','80560','80290','80110','62111','80560','80170','80250','80690','80170','80270','80135','80160','80160','80810','80370','80600','80160','62270','80580','80300','80640','80340','80110','80300','80370','80600','80132','80720','80270','80170','80580','80300','80340','62810','80370','80490','80300','80160','80600','62111','80340','80600','80110','80140','80132','80300','62390','80290','80370','62158','80290','80110','80250','80250','80250','80160','62760','80110','62390','80160','80250','80580','62111','62760','80126','80290','80640','80135','80290','62158','80300','80131','80135','80300','80640','62390','60120','80580','60120','80140','80290','62810','80160','80250','80250','80150','80110','80160','80110','80110','80490','62111','80170','80300','80300','80270','80270','80640','80121','80340','80340','80160','80110','80290','80150','80140','62810','62270','62270','60120','80580','80490','80300','62390','80160','62390','80250','62111','80270','80132','80150','62158','80490','80580','80290','80150','62810','62158','80131','62111','80250','80118','80300','62810','80131','80290','62111','80140','80132','80340','80160','80500','80134','80590','62270','80140','80300','62810','60120','62111','80160','80140','80300','80490','80300','80150','62158','62158','62270','62270','62270','80500','80500','80490','80140','80150','80340','62270','80132','80132','80140','62116','80135','80250','80590','60120','80590','80340','80150','62390','80140','62390','62390','62810','80140','80250','80340','80500','62390','60360','80430','80290','80290','80290','60210','80140','62116','80250','80150','60210','80250','80300','80170','60120','80170','62270','62450','80300','80140','80170','62270','80132','80100','80300','60120','62810','60120','80290','62270','60120','60120','80132','80360','80140','80500','80150','80430','80340','80150','62158','80300','60210','80340','62390','62123','80132','80590','62810','80132','80140','80590','80170','60360','80430','80140','80300','80290','62111','80300','60120','80140','80170','80340','62123','80500','80340','62390','62810','62810','60210','80500','80150','60210','80500','80910','80140','80140','62270','60120','80140','62270','62270','80140','62810','60360','80170','80590','60120','62121','80140','80150','80500','62270','62123','60120','62450','62810','80910','80430','80200','60210','62270','62810','80500','62390','62270','80360','62390','80500','80980','80430','80132','60360','62116','62123','80320','80500','62116','80430','80200','80360','80590','80500','80360','80590','80170','62270','62116','60120','80340','80150','60360','80320','62810','80140','62810','60120','80150','80150','62123','80430','80500','80170','60360','60120','60120','62270','80500','62810','80132','62116','62270','62270','80590','60120','62130','80870','80360','80430','80200','62390','80360','80140','80360','62121','62140','62810','80140','80140','62123','62123','62130','60120','60120','60210','80150','80500','80290','80360','80140','80140','80500','62770','62270','62173','80870','80140','80360','62390','80132','62127','80200','80150','62390','62810','80170','80170','80132','62121','62450','80430','80360','80500','80132','80200','80430','80320','62810','80500','80500','62127','62130','62130','80700','60120','62450','60120','80200','80150','62123','80500','62127','80320','60360','62173','80700','80140','60360','62140','62130','62810','60210','80590','60210','62175','62121','62450','60120','60420','80210','62173','62450','62127','80140','80200','62810','80700','80140','80140','80500','60210','80140','60220','60210','60210','60480','80140','62127','80870','62450','62121','76340','80140','80132','62121','80200','80360','80430','80200','62130','62770','62770','80700','60220','80700','80150','62175','80320','80700','62450','80360','62140','62123','80140','60360','60120','80150','62130','60480','62130','62130','62130','62130','60480','80320','62140','62690','80500','60480','60120','80140','80140','60210','80700','80200','62270','60480','80132','62450','62123','62450','62175','80132','62127','76390','62130','60360','60210','62140','80320','62123','62121','62121','60210','60120','60210','80210','80320','80320','62770','60480','60120','62173','80320','80132','62450','80700','80700','62217','80500','62127','80200','60210','80500','62140','62140','62123','62123','80970','60360','62175','60210','60220','76390','62127','60220','80700','60360','80210','80200','62690','80140','60220','80700','80700','76340','80140','62130','60480','80230','62130','60420','60420','62123','62130','76390','62123','60480','62130','76340','62450','80700','62450','62770','62127','62690','60360','80320','62130','62121','80500','62121','80700','60120','80150','62159','80200','62450','80150','60420','60210','80360','76390','80860','80500','80320','62140','62140','76340','80200','60360','60690','60420','80500','80200','62770','60120','62130','80700','60420','80220','80360','62770','80132','62450','60480','62127','62161','62128','62175','62690','80700','62450','80200','80150','80190','62130','62770','60480','62130','80700','60220','62130','80220','76390','60480','76340','80210','76340','80220','80200','62140','62690','60420','62130','62127','60130','60420','60420','62161','80320','62000','62140','80500','60960','62770','62450','80860','62128','60480','62450','62128','80700','60690','60690','60220','60210','62770','62127','62217','60130','80190','80230','60220','80700','80200','62140','62140','80150','60220','80210','60210','80500','80220','80200','80200','80200','62124','60420','80210','62144','80700','60360','60130','60690','76390','62140','62690','80150','62217','62217','80220','62690','80700','62770','62130','62130','62124','80210','62690','80360','60480','76340','62140','80700','60220','62130','62130','80150','60210','60480','80190','62770','62130','62144','62690','62140','62217','62690','62159','60860','62130','80760','62161','62161','76390','80190','80200','80860','60420','62128','60380','80200','76390','80700','80700','60860','80190','62124','62127','80700','80210','80120','60480','62690','62217','60420','80700','80190','62128','62140','60130','62124','62870','80200','60220','80210','60220','62770','60220','80700','62144','76340','80200') AND fami_id='3' AND cate_id='229' AND type_id='1' AND ssrubr_id='1020' AND wish_id<>'265743' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

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

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

  35. 0.0003

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

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

  37. 0.0001

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

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

  39. 0.0002

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

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

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

  43. 0.0003

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

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

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

  50. 0.0004

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

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

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

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

  63. 0.0001

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

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

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

  67. 0.0001

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

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

  71. 0.0001

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

  72. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1020

  73. 0.0001

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

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

  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 (50) 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 (38) 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 (45) 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 (231) 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 (47) ORDER BY ssrubr_order ASC

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

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

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

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

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

  86. 0.0016

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

  87. 0.0332

    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'

  88. 0.0211

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

88 requetes sql en 0.1001

Taille variable Globale : 63.64 KB