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 au devoir

Autres annonces du voisin

Tout voir
Service jardinage

Il y a + de 30j

Il y a + de 30j

Offreur de jardinage

13€/heure

Evry
Service jardinage

Il y a + de 30j

Il y a + de 30j

Service : Offre mes service

13€/heure

Evry
Service jardinage

Il y a + de 30j

Il y a + de 30j

Jardinier sérieux recherche travaux

-- €

Évry
Service peintre

Il y a + de 30j

Il y a + de 30j

Service : Faire la peinture

25€/heure

Évry
Service renovation interieure

Il y a + de 30j

Il y a + de 30j

Propose mes services

30€/heure

Evry
Service jardinage

Il y a + de 30j

Il y a + de 30j

Service : Offre service

12€/heure

Evry

Annonces similaires

Tout voir
Service autres cours particuliers

Il y a + de 30j

Il y a + de 30j

Leçon de conduite boîte automatique et m

35€/heure

Gagny
Service autres cours particuliers

Il y a + de 30j

Il y a + de 30j

Service : Bienvenue

33€/heure

Paris
Service autres cours particuliers

Il y a + de 30j

Il y a + de 30j

Accompagnement à la conduite

25€/heure

Sartrouville
Service autres cours particuliers

Il y a + de 30j

Il y a + de 30j

Cours de dorure à la feuille

70€/heure

Paris
Service autres cours particuliers

Il y a + de 30j

Il y a + de 30j

Moniteur d'auto-école diplômée d'état

40€/heure

L'Hay-les-Roses
Service autres cours particuliers

Il y a + de 30j

Il y a + de 30j

Marketing, gestion de projet et manageme

30€/heure

Franconville
Service autres cours particuliers

Il y a + de 30j

Il y a + de 30j

Devenez pro des pizzas !

80€/heure

Montreuil
Service autres cours particuliers

Il y a + de 30j

Il y a + de 30j

Cours Histoire de l'art

20€/heure

Montreuil
Service autres cours particuliers

Il y a + de 30j

Il y a + de 30j

Service : Dispo pour tout

15€/heure

Paris
Service autres cours particuliers

Il y a + de 30j

Il y a + de 30j

Cours d'éducation canine

30€/heure

Fontainebleau

