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

Transport personnes à Beauvais (2h)

Annonces similaires

Tout voir
Service aide personne

Demande il y a + de 30j

Il y a + de 30j

Aide a la personne àgée (4h / weekend)

40€

Saint-Denis
Service aide personne

Demande il y a + de 30j

Il y a + de 30j

Recherche pâtissier(e)

20€/heure

Athis-Mons
Service aide personne

Demande il y a + de 30j

Il y a + de 30j

Service : Autre service

30€/heure

Paris
Service aide personne

Demande il y a + de 30j

Il y a + de 30j

Besoin d'une auxilliaire de vie pour 8h/

80€

L'Hay-les-Roses
Service aide personne

Demande il y a + de 30j

Il y a + de 30j

Petite soudure tuyau en cuivre

20€/heure

3/5 Evry
Service aide personne

Demande il y a + de 30j

Il y a + de 30j

Demande repassage a domicile 78

20€/heure

Aulnay-sur-Mauldre
Service aide personne

Demande il y a + de 30j

Il y a + de 30j

Ménage Mobil-home 30m2

15€/heure

Fontenay-aux-Roses
Service aide personne

Demande il y a + de 30j

Il y a + de 30j

Aide à la personne (5h)

100€

Nogent-sur-Marne
Service aide personne

Demande il y a + de 30j

Il y a + de 30j

Aide pour personne dépendante Août 2024

17€/heure

Bois-le-Roi
Service aide personne

Demande il y a + de 30j

Il y a + de 30j

Problème prise électrique

30€/heure

Clichy

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

  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

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'

  12. 0.0001

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

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

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

  17. 0.0001

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

  19. 0

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

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

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

  24. 0.0001

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

  25. 0.0077

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.7833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.333639197041 AND ville_latitude_deg<49.232960802959 AND ville_longitude_deg>1.317560395336 AND ville_longitude_deg<2.682439604664 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0057

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

  27. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1020' LIMIT 0,1

  28. 0.0001

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

  29. 0.0001

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

  30. 0.0001

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

  31. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1020' LIMIT 0,1

  32. 0.0001

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

  33. 0.0002

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

  34. 0.0002

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

  35. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1020' LIMIT 0,1

  36. 0.0001

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

  37. 0.0002

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

  38. 0.0002

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

  39. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1020' LIMIT 0,1

  40. 0.0001

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

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

  42. 0.0002

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

  43. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1020' LIMIT 0,1

  44. 0.0001

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

  45. 0.0001

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

  46. 0.0001

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

  47. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1020' LIMIT 0,1

  48. 0.0001

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

  49. 0.0001

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

  50. 0.0001

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

  51. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1020' LIMIT 0,1

  52. 0.0001

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

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

  54. 0.0001

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

  55. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1020' LIMIT 0,1

  56. 0.0001

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

  57. 0.0001

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

  58. 0.0002

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

  59. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1020' LIMIT 0,1

  60. 0.0001

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

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

  62. 0.0002

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

  63. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1020' LIMIT 0,1

  64. 0.0001

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

  65. 0.0001

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

  66. 0.0001

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

  67. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1020

  68. 0

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

  69. 0.0002

    SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='3' AND cate_cate_id IS NULL ORDER BY cate_order ASC

  70. 0.0002

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

  71. 0.0001

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

  72. 0.0001

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

  73. 0.0001

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

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

  75. 0.0001

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

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

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

  78. 0.0001

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

  79. 0.0001

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

  80. 0.0001

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

  81. 0.0009

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

  82. 0.0277

    SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'

  83. 0.0174

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

83 requetes sql en 0.0688

Taille variable Globale : 63.17 KB