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

Repassage à mon domicile

Annonces similaires

Tout voir
Service aide personne

Il y a + de 30j

Il y a + de 30j

Aide aux seniors (2h)

40€

Aubergenville
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide à la personne

20€/heure

Mantes-la-Ville
Service aide personne

Il y a + de 30j

Il y a + de 30j

Aide aux courses & services à la personn

20€/heure

Cergy
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide à domicile

13€/heure

Evreux
Service aide personne

Il y a + de 30j

Il y a + de 30j

Besoin d'aide a la personne

20€/heure

Vernon
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Infirmière

20€/heure

Vernon
Service aide personne

Il y a + de 30j

Il y a + de 30j

Garde personnes âgées ou enfants de nuit

15€/heure

Ymare
Service aide personne
4,2/5 résa

Il y a + de 30j

Il y a + de 30j

Service : 24/24 7/7

25€/heure

Nogent-le-Roi
Service aide personne

Il y a + de 30j

Il y a + de 30j

Aide au ménage et cuisine

20€/heure

Dreux
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Rend servis

10€/heure

Evreux

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

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

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

  12. 0.0001

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

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

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

  17. 0.0001

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

  19. 0

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

  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='251470' AND wish_id<>'426838' 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='27120'

  25. 0.0154

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.05*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.05*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.600339197041 AND ville_latitude_deg<49.499660802959 AND ville_longitude_deg>0.63057707697713 AND ville_longitude_deg<2.0027629230229 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0092

    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 ('27120','27120','27120','27120','27120','27120','27120','27120','27120','27120','27930','27120','27930','27930','27120','27600','27950','27490','27120','27950','27950','27490','27930','27930','27950','27120','27930','27950','27930','27120','27930','27930','27950','27120','27930','27120','27490','27120','27930','27120','27930','27120','27600','27920','27220','27920','27120','27930','27490','27120','27930','27120','27930','27640','27220','27940','27950','27600','27220','27950','27220','27220','27930','27490','27220','78270','27950','27930','27120','27640','27600','27930','27930','27200','78270','27000','27930','27930','27600','27220','27600','27510','27600','27220','27600','78270','27220','27940','27730','27930','27220','27220','27400','27940','27730','27600','27940','27930','27930','78270','78270','27620','27180','27930','27400','78270','27730','27400','78980','27180','27400','27220','27940','27940','27220','27220','78270','27930','27220','27780','78270','27400','27400','27510','27400','27640','27180','27620','27220','27750','27180','27240','27400','27930','27180','78270','27700','27240','78980','27430','27930','27510','27110','27700','27700','27400','27510','27400','78980','27700','78270','27620','27930','28260','27180','27630','27180','27220','27220','78980','27700','27220','27400','78840','27220','27400','28260','27220','78270','27180','27620','27180','27430','27190','27700','27400','27540','78200','27430','27530','27180','27240','28260','78270','27220','27700','27110','27220','27700','27240','27240','27430','27430','27400','27510','27110','27400','27110','27430','27400','28260','27190','27190','28260','78270','27630','27110','95780','78520','27430','27700','27100','28260','78200','78710','27190','28260','78980','27430','27110','78270','28520','28520','27190','27240','78980','27630','27180','27720','27190','27400','78200','27240','28260','27320','27110','95510','27400','27510','27320','27700','27630','27110','27630','27110','78200','78980','27190','27510','78840','27510','95780','27400','27700','95710','78200','27190','27320','27430','27810','27100','27100','27770','28260','78790','27630','27190','27420','27400','27700','78200','27190','27110','27190','78200','27190','27370','50680','78790','27690','95510','27110','28560','27240','27190','27110','27630','78111','78200','95710','27190','27650','27110','78200','27440','27420','95780','78520','28260','28560','27590','27710','27340','27240','27420','27700','27190','27740','78200','27110','27110','27700','78790','27370','14380','27240','27420','27370','27240','27150','27190','78520','27340','27190','27630','78200','78910','27240','27420','27380','27190','27420','27190','27420','27380','27340','27440','78910','95710','78200','27150','27590','27420','27320','27150','95510','27170','27110','27420','78790','95770','27110','95420','27240','78790','78790','78200','78711','78930','27370','27110','78910','78930','78930','27440','27460','95510','28570','28410','76320','27150','27370','27110','27460','78930','27110','78520','95770','95770','28500','27380','27650','78790','27110','27650','27440','27170','95510','78440','27870','27370','27360','27320','28500','27610','28410','78550','28380','27320','27340','27370','27460','27170','27170','27240','27440','28350','22870','27240','27370','27720','27370','27150','76410','27160','27320','27160','27190','27110','27170','78440','95420','27190','27150','78930','76320','27110','27340','27150','27380','27380','27110','27370','28410','78910','95420','28350','28410','27370','95510','78440','76410','27370','27150','78440','76520','28500','95420','27170','95420','27170','78440','27190','78550','27370','27150','78790','60240','27110','95420','27370','27440','78790','76500','78790','76520','28410','27170','27110','76520','27370','27440','76350','76410','95420','95420','27570','78440','28500','78930','27380','27150','76410','27160','28500','78550','28100','27850','76520','28500','27380','78910','27720','28500','76520','95420','27570','28410','27150','27370','78910','78930','76410','27570','78550','27160','27790','27570','28410','28410','27170','27190','78970','78440','27170','27370','27370','27150','78440','27160','76520','78440','27150','76500','27110','78910','27110','28500','27380','78580','27670','28500','50410','27380','60240','27370','28500','95420','27370','78440','76500','78910','78770','28270','27370','28500','78550','27160','76520','28500','95420','78680','27190','27160','28500','78550','27760','27410','60240','27160','28270','27370','27160','60240','27370','27160','78910','60240','78440','78250','60240','27910','28500','28500','27170','27670','27150','76520','28410','78820','27890','78410','78410','27660','27660','28270','28270','27170','27410','78770','27800','27130','27830','27670','95450','95420','78410','95450','28500','28270','95450','95450','27170','76800','76520','28270','27800','27480','60240','28500','95450','27410','27860','76530','78950','78770','76240','28500','76520','28270','27160','78890','95420','78770','27160','27910','78126','76520','27170','27330','78410','78940','27150','27410','27130','28270','78250','76920','27800','27170','78580','78770','78770','27150','27800','76530','27480','27520','78113','60240','27370','28500','78250','27160','78580','76160','27130','28270','28210','76240','27520','76116','60240','27910','28500','95450','78250','27150','28500','27140','95750','76113','27800','28500','76650','27470','27140','76160','27910','78250','27480','28210','27480','28210','27910','78940','78113','27550','95450','27330','27800','76160','27480','76113','76530','78124','78113','78410','27520','76380','60240','60240','76300','78770','78490','60240','78250','27410','27330','28210','27470','78113','60240','78130','27150','27480','27140','78124','27150','78490','76160','95450','78113','78580','27330','76160','76240','95640','78113','28210','28270','60240','27910','28170','78650','27520','28210','27520','27150','78490','27300','60240','95450','27410','27130','28270','60590','28210','27550','28170','27470','95450','27480','78920','78490','27160','28210','95450','27520','14450','60590','27520','76120','27150','27290','78490','50570','76000','76100','27310','78650','78130','27520','27520','27800','27800','76780','28270','76160','95450','95450','78580','27410','78740','27330','28170','28210','76116','27310','76116','28170','50800','60590','60590','27800','60590','95750','27800','76780','27800','27480','78630','27130','27310','95640','95640','78490','78490','28210','76780','27250','28210','28210','76140','76160','27130','27330','27300','27410','78125','78740','27310','76160','28210','27520','95450','60590','60240','27520','78640','27150','60590','27140','76113','27310','60240','28170','27330','28270','60240','27800','76116','76230','27300','76116','27580','76116','22680','28170','60240','76420','76220','76780','76530','27520','78121','76840','27330','95450','76160','95180','27410','78640','76780','78640','27250','28210','78490','78490','76380','27800','78125','27300','78850','76160','78480','50370','27290','60590','27310','76130','27290','78810','78540','78610','27800','28210','28270','50370','60240','27310','95640','27330','27800','95800','27290','60240','27250','78640','95650','95650','78490','60590','95000') AND fami_id='3' AND cate_id='229' AND type_id='1' AND ssrubr_id='1020' AND wish_id<>'426838' 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=537848 AND note_visu IN (1,3,4)

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

  30. 0.0002

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

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

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

  34. 0.0001

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

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

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

  38. 0.0001

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

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

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

  42. 0.0001

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

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

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

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

  50. 0.0001

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

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

  52. 0.0001

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

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

  54. 0.0001

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

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

  56. 0.0001

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

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

  58. 0.0001

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

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

  60. 0.0001

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

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

  62. 0.0001

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

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

  64. 0.0001

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

  65. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1020

  66. 0

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

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

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

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

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

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

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

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

  79. 0.001

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

  80. 0.0238

    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'

  81. 0.0165

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

81 requetes sql en 0.0744

Taille variable Globale : 62.29 KB