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
80 € / mois
Paiement 100% sécurisé
  • Service client réactif
  • Dépôt remboursé si annulé

Annonces similaires

Tout voir
Location garage

Demande il y a + de 30j

Il y a + de 30j

Cherche Garage en location

50€/mois

Saint-Amour
Location garage

Demande il y a + de 30j

Il y a + de 30j

Cherche box avec prise 6 mois d’hiver (

510€

Bons-en-Chablais
Location garage

Demande il y a + de 30j

Il y a + de 30j

Recherche garage

100€/mois

Annemasse
Location garage

Demande il y a + de 30j

Il y a + de 30j

Location cave urgent

70€/mois

Annemasse
Location garage

Demande il y a + de 30j

Il y a + de 30j

Cherche Garage à louer

85€/mois

Annemasse
Location garage

Demande il y a + de 30j

Il y a + de 30j

Louer un garage pour besoin Perso

85€/mois

Saint-Amour
Location garage

Demande il y a + de 30j

Il y a + de 30j

Cherche à louer un garage (12 mois)

100€

Seynod
Location garage

Demande il y a + de 30j

Il y a + de 30j

Cherche à louer garage

85€/mois

Peillonnex
Location garage

Demande il y a + de 30j

Il y a + de 30j

Colocation Parking pour scooter (6 mois)

-- €

Annecy
Location garage

Demande il y a + de 30j

Il y a + de 30j

Recherche Garage à  louer

50€/mois

Cran-Gevrier

Louer un garage/parking entre particuliers ou proposer un garage/parking en location.

Poster une annonce
Retour
Fermer

Location 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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci

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

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

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='garage' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='519'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'garage' 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='5' AND c.cate_id='79'

  11. 0.0001

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('01' USING utf8mb4) COLLATE utf8mb4_general_ci

  12. 0.0001

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

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=519 LIMIT 1

  16. 0

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

  17. 0.0001

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

  18. 0.0001

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

  19. 0

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

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

  24. 0.0001

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

  25. 0.007

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((46.2167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((46.2167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((5.95- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>45.767039197041 AND ville_latitude_deg<46.666360802959 AND ville_longitude_deg>5.3001313472385 AND ville_longitude_deg<6.5998686527615 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0034

    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 ('01630','01630','01710','01283','01630','01200','01630','01281','01283','01550','01630','01242','01237','01288','01236','01284','01170','01285','01287','01410','01550','01217','01170','01214','01550','01233','01217','01211','01410','01286','01280','74520','74520','01219','01219','01232','74520','01216','39370','01213','39310','01215','01219','01220','01258','01200','01200','01170','74580','01200','01213','74520','74520','01211','01212','01213','01211','01215','01203','01210','01209','01218','39310','01210','39370','01170','74160','01212','01200','01228','01130','01227','01170','39310','74160','01130','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01210','01211','01211','01205','01202','01239','01211','74160','01200','01257','01204','01240','01227','01201','01293','01292','01170','01200','74160','01130','01200','01206','01207','74160','01200','39200','74520','01256','01234','01208','74520','39310','74160','01220','01130','01294','01130','01170','74160','39200','74270','01290','01231','01223','39200','39360','39370','01170','01290','01220','39360','01224','74160','74160','01255','74350','01410','74270','01225','74270','74270','01130','01245','01253','01222','01295','01200','74350','39360','39200','01200','01226','74560','74270','01291','39360','74270','01295','39310','39360','74270','74350','74350','01130','74270','74270','01130','01279','74240','39200','39360','01200','01244','74100','01246','01241','01220','01100','74100','01252','01247','01296','74560','74270','74270','74350','74350','01100','01100','39170','01200','74350','74910','01279','01297','74100','74100','39170','39170','39360','01248','74140','01243','74910','39170','74350','01590','74930','01263','74270','01298','01590','39360','74270','01278','01251','74100','39170','01420','01299','01277','01277','01420','01254','74100','74910','74350','01810','74270','39400','01130','74930','01299','74330','74350','01275','39170','74380','01130','01262','01810','01810','74330','01100','74380','01274','74350','01420','39170','01276','74140','01274','01274','39260','74270','74910','74350','74380','74930','39260','74270','39200','39200','74140','74270','74380','01260','01260','01580','39260','74140','01260','01590','74800','39220','74330','39260','74570','39240','74380','74140','39260','01265','01460','01270','01460','74150','74150','74140','74910','74570','01260','01264','74800','01420','01580','74250','01460','39260','39240','01266','74330','01430','01271','74350','74140','39240','01580','39260','01260','74140','01197','74130','39220','39150','01460','01420','74140','39400','01430','74150','74930','39400','39240','74140','74250','01260','01110','74800','39150','74150','74370','01267','74150','01272','01580','39150','01430','01430','74800','74370','39150','39240','01260','39240','74890','01460','74800','74370','01267','39260','74370','74150','39240','39130','74370','74370','74330','74960','74150','01196','01260','39240','39240','74140','73310','74800','39400','74130','74330','74140','39240','01430','01273','39260','74330','74570','01268','74250','74420','74370','39270','01260','74570','39240','39240','74420','01110','74800','01110','01430','01350','74150','39240','74150','01184','01430','74890','39400','39260','01195','39240','74140','74330','01269','74420','01250','01450','01184','39240','39240','01260','39150','01261','01260','74370','74890','01430','74250','01183','74890','74250','74250','74940','39260','74800','39240','39130','01195','39240','39240','01430','74800','74960','74420','01268','74250','74150','39240','74000','01260','01450','39270','01261','74420','39220','74650','74550','39240','01430','39400','73310','01450','01182','74250','01450','74600','01110','39130','74130','74150','74150','39130','39240','39150','74150','39240','01180','74150','01450','39320','74200','39240','74600','01261','01180','74550','74550','01260','74200','74420','01250','01250','39150','01250','74130','01450','01110','39130','39320','01110','39130','39270','74490','39270','01450','74290','01186','39150','74230','01260','01260','74150','01187','01166','01250','39320','39240','74420','74490','39320','01185','39270','39130','01250','01188','74320','01250','39130','73310','01250','74200','01510','74540','39130','74130','39270','39320','39320','01110','39270','74490','39270','01640','74540','01165','39320','74150','74150','74130','01350','01172','39270','39150','01510','39130','39320','74290','39320','01450','01188','01348','39320','01174','39130','01250','01510','39150','39130','39130','39320','01260','74230','01173','74550','01230','01250','74600','74290','73310','74200','01189','39270','39270','39130','25240','74150','39320','01174','74130','39150','01164','74540','01250','01450','74470','39130','39320','39130','01230','74130','74290','73310','01370','01170','39270','01350','39130','01370','74470','74440','74970','74130','39130','74290','01510','39130','39320','39270','74410','01350','39270','01110','39270','01640','39130','74200','39270','39160','01250','01370','74230','74540','39320','01145','39130','74540','39270','73410','01370','74200','74540','74410','01163','01510','39520','01176','39320','74540','39130','39270','01175','01160','74300','39160','74230','74470','01250','39130','01350','01230','74450','01230','01640','01110','39160','01250','01230','01341','74460','01350','01640','01250','39160','73310','39270','74450','01230','73410','73410','39150','01341','01347','73410','01270','39130','01350','39320','74200','39160','01149','01162','39130','39130','74540','74410','01350','01110','74230','39270','01168','01270','74500','39570','39570','01300','01250','74200','01169','01160','39130','73310','73310','39270','01167','01510','01250','74500','01270','01230','74500','01300','74410','01144','01510','01347') AND fami_id='5' AND cate_id='79' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='519' AND wish_id<>'295067' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  27. 0.0001

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

  28. 0.0001

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

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

  30. 0.0001

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

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

  32. 0.0001

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

  33. 0.0001

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

  34. 0.0001

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

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

  36. 0.0001

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

  37. 0.0001

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

  38. 0.0001

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

  39. 0.0001

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

  40. 0.0001

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

  41. 0.0001

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

  42. 0.0001

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

  43. 0.0001

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

  44. 0.0001

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

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

  46. 0.0002

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

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

  50. 0.0001

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

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

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

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

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

  62. 0.0001

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

  63. 0

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='519' 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=53380 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 = 53380 AND W.type_id = 1) OR (W.util_id <> 53380 AND W.type_id = 2)) AND (M.post_util_id = 53380 OR M.dest_util_id = 53380) 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 = 53380

  67. 0.0001

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

  68. 0.0001

    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='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC

  69. 0.0003

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

  70. 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 (88) ORDER BY ssrubr_order ASC

  71. 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 (81) ORDER BY ssrubr_order ASC

  72. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (110) ORDER BY ssrubr_order ASC

  73. 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 (227) ORDER BY ssrubr_order ASC

  74. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (176) ORDER BY ssrubr_order ASC

  75. 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 (79) ORDER BY ssrubr_order ASC

  76. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (208) 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 (228) ORDER BY ssrubr_order ASC

  78. 0.0003

    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 (207) 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 (95) 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 (173) 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 (83) 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 (93) 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 (193) 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 (91) 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 (232) 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 (92) ORDER BY ssrubr_order ASC

  87. 0.0016

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

  88. 0.0283

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

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

89 requetes sql en 0.0693

Taille variable Globale : 84.6 KB