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

Service : Bien être

Autres annonces du voisin

Tout voir
Location table de massage

Il y a + de 30j

Il y a + de 30j

Table massage

-- €

Merville
Service service a personne

Il y a + de 30j

Il y a + de 30j

Massage égyptien Métamorphique

60€/heure

Merville
Location taille haie

Il y a + de 30j

Il y a + de 30j

Taille haie avec batterie

30€/jour

Merville
Location table de massage

Il y a + de 30j

Il y a + de 30j

Massage égyptien Métamorphique

80€/jour

Merville
Service aide personne

Demande il y a + de 30j

Il y a + de 30j

Disponible pour garde nuit

20€/heure

Merville

Annonces similaires

Tout voir
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Propose repassage

15€/heure

Bourg-Saint-Andéol
Service service a personne

Il y a + de 30j

Il y a + de 30j

Services divers aux voisins

20€/heure

Roubaix
Service service a personne

Il y a + de 30j

Il y a + de 30j

Services divers aux voisins

20€/heure

Roubaix
Service service a personne

Il y a + de 30j

Il y a + de 30j

Je propose des services diverses et vari

30€/heure

Lille
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Massage détente

50€/heure

5/5 Hazebrouck
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Repassage

12€/heure

Fressin
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Aide ménagère

-- €

Divion
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Femme de ménage

12€/heure

Cappelle-Brouck
Service service a personne

Il y a + de 30j

Il y a + de 30j

Blanchisserie repassage

-- €

Loos
Service service a personne

Il y a + de 30j

Il y a + de 30j

Service : Repassage

12€/heure

Fressin

Demande un service de service a la personne entre voisins ou proposer mes services de service a la personne.

Poster une annonce
Retour
Fermer

Services entre voisins

