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

Rends service, souriante & très aimable

Autres annonces du voisin

Tout voir
Service garde animaux

Il y a + de 30j

Il y a + de 30j

Service : Garde vos animaux

10€

Longuenesse
Service tonte de pelouse

Il y a + de 30j

Il y a + de 30j

Tonte de pelouse vite fait et bien fait

20€/heure

Loison-sous-Lens
Service aide demenageur

Il y a + de 30j

Il y a + de 30j

Déménageur rapide et efficace

20€/heure

Loison-sous-Lens
Service peintre

Il y a + de 30j

Il y a + de 30j

Travaux de peinture vite fait, bien fait

20€/heure

Loison-sous-Lens
Service montage de meubles

Il y a + de 30j

Il y a + de 30j

Montage de meubles vite fait & bien fait

20€/heure

Loison-sous-Lens
Service taille de haies

Il y a + de 30j

Il y a + de 30j

Taille de haies vite fait et bien fait

20€/heure

Loison-sous-Lens

Annonces similaires

Tout voir
Service service a personne

Il y a + de 30j

Il y a + de 30j

Reflexologie a domicile

25€/heure

Bruay-sur-l'Escaut
Service service a personne

Il y a + de 30j

Il y a + de 30j

Reflexologie a domicile

25€/heure

Bruay-sur-l'Escaut
Service service a personne

Il y a + de 30j

Il y a + de 30j

Toute aide à la personne

50€/heure

Valenciennes
Service service a personne

Il y a + de 30j

Il y a + de 30j

Cuisiniste, monteur de meuble, électrici

50€/heure

Vieux-Conde
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

50€/heure

Pas-en-Artois

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='service-a-personne' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='1092'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'service-a-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='202456' 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` = 202456

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1092 LIMIT 1

  16. 0

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

  17. 0.0001

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

  19. 0

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

  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='202456' AND wish_id<>'384360' 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='1016' 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=202456 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 = 202456

  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='524' 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 = 202456

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

  30. 0.0001

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

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

  32. 0.0001

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

  33. 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='600' LIMIT 0,1

  34. 0.0001

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

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

  36. 0.0001

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

  37. 0.0001

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

  38. 0.0149

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.4333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.4333*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.983639197041 AND ville_latitude_deg<50.882960802959 AND ville_longitude_deg>2.1607322976908 AND ville_longitude_deg<3.5726077023092 HAVING distance <= 50 ORDER BY distance ASC

  39. 0.0152

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

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

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

  45. 0.0001

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

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

  47. 0.0001

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

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

  49. 0.0001

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

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

  51. 0.0001

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

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

  53. 0.0001

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

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

  55. 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)

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

  57. 0.0001

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

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

  59. 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)

  60. 0.0001

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

  61. 0.0001

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

  62. 0.0001

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

  63. 0.0002

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

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

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

  67. 0.0002

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

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

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

  71. 0.0002

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

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

  75. 0.0002

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

  76. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1092

  77. 0.0001

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

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

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

  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 (37) 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 (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.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

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

  90. 0.0016

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

  91. 0.0248

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

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

92 requetes sql en 0.0855

Taille variable Globale : 61.72 KB