Demande un service : cours particulier entre voisins ou proposer mes services : cours particulier.

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='autres-cours-particuliers' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='1049'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'autres-cours-particuliers' 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='37'

  11. 0

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

  12. 0.0001

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

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

  15. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1049 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  18. 0.0001

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

  19. 0

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

  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='479887' AND wish_id<>'613227' 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='528' 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=479887 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 = 479887

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

  28. 0.0001

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

  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='528' 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 = 479887

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

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

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

  34. 0.0002

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

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

  36. 0.0002

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

  37. 0.0001

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

  38. 0.0068

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.6333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.6333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.45- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.183639197041 AND ville_latitude_deg<49.082960802959 AND ville_longitude_deg>1.7695916332696 AND ville_longitude_deg<3.1304083667304 HAVING distance <= 50 ORDER BY distance ASC

  39. 0.002

    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 ('91000','91090','91450','91450','91130','91250','91000','91250','91280','91080','91090','91100','91250','91070','91350','91100','91210','91700','91170','91480','77127','91260','91860','91230','91540','91540','91270','91600','91390','91830','91800','91250','91540','91800','91700','91560','77380','91360','91480','94480','91810','91220','91200','91330','91220','91540','77176','94520','94520','91360','91240','91710','91550','94440','94190','91700','77550','91750','91420','94290','94450','91830','77240','91310','77176','91630','94440','91160','77550','91610','91750','94460','77310','91160','91630','77240','91380','94440','77170','91310','91310','94390','94310','77170','91620','77166','94470','91320','77310','91770','77240','91160','91290','91310','94150','94600','94380','91180','91750','91160','91630','91760','77310','94320','91290','91460','91620','77550','94380','94370','94260','77350','91630','91140','91630','91300','77150','91590','94550','94000','91590','91140','77166','77950','92160','91850','94400','77111','77550','91120','77150','77350','77950','77350','91520','91340','94880','94880','94490','77930','91590','77173','92340','91890','94700','91840','91370','77950','94140','91510','91510','77170','94231','91680','94230','94233','94239','94238','94234','94240','94232','94235','94236','94237','77190','94340','94210','94100','77930','77930','94430','77950','94510','91730','77000','77000','91790','94800','77111','91590','77190','92290','77930','94410','94110','91490','91430','94340','94220','77950','92260','92330','77390','91400','91650','77930','91590','94200','94500','94205','91940','94270','92350','91940','91430','91570','91730','77000','92220','77340','77930','77330','77000','91440','91650','94420','94250','91590','91640','91640','92320','91590','91490','91490','77390','91680','94160','94130','91730','91910','91820','92120','77390','94360','77950','92140','91580','92240','77630','91650','77390','91820','77390','94350','77220','91400','91580','77680','91580','77184','91590','77630','77220','91190','91940','94300','94120','94170','77220','92130','91720','91640','91580','77115','92360','92190','91400','91640','92170','91880','77590','93330','91190','91530','77390','77185','78350','93160','91580','77115','77390','77220','91470','77630','91490','93100','93170','93110','77135','92370','77590','91190','91530','77720','75001','75000','75002','75004','75005','75007','75008','75010','75006','75009','75020','75003','75011','75017','75019','75016','75015','75014','75018','75116','75012','75013','91720','93360','77420','92100','78140','91470','77390','93460','77183','77090','92310','91150','78350','78530','77186','78117','91580','93230','93130','93260','78220','91490','78470','77610','77720','78117','77164','93250','93310','77820','77390','77200','91470','93220','92410','77220','77590','91470','92210','91530','91530','91150','91720','91470','91720','77600','77390','93000','93140','77820','78000','77360','77123','93500','77500','91470','92430','92420','77920','93320','93340','78114','77610','77600','77600','78460','92380','77720','92150','92800','77390','77390','78830','93370','93400','92200','77177','91150','77850','77400','91720','77600','91150','78470','77610','77123','91410','77600','92110','77400','77610','78280','77300','91720','77123','93120','93300','78150','91150','77720','92300','78960','77720','77870','78460','93190','93390','77720','77400','77600','77210','91410','78170','77400','77760','77210','91870','92400','77174','77133','77820','77181','93470','91150','78150','92250','77390','78830','77610','92600','77610','92500','93150','93700','93350','91150','78210','78470','91410','77181','78720','93270','91720','77400','78180','77144','93200','93210','91150','92270','91150','77760','77700','77720','93410','92390','93450','77400','78720','77174','77410','92700','78730','78730','77133','78290','78380','92000','77700','91150','91410','78720','92230','77760','91410','77760','93440','91150','77760','78400','77610','77400','77270','93600','93240','77720','78430','78720','77810','78330','91150','91780','91780','78870','77540','77144','77700','78800','77760','77430','93800','78720','77540','78390','78590','77830','91690','78190','93430','78560','78590','77410','93290','78420','95500','45330','95140','78320','77700','78160','95870','93420','93380','91150','95360','91150','78320','77370','91150','91410','77163','77780','78730','95100','77720','77760','78620','77720','45330','95880','77540','78360','78110','77450','91690','91690','77540','78750','78730','77670','78450','77830','95500','78320','77760','95400','95210','95218','45330','77450','77580','45300','91690','77700','78230','77540','77250','91690','77410','77690','91690','77760','78112','77450','95410','91410','77410','77880','78340','95170','95110','45330','78860','78120','91410','77670','78100','77450','77250','77370','78500','78990','77410','77860','95230','77760','77131','77515','77540','77290','95500','77163','78660','77450','95500','77163','77760','91780','95700','95200','95400','95120','77830','78600','45330','95350','78310','77860','77410','77410','45300','77140','77250','78690','77250','78730','77370','78600','77690','77370','95160','77370','78310','78450','77580','95530','77370','78370','91410','77580','77580','78120','95130','91410','77450','95580','95580','78610','91410','91740','78125','95600','78240','45330','77760','95190','95720','77760','77450','77410','95440','77410','95240','77515','77580','77131','91930','77250','77760','95350','77130','45300','78240','77860','95370','77450','78690','78760','77410','95130','77290','45300','91660','77540','78810','91740','77130','77990','77580','45300','77140','95680','77760','91660','78300','77515','45390','45390','77250','77154','45390','95720','45390','95380','78610','95390','77230','77140','77890','45330','45300','95460','78660','28700','95380','95320','77890','28700','78640','77100','95330','45300','77120','78120','77130','77230','77990','77370','78660','91740','95220','77140','77120','78810','78850','77515','77410','78490','45300','77140','78640','77148','77130','77580','78660','77370','77515','78640','95190','95250','77230','95720','77167','78630','78260','77970','78660','78955','77100','77124','78700','77250','77710','95380','77580','77141','77167','45300','77230','78125','77165','77100','95380','95570','78121','77130','78490','78490','78490','78610','77890','95570','77580','77154','77167','78640','77120','95480','77470','77230','45300','77165','77165','77124','95570','95550','95150','77230','77370','45300','77570','45300','77580','78570','77230','77130','77370','28700','77167','77148','28700','95190','45390','95850','78670','78670','95560','95380','45480','77120','45390','95720','77130','91670','45390','78660','28310','77165','95840','77520','77370','77890','77940','95470','77230','77580','77230','78650','77120','95560','28700','77940','77470','78125','78490','78490','77230','95740','77940','95560','77230','78570','77124','78780','77470','77520','78660','78490','77130','95610') AND fami_id='3' AND cate_id='37' AND type_id='1' AND ssrubr_id='1049' AND wish_id<>'613227' 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='1049' 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=476513 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 = 476513 AND W.type_id = 1) OR (W.util_id <> 476513 AND W.type_id = 2)) AND (M.post_util_id = 476513 OR M.dest_util_id = 476513) 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 = 476513

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

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

  51. 0.0002

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

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

  55. 0.0002

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

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

  59. 0.0001

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

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

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

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

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

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

  76. 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='1049' LIMIT 0,1

  77. 0.0001

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

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

  79. 0.0002

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

  80. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1049

  81. 0.0001

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

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

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

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

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

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

  91. 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 (39) ORDER BY ssrubr_order ASC

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

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

  94. 0.001

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

  95. 0.0315

    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'

  96. 0.0274

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

96 requetes sql en 0.0812

Taille variable Globale : 63.67 KB