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 à  la personne (3h)

Autres annonces du voisin

Tout voir
Service aide menagere

Il y a + de 30j

Il y a + de 30j

Aide menagere

10€/heure

Pont-l'Évêque
Location motobineuse

Demande il y a + de 30j

Il y a + de 30j

Recherche motoculteur et ou motobineuse

49€/jour

Blangy-le-Chateau

Annonces similaires

Tout voir
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide à la personne

-- €

Tourlaville
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide au repassage

12€/heure

Croisilles
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide menagere

15€/heure

Bolbec
Service aide personne

Il y a + de 30j

Il y a + de 30j

Auxiliaire de vie sociale

12€/heure

Jumieges
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide à la personne

15€/heure

Barneville-Carteret
Service aide personne

Il y a + de 30j

Il y a + de 30j

Aide et service à domicile (2h)

60€

Rogerville
Service aide personne

Il y a + de 30j

Il y a + de 30j

Aide et service à domicile (2h)

60€

Rogerville
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide à domicile

14€/heure

Rouge-Perriers
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Repassage

9€/heure

Mondeville
Service aide personne

Il y a + de 30j

Il y a + de 30j

Repassage, courses repas

10€/heure

Saint-Martin-de-Fontenay

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

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

  12. 0.0001

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

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

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

  17. 0.0001

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

  19. 0

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

  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='134640' AND wish_id<>'332446' 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='1080' 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=134640 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 = 134640

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

  28. 0.0002

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

  29. 0.0002

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

  30. 0.0212

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.2667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.2667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((0.216667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.817039197041 AND ville_latitude_deg<49.716360802959 AND ville_longitude_deg>-0.47243430430598 AND ville_longitude_deg<0.90576830430598 HAVING distance <= 50 ORDER BY distance ASC

  31. 0.0069

    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 ('14130','14130','14130','14130','14130','14130','14130','14130','14130','14130','14130','14130','14130','14130','14130','14390','14130','14130','14130','14130','14130','14130','14130','14950','14130','14950','14100','14130','14130','14800','14130','14800','14340','14340','14100','14600','14130','14130','14130','14340','14100','14590','14800','14430','14950','14800','14340','27210','14100','50270','27260','14430','14600','14100','14800','27210','14340','14590','14800','27260','14340','14950','27260','14800','50270','14100','14100','27210','14340','27210','14430','27260','14600','14430','14340','14590','14340','27260','14910','14800','14430','14360','14100','14600','14340','27210','14600','14100','14340','14340','14590','27260','14113','14340','14430','14600','14113','27210','14640','14910','14340','27210','27210','14340','14100','14100','14600','14600','14430','27260','27210','14100','14600','14340','14640','27260','27230','27260','14430','14340','14430','27500','27210','14100','14100','14510','14430','27210','27210','14100','14430','14100','50390','14640','27500','27230','14160','14340','14100','27260','14430','27560','14100','14100','14340','14100','27500','14430','27230','14100','14100','14140','14270','14340','14100','27210','27210','14510','27500','14430','14140','14340','27500','27210','27230','14430','14430','27210','27560','27560','27230','14290','14140','14340','14340','27230','14430','27500','27560','27230','27500','27230','14160','14160','14160','14290','14140','14140','14290','27500','14430','27680','14290','27560','27450','27560','14140','14140','14140','27680','27230','27230','27500','27500','27230','27230','27500','27560','14290','14140','27230','14270','27230','14140','14140','27450','14270','14290','27560','50250','76700','76700','14140','14140','76700','27300','14370','14370','27230','27560','76600','76620','76310','76430','76610','27230','14670','14670','14140','27450','14390','14290','27230','76430','27500','14670','27680','14370','76310','14140','14270','14140','27450','14390','76700','27230','76430','76430','27230','27800','14670','14140','14140','14140','27680','27680','27800','14370','14140','27500','27800','27300','14670','27300','14810','76430','14290','14860','27300','14140','14370','14170','27290','27300','76290','76430','76700','14270','27500','50260','76290','14140','76430','27450','27450','14170','27680','27450','14670','14810','76430','14290','27300','27800','14270','14170','27270','14140','14170','14170','27350','27680','14670','14290','14270','27290','76290','14140','14370','76430','14290','14140','27800','14270','14140','27300','27500','14290','76430','27290','27680','14290','14140','76930','14370','27300','14370','76430','27500','14170','27300','14290','50340','14121','27290','14860','27350','27500','76290','14940','14940','14940','27290','14860','27800','14850','76170','27270','14170','27350','76430','14270','14140','14140','76133','27680','27270','76133','27300','27800','14140','14140','14140','27800','27290','14150','27800','14630','27800','14860','76170','76430','14140','14270','14270','14850','27300','27500','27800','76170','14370','27270','76330','76430','76170','14290','14370','14170','27350','27290','76133','14290','27290','14140','61120','27500','76430','76280','27300','14370','76330','27300','27270','14140','27270','76430','27290','14970','14840','14630','14840','76210','14190','27290','14970','27270','27270','14630','27800','76110','14370','76330','27350','76170','27800','27800','27300','76210','27800','76133','76133','76290','76210','76280','61120','27350','14730','76330','14540','14880','76110','76930','14550','14270','14140','61470','76210','27290','27350','14460','50570','14170','14190','76210','14540','27550','14540','14170','76170','27520','14880','14170','14780','27800','27800','76280','61120','14190','61470','27390','76280','76280','61120','14200','27300','27290','61470','27350','14112','14190','76170','27270','76170','27270','14170','14170','27520','27290','76110','76110','76170','14170','76210','27410','27350','27310','14120','14540','76210','14170','27310','76170','14540','27800','27470','27520','14190','76280','61470','61120','76280','14540','27470','14190','61120','61120','14540','14540','27550','27390','14112','27520','14440','14440','27520','61120','14530','14620','27390','14170','14540','50440','27300','14190','61120','61470','14123','27410','76210','27390','27390','76210','27470','76110','61160','14170','76210','27170','76940','27410','14000','27800','76170','76490','50700','27520','14920','27410','50310','14620','76210','14620','27390','27800','27350','27310','27170','61120','61120','14830','27310','76280','27800','14610','76280','76490','76280','61120','76490','76110','76210','14190','14540','27800','76210','76110','27270','14170','27520','14440','14610','14680','27410','14610','50630','14123','27800','76210','27410','76110','76210','76490','76110','14620','50330','76280','27330','27170','27310','50210','76280','76280','76280','27890','14190','27370','61120','27390','61470','61160','14610','27520','27350','14190','14190','27170','76210','27520','27310','14610','14170','76190','14111','27520','27520','14280','14320','61160','76110','14750','76110','14420','14123','14320','14680','14190','27330','14280','76490','27410','14620','14620','14610','27170','14610','76110','27330','14620','14320','76110','27370','76790','76280','61120','27390','61160','14990','76940','27110','76940','61120','27110','14320','14680','76280','61160','14420','76640','76110','27310','14440','14420','76480','14700','61160','50110','14760','14620','14700','27370','76940','76110','76110','27310','76490','27410','76640','14280','76640','14190','14680','27390','76640','76940','61550','27390','27330','14320','76790','61230','61310','61160','61470','76790','14320','14930','14610','76640','14610','14610','76790','61230','61160','14700','76640','27520','14740','27370','76490','27330','14700','14700','27370','76580','61160','14470','76110','76400','76790','61230','27170','76110','76110','27170','27110','14930','27330','27310','76480','27310','14320','27110','76640','14650','61160','61550','14190','76400','76490','14700','76640','14620','27370','27670','76190','76490','27170','14470','61230','14220','27370','14740','27330','27410','27170','14980','76480') AND fami_id='3' AND cate_id='229' AND type_id='1' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='1020' AND wish_id<>'332446' 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=486370 AND note_visu IN (1,3,4)

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

  35. 0.0001

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

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

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

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

  43. 0.0001

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

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

  47. 0.0001

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

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

  50. 0.0001

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

  51. 0.0001

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

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

  55. 0.0001

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

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

  58. 0

    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

  59. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=388253 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 = 388253 AND W.type_id = 1) OR (W.util_id <> 388253 AND W.type_id = 2)) AND (M.post_util_id = 388253 OR M.dest_util_id = 388253) 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 = 388253

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

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

  70. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1020

  71. 0

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

  72. 0.0001

    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

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

  81. 0.0001

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

  83. 0.0001

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

  84. 0.001

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

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

  86. 0.0177

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

86 requetes sql en 0.0795

Taille variable Globale : 62.77 KB