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 : Aide à la personne

Autres annonces du voisin

Tout voir
Service aide menagere

Il y a + de 30j

Il y a + de 30j

Disponible pour aide au ménage

14€/heure

Mericourt
Service garde lapin

Il y a + de 30j

Il y a + de 30j

Garde lapin ou rongeurs

9€/jour

Mericourt
Service babysitter

Il y a + de 30j

Il y a + de 30j

Disponible pour baby sitting

11€/heure

Mericourt
Service aide aux courses

Il y a + de 30j

Il y a + de 30j

Service : Aide au course

13€/heure

Mericourt

Annonces similaires

Tout voir
Service aide personne

Il y a + de 30j

Il y a + de 30j

Aide pour les personnes agées

15€/heure

Lille
Service aide personne
5/5 résa

Il y a + de 30j

Il y a + de 30j

Service : Aide a la personne

15€/heure

Saint-Venant
Service aide personne

Il y a + de 30j

Il y a + de 30j

Auxiliaire de vie prête à vous aider

20€/heure

Valenciennes
Service aide personne

Il y a + de 30j

Il y a + de 30j

Compagnie personnes âgées

15€/heure

Neuville-en-Ferrain
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide a la personne

20€/heure

Tourcoing
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Aide à la personne

20€/heure

Perenchies
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Ménage et autre

10€/heure

Lambersart
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Service personne

20€/heure

Bourg-Saint-Andeol
Service aide personne

Il y a + de 30j

Il y a + de 30j

Repassage à mon domicile

12€/heure

Nieppe
Service aide personne

Il y a + de 30j

Il y a + de 30j

Service : Petit travaux

20€/heure

Tourcoing

Demande un service d'aide a la personne entre voisins ou proposer mes services d'aide a la personne.

Poster une annonce
Retour
Fermer

Services entre voisins

Lancez votre recherche pour voir les annonces.

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0001

    SHOW TABLES LIKE 'pays'

  3. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  4. 0.0003

    SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC

  5. 0.0002

    SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL

  6. 0.0006

    SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''

  7. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='415585'

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

  12. 0.0001

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

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

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

  17. 0.0001

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

  19. 0

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

  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='237218' AND wish_id<>'415585' 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=237218 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 = 237218

  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='1070' 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 = 237218

  29. 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='1031' LIMIT 0,1

  30. 0.0002

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

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

  32. 0.0002

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

  33. 0.0001

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

  34. 0.016

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.4*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.4*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.86667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.950339197041 AND ville_latitude_deg<50.849660802959 AND ville_longitude_deg>2.1612283689314 AND ville_longitude_deg<3.5721116310686 HAVING distance <= 50 ORDER BY distance ASC

  35. 0.0077

    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 ('62680','62430','62320','62210','62320','62420','62580','62221','62218','62580','62300','62320','62320','62300','62110','62740','62580','62580','62580','62640','62580','62440','62580','62490','62710','62580','62800','62580','62880','62580','62880','62580','62880','62750','62880','62143','62950','62153','62490','62580','62490','62119','62410','62410','62410','62223','62153','62970','62160','62223','62590','62490','62410','62118','62160','59553','62223','62118','62220','62118','62144','62160','62223','62141','62223','62118','62223','62117','62138','59128','62223','59221','59162','62144','59950','59553','59553','62223','62138','62118','62980','59185','62118','62138','62670','62980','62820','62114','59552','62138','62000','62172','62149','62790','62144','59500','59112','59496','62112','59261','59496','62118','62161','62161','62490','59552','62217','62530','62149','62149','59133','59286','62530','59480','59112','59283','62138','59251','59239','62217','62156','62112','59169','62490','62113','62113','62149','62530','59283','62144','62217','62217','59274','62128','62128','59133','62000','59184','62290','62690','59147','62156','62217','59272','59239','62161','62490','62156','62690','62490','62156','62156','62690','62690','59119','62113','62161','59151','59450','59147','62156','62144','62660','59551','59134','62128','62620','59134','62690','59187','59147','59480','62128','62128','59136','62128','59246','59551','59259','59169','62150','59194','62217','62149','62123','62840','62690','62131','62156','62131','62131','62123','62620','59194','59151','62150','62690','62217','59310','62690','59134','59113','62860','62123','62128','62128','59263','62173','62620','59287','59710','62175','62123','62123','59169','59151','62860','62840','62182','62150','59710','59167','62123','62620','62940','59169','62690','62136','62400','62860','62860','62196','62232','59710','62123','59182','59287','59235','62690','62400','62182','62860','59249','62128','59249','62150','62182','62690','62150','62128','59134','59148','59175','62173','62232','59151','62136','59139','62173','62175','59211','62182','59182','62232','62232','62123','62690','59169','62400','59175','62175','62136','62690','59320','62175','62199','62690','62810','59710','59151','62123','62123','62128','59134','59320','59139','62175','62173','62860','62150','59310','62690','59176','62700','59320','62860','62121','62128','62128','59320','59320','59320','62127','59155','62123','62860','59146','62122','59242','62810','59234','62121','62920','59273','62860','59310','62690','62150','59176','59320','62860','62860','62232','62860','62920','59242','62810','59265','62127','59870','62121','62123','62128','62150','62123','59120','62860','59320','62121','62116','62840','59320','62122','62810','59810','59234','62460','59310','62123','59165','62810','59265','62540','62810','59234','62150','62136','59870','62127','59490','62127','62116','62860','59790','62460','62123','62127','62159','59280','62840','62111','62810','59940','62116','62127','62920','59273','59580','62158','62860','62350','62810','59840','62159','59870','59253','62470','62840','59160','59580','59242','59830','59247','59247','62540','62860','62810','59310','62116','59262','59870','59265','59000','59800','59160','59350','59777','62460','62121','62121','62127','59490','62470','62127','62159','62350','59260','62157','62158','62121','62127','59252','59130','62121','62124','59830','62158','62260','59840','59310','62111','62127','62350','59660','62130','62111','62860','59554','59830','59247','59310','59830','59179','62127','59265','59840','59940','59110','62810','59252','62147','62127','59265','62158','62111','62147','59193','62450','59280','62450','62260','59350','59554','59930','62450','59215','62158','62450','62124','59370','59870','62810','62116','62127','62151','62810','59554','59252','62121','59310','62350','62350','59870','59171','59268','59310','62810','62124','62550','59152','59152','62121','62124','62550','62810','59172','62550','62190','59830','59830','59237','62350','62147','59400','59554','62130','62810','59111','59870','62550','62147','62127','59940','59178','59152','59171','59700','62810','62450','62450','62111','59850','62450','59230','59116','62450','62760','59400','62116','62147','59520','62760','62270','59830','59181','59554','62810','62127','59780','59295','59295','07611','62111','59118','62124','62158','62130','59510','07783','62550','59310','59690','80300','62260','59178','62130','59111','59152','80300','59230','62130','62190','62190','59141','59172','59400','62111','59267','62350','62147','59780','59124','59267','62158','59161','59111','62450','62450','62450','62450','62550','59226','59554','07610','62550','59156','62130','59236','62124','62810','62111','62550','59171','80300','59170','59290','62190','62810','62130','62190','62190','62810','62130','62270','80600','59161','59267','62124','62260','62130','62330','59293','07782','59510','59890','07502','62760','62550','07624','62130','59178','59780','59159','62270','62760','62760','59400','62130','80300','62124','62190','62120','59141','59141','59491','59493','59650','59655','62450','59232','59910','59390','62550','62124','59111','62111','80560','59220','07522','59890','62450','07618','62550','62550','62270','62130','59159','62130','62450','59270','62760','62810','59161','59178','80300','80300','59135','62330','62760','07522','62550','07504','62130','59255','59270','62124','59420','59282','62550','80560','80300','62147','62270','62760','62124','59226','62130','59390','08950','59281','80560','59159','62120','59270','59270','59282','07623','59390','59400','80600','80560','80360','62130','80360','62450','59560','59161','62190','62130','07620','07621','07506','59390','80560','62550','07784','07522','59100','62270','62124','07522','59189','62124','59220','62124','62120','07520','80600','62120','59231','08952','59223','59250','59126','80560','59241','62130','59189','62960','62960','62760','59400','80560','59296','59230','59135','07620','62134','07784','59200','62134','62130','59195','62270','62270','59400','07620','80300','08957','07620','62450','80360','62120','62134','07500','80360','62120','62130','62130','59220','80560','59277','80360','07501','62810','07730','07620','62760','08951','62270','62760','80360','07780','07780','59121','62130','62450','80300','62130','59190','59150','59115','59190','80360','62270','80560','59158','62960','59195','62120','62120','59189','80560','59270','80300','80360','62760','08950','80600','62120','59158','07500','59190','59270','59560','80300','80360','59494','80560','59190','59121','07503','59198','62130','59400','07620','80360','62134','80360','62130','80300','08956','59400','59158','62145','59117','62120','59231','80360','07730','59224','62270','59129','08958','08953','80600','59188','07712','59217','59258','62134','80300','59190','62760','07622','80300','59230','07641','07520','59230','59166','07500','07781','80560','80300','62134','59590','59960','07730','59258','59231','59258','80240','59494','62134','62145','62270','80560','59266','08940','62134','59188','62760','07730','62130','62130','59174','59158','07730','59270','62134','62120','80560','80560','07521','62760','59173','59400','59217','59224','62960','80360','80560','62270','62270','59125','62120','07642','80300','62760','62130','80300','59192','80600','08954','62134','62130','07743','59410','59217','59233','80300','07700','07640','62130','07536','08902','80122','59227','59227','80560','59199','62134','59297','80560','59266','62270','07743','59292','07730','80300','80240','62120','07548','59188','62270','07700','59190','07540','59299','80560','62145','80300','80600','59217','07740','62130','62960','80300','62134','59227','59127','62130','80600','59157','08902','80240','62134','80360','07730','80360','80200','59114','59114','08980','59199','08970','07640','59266','62270','07643','62270','80760','59173','59214','08900','59270','59300','62120','80300','80300','80240','07542','59157','62960','62130','59860','59213','62134','62270','59173','80600','08930','62134','62270','07904','59300','07540','59300','59190','08930','80560','80600','59191','07740','08940','59269','62270','80600','62145','07711','80600','62310','07640','80300','62960','80600','80360','59294','80360','80740','80600','62770','07742','62270','59213','80810','08902','62960','80360','62270','62120','07531','59880','07604','07530','59970','62120','59114','59770','59190','07608','80300','07538','62310','62770','59540','80600','62120','08980','80112','59670','08560','62310','08511','80300','80240','80300','02420','08510','08930','59191','08587','59173','07543','62770','59278','62770','59127','02420','62390','62129','62390','59269','80600','80240','80240','59730') AND fami_id='3' AND cate_id='229' AND type_id='1' AND ssrubr_id='1020' AND wish_id<>'415585' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

  38. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 549402 AND W.type_id = 1) OR (W.util_id <> 549402 AND W.type_id = 2)) AND (M.post_util_id = 549402 OR M.dest_util_id = 549402) 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 = 549402

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

  42. 0.0002

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

  43. 0.0002

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

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

  47. 0.0002

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

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

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

  56. 0.0001

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

  57. 0.0001

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

  58. 0.0001

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

  59. 0.0002

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

  60. 0.0001

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

  61. 0.0001

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

  62. 0.0001

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

  63. 0.0002

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

  64. 0.0001

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

  65. 0.0001

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

  66. 0.0001

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

  67. 0.0001

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

  68. 0.0001

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

  69. 0.0001

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

  70. 0.0001

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

  71. 0.0001

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

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

  73. 0.0001

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

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

  75. 0.0001

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

  76. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1020

  77. 0

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

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

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

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

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

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

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

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

  90. 0.0009

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

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

  92. 0.0182

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

92 requetes sql en 0.0769

Taille variable Globale : 63.71 KB