Lancez votre recherche pour voir les annonces.

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0002

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

  8. 0.0001

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

  9. 0.0001

    SELECT c.cate_id, c.cate_title, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='3' AND c.cate_id='229'

  10. 0.0001

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

  11. 0.0001

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

  12. 0

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

  13. 0.0001

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 597447

  14. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1092 LIMIT 1

  15. 0.0001

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

  16. 0.0001

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

  17. 0.0001

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

  18. 0

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

  19. 0.0002

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

  20. 0.0001

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

  21. 0.0001

    SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '597447'

  22. 0.0002

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

  23. 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='824' LIMIT 0,1

  24. 0.0001

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

  25. 0.0002

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

  26. 0.0001

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

  27. 0.0002

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

  28. 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='14' LIMIT 0,1

  29. 0.0001

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

  30. 0.0001

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

  31. 0.0001

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

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

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

  34. 0.0001

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

  35. 0.008

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.6333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.6333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.63333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.183639197041 AND ville_latitude_deg<51.082960802959 AND ville_longitude_deg>1.9243930963833 AND ville_longitude_deg<3.3422669036167 HAVING distance <= 50 ORDER BY distance ASC

  36. 0.0139

    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 ('59660','62350','59940','62136','59253','62350','59940','62350','62350','62350','62350','62136','59232','62232','62400','62136','59940','62920','59270','62840','62920','62400','59270','62840','62136','62350','62330','59190','62400','62232','62232','59189','59190','62149','59190','59190','59189','62840','59270','62920','59181','62840','62190','62190','62232','59270','62330','59270','62232','59190','62199','62660','59189','62122','62840','62157','62149','59249','62122','62131','62131','59173','62190','62196','62113','59190','62149','62138','62131','62113','62113','59249','59850','59480','62190','59114','59270','62149','62540','62151','59480','59193','62149','62120','62120','62620','62138','62290','59114','62120','62120','59190','62540','62190','62120','59134','59270','62120','62138','62980','59280','59134','59173','62190','62190','62700','59496','62120','59173','59134','62980','08951','59190','59280','59134','59270','59670','08950','62620','62940','59114','62120','59274','62260','62670','59299','62138','62120','62120','08958','07783','59930','62260','59670','62470','59114','59173','62260','59496','08954','62260','59320','62120','62120','07782','62120','59134','62145','59670','62620','62470','62530','62550','62114','62620','08950','62460','08952','62550','62138','62190','59184','62410','62120','59320','59320','62120','59116','59136','59670','08956','62160','62150','59173','62120','62410','62550','62550','59221','62150','62120','62960','62960','59272','59320','59840','08970','62150','59670','62410','62550','59211','62550','62550','59670','62750','62460','59670','62160','62145','62410','59236','62120','59320','59670','62550','59320','59160','62120','59670','08957','59840','59185','59112','62550','62530','62150','62172','62150','62550','62150','08953','62160','62129','59320','59670','62150','62880','59890','62129','62960','59320','59251','08900','08978','59147','62145','08970','62143','62550','62880','62880','62530','07784','59670','62145','62460','62575','59560','62800','62690','62550','59840','59320','59670','62150','62300','62150','59147','62960','59237','08902','62134','59112','59263','07784','59285','62129','62510','59147','59120','62127','62550','62880','62129','62300','59890','62575','62127','62960','59139','62218','62221','62440','62500','62690','59470','59470','59133','08908','62130','62570','62690','59285','62144','59130','62690','62153','08972','08902','59470','62220','07781','62153','59350','62550','62960','62430','62960','62580','62550','62710','62129','62127','62210','07780','07780','62690','62570','59113','62144','59143','62134','59285','62570','59118','59139','62130','62740','62500','62134','59133','62690','08900','08900','59470','59470','08902','62219','59175','62960','62690','59160','59350','59000','59777','59800','62420','59110','62129','62640','62130','62680','62570','59560','08906','62134','59520','62590','62500','59155','62134','59470','62130','62130','59175','59470','62127','62690','62144','62690','08972','62690','62690','08640','08980','59122','08972','62127','62380','62380','62820','62500','62134','62144','62219','59700','62560','59143','62690','08900','62110','59551','62690','59470','62127','62580','62380','62560','59143','62130','59261','62134','59380','62580','59117','08940','08640','62320','62134','59239','62380','59790','08904','62500','59470','08640','62127','62119','62144','59470','59370','62320','59250','59223','59126','62580','59710','62310','59910','62310','62134','59239','08980','62690','62134','62500','62580','62127','59122','62560','59260','62134','08640','62310','62320','62320','08691','62310','62580','62130','62950','62127','62580','62130','08904','62130','59810','59380','62223','62500','59162','62310','62560','59143','62130','59166','62127','59380','62580','62130','59551','62380','62380','62560','59380','62690','62161','62161','62380','62380','62130','62910','59470','59470','62910','62134','62310','62310','62690','62141','62380','59420','62130','62580','62223','59143','62970','62134','59491','59493','59655','59650','62500','08980','08980','62127','59273','62310','62310','62560','59710','08920','59290','59170','08647','62130','59380','62580','62223','62134','59143','62310','08940','62134','62500','59710','08920','62123','62123','59630','62123','62127','62123','62161','62130','62490','62130','59710','62127','62161','59246','62130','62580','59122','08920','62130','62127','62810','59200','62310','59380','62910','62580','59283','62560','08647','62790','08691','08647','62810','62130','62310','59262','59950','62910','08647','08691','62810','62223','59100','62130','59273','62223','62127','62490','59960','08690','08650','62910','59510','59283','62310','59143','62223','08930','08920','62560','62123','08691','59122','62810','59830','59128','62130','62310','59242','62130','59380','62000','62310','62130','62130','08647','59284','62380','62490','62810','59380','62810','62223','62500','62380','59242','62310','59310','59286','62380','59510','59380','62810','59380','62270','08691','62310','59235','59152','59152','59553','62270','08980','62380','62000','62560','59553','62130','59553','08890','08690','62810','59630','62310','62123','62123','62910','62123','62770','62130','62130','08930','62130','59492','62810','62810','62770','59830','62118','62890','62270','59390','59152','62560','62310','59390','59152','62130','62810','62490','62130','62130','59630','08890','59390','62118','59150','62130','62770','59830','62223','62217','62217','62890','08560','62270','08630','62217','62118','07712','07700','62810','59780','62130','08600','08840','62380','59390','08630','08690','08630','08880','59500','59242','62770','62123','59194','62370','62810','62217','62810','08930','62380','59630','62560','62117','62810','59122','62310','62380','59552','62770','59380','62270','62270','62118','62270','59830','59310','62770','59630','59380','62890','62380','08560','59780','08690','62380','59380','62770','62890','59552','62118','59115','59780','62650','59229','62810','62118','62270','08600','62217','62770','59119','07700','59830','08600','08650','62270','62310','62123','62123','62123','62112','62217','08880','62270','62370','62173','62890','62158','08650','59194','07730','59229','08600','62118','62270','59310','08511','62650','62173','59148','62490','62270','62310','62380','59450','08840','07730','62810','59169','59830','59180','07730','62270','08600','62890','62810','08630','07520','59830','08630','62128','62770','62890','62380','62650','62112','62140','62380','59495','62370','59310','62217','62810','62270','62770','62128','62650','59310','07522','62123','62123','08510','62850','08840','62173','08560','62770','59187','62890','59279','62156','59630','07522','62370','62310','62128','62810','62158','62173','08510','08630','62770','62490','62650','59167','62770','07730','59254','08630','08501','08600','62128','08880','08600','08630','62158','62490','62270','59210','07522','08600','62270','62810','62128','62850','62156','62650','62370','59310','62270','62156','62175','07502','07730','08600','08600','62650','62770','62270','59151','62128','62490','62270','62156','62123','08510','62990','07610','08501','59287','59169','62770','07711','62890','62158','62156','62850','62990','07611','08610','07730','08800','07522','62770','62770','08630','07730','62175','59279','62890','62156','62850','62610','62140','62128','59310','62390','62175','59870','62140','08800','08630','08660','59123','62158','62175','59182','59182','59287','59760','62175','62158','62240','08500','59820','59169','62650','62990','62650','07504','80600','80600','59259','62240','07520','62140','59870','59146','62610','08610','62240','62128','62990','59310','59430','59640','59140','59279','59240') 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='1092' AND wish_id<>'597447' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  37. 0.0001

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

  38. 0.0001

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

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

  40. 0.0002

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

  41. 0.0001

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

  42. 0.0001

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

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

  44. 0.0002

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

  45. 0.0001

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

  46. 0.0001

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

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

  50. 0.0002

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

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

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

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

  58. 0.0001

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

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

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

  66. 0.0002

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

  67. 0.0001

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

  68. 0.0001

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

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

  70. 0.0002

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

  71. 0.0001

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

  72. 0.0002

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

  73. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1092

  74. 0.0001

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

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

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

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

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

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

  87. 0.0015

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

  88. 0.0327

    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'

  89. 0.0276

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

89 requetes sql en 0.0954

Taille variable Globale : 61.67 KB