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

Recherche des enceintes à louer

Louer sono entre particuliers ou proposer sono 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 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.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.0005

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

  8. 0

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='sono' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='790'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'sono' 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='176'

  11. 0

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

  12. 0.0001

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

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=790 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  19. 0

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

  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='202953' AND wish_id<>'384744' 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='25420'

  25. 0.0098

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.5*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.5*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.78612- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.050339197041 AND ville_latitude_deg<47.949660802959 AND ville_longitude_deg>6.1205309876939 AND ville_longitude_deg<7.4517090123061 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0031

    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 ('25420','25630','25200','25420','25550','25400','25550','25400','25200','25550','25420','25400','25600','25600','25550','25420','25400','25700','25200','25550','25420','25550','25350','70400','25460','25600','25260','25550','25113','25550','25600','25230','25230','25700','25550','25600','70400','25150','25750','25750','25260','25260','25490','25230','90700','25260','70400','25750','25150','70400','25230','25490','70400','25750','90400','25490','70400','90400','90500','70400','25310','90400','25310','90120','90500','25750','25250','90400','25490','25310','90800','70400','25150','90800','25150','90800','70400','70400','70400','25250','25260','90400','70400','25310','70400','90400','90140','25310','90100','90120','25260','90400','25250','25250','70400','90800','25150','25150','25310','90140','90850','90100','70400','90400','70400','25310','25250','90100','25250','25150','90400','90140','25310','90600','25250','90400','70400','25150','90100','90850','25250','25150','25150','25310','02916','25250','25250','25250','25250','25250','90000','25310','90100','70400','25250','02908','90140','90100','90100','25250','90140','25250','02926','25190','25190','25190','25190','90140','02914','70400','90100','25190','90300','90160','70400','25190','02915','70400','70400','70400','90340','90100','90340','25250','02912','90340','25190','70400','70400','25250','70200','02907','02925','70400','25190','25190','90100','70400','25190','90100','90100','25190','25250','70110','70110','70110','90300','90160','25190','90350','90130','02906','90130','25250','02912','90300','70400','70200','90160','02923','70200','70110','90300','70400','25190','25190','02924','02905','90130','02922','70110','25190','25340','90380','70110','25340','25430','90100','90300','25250','90150','90150','70200','70200','25430','90100','90150','90150','90100','25190','25250','25190','90150','25340','25190','90150','90300','90100','25190','70200','25190','90300','70200','70200','25470','68210','68210','68210','70110','25430','25190','70110','90150','02904','70200','90100','70200','25340','02900','02900','02900','25190','25190','02933','25470','70110','70110','70110','90100','68210','70200','25470','02932','90100','02933','25340','70290','25340','70200','90330','70290','25380','90150','70250','90150','90150','25470','70110','02902','68210','25430','68210','90170','90370','25470','25340','90200','90150','25340','25340','90110','70200','25430','02903','70110','70200','25430','25430','70110','25380','25120','90200','25470','25470','90170','90110','25120','02935','70200','25380','25120','90150','25430','70110','25340','90170','90200','70110','25120','90110','02889','25340','02942','68210','25430','70110','68580','25340','68210','25380','25340','70110','25470','25470','25380','25340','90150','25340','90110','68210','68580','02943','25680','25680','68210','25680','02950','25120','90200','68210','02944','68210','90200','68210','90150','70200','90200','25340','70110','68580','25340','70200','25380','70200','02887','25380','02888','68480','25470','25450','25430','25380','68210','02353','02354','25680','02886','68580','68580','70270','70200','25380','70110','70110','90110','68210','70200','68210','02950','70200','90360','25430','90360','90200','68210','70290','90110','68580','70200','25470','02946','68210','68210','68210','68210','25120','68210','70200','02952','70110','90200','25110','25110','02363','25110','25680','68780','68210','70200','25110','68580','70110','02885','70110','02882','02882','02362','90170','25470','25380','25140','25140','25140','25680','68480','02884','70110','70270','70270','70110','70290','70200','25210','02338','68210','02953','25380','68210','70270','70270','02360','25110','68780','25680','25110','25380','68580','68580','68290','25430','25680','25680','68780','68480','25110','25110','02364','02362','25510','68210','68210','68210','02947','25530','25680','68780','02350','68780','68780','70110','25110','25210','68210','02883','25380','25680','25360','02338','02954','70270','68480','02340','25210','25680','68210','02953','70230','25680','68480','68118','68290','70200','68290','25110','70110','25110','68290','68130','68480','68780','68480','68210','68720','70200','68290','70110','70230','25110','25680','70200','68290','02807','70440','70240','25110','70200','68290','68290','68560','70240','68116','02718','02855','02873','25110','68480','25680','02714','02345','25360','70200','70240','68290','68560','70440','25680','25680','25510','02856','68640','68480','25680','02345','68720','02857','70230','02336','25210','25210','25530','68560','02718','70000','70200','02722','68130','68210','70270','25140','02803','25210','25680','70200','68520','70200','68480','68480','68130','25210','25110','25530','70240','02714','25110','68520','68640','70230','68290','70230','70270','02717','68290','70000','68720','02345','70270','68720','02807','70440','02717','68560','25210','70240','68800','68480','25360','68700','02713','70000','25360','02723','02854','25210','70300','25680','70200','25530','25510','25210','02720','68290','68990','70230','02863','68960','68960','25530','68800','68720','70230','25390','02610','68130','70300','02715','25510','70300','25110','25360','68130','68720','25680','70240','02715','68480','25110','68480','02333','25640','02802','25110','68640','68520','68700','02712','68960','68720','25640','25510','68130','70240','02610','88160','88560','25210','68800','68700','70310','68960','70310','70230','25110','70300','02608','25510','25530','25640','02716','70240','02813','68480','25210','68130','68130','02610','25640','70240','25390','68720','68720','68480','70310','25530','70230','70230','02720','70310','68800','02853','68480','25210','70240','25640','70300','25640','68130','25110','25510','02612','02812','68720','70240','25210','25110','02607','02732','70310','88160','70310','25390','68800','02806','68990','68480','68480','88540','68130','68130','70230','25640','25390','02333','25530','70240','68640','02732','70310','70280','02615','25360','70000','25530','02300','70300','25210','68470','25640','02300','68130','02613','70300','68620','25640','02748','25500','25530','02710','02606','02800','02800','70280','02616','02748','88160','68950','25390','25640','02325','02800','68480','02814','70240','68130','02864','68480','70240','68470','88160','70300','70230','70230','70230','70280','02615','25500','70000','02852','02610','68480','25530','68121','68470','68720','25640','25640','70230','02608','25390','68700','02616','02304','02301','88360','02303','70000','70310','70000','70230','70000','02732','70300','68550','68690','25640','25640','68760','68130','70300','68480','02733','68480','68640','68130','25360','70300','02732','25390','68480','70280','68470','70310','68700','68700','70230','25500','70300','70310','02842','68350','68130','70280','68790','25640','68720','25690','02605','25530','68130','25360','25110','25640','68550','68470','70300','68440','02058','25640','25640','68480','02805','25360','70240','25640','25390','70300','02735','02843','70190','68350','70000','68510','02322','02735','68220','70190','70240','70190','02054','68470','02822','25360','70000','70000','70000','02742','25360','25530','25640','25820','68510','70300','25690','68480','70000','02518','02604','68690','02416','70300','68460','68640','02735','68440','25640','70310','25500','70000','68510','68760','70190','25640','02534','70190','70240','70300','25360','02735','02830','70240','70300','02830','04245','70000','70000','68700','68220','70000','70310','68510','04254','70300','70300','88310','68510','68830','25690','02052','25530','68120','70000','68440','02057','02823','88360','25130','02517','68220','70190','04117','68440','70000','02736','02603','25960','68310','68850','02056','68200','68100','02400','02400','68510','04118','02054','02523','68120','02740','04253','25500','02762','02053','02534','68220') AND fami_id='5' AND cate_id='176' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='790' AND wish_id<>'384744' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  27. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 790

  28. 0.0001

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

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

  30. 0.0004

    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

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

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

  33. 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 (110) ORDER BY ssrubr_order ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  48. 0.0017

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

  49. 0.0304

    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'

  50. 0.0201

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

50 requetes sql en 0.0721

Taille variable Globale : 74.77 KB