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

Location : Pulvérisateur

Louer compresseur entre particuliers ou proposer compresseur 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.0001

    SHOW TABLES LIKE 'pays'

  3. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  4. 0.0002

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='compresseur' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='71'

  9. 0.0001

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

  11. 0

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

  12. 0.0001

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

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=71 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  19. 0

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

  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='201098' AND wish_id<>'383297' 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='10130'

  25. 0.0061

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((45.0705*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((45.0705*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((7.6868- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.620839197041 AND ville_latitude_deg<45.520160802959 AND ville_longitude_deg>7.0500931436214 AND ville_longitude_deg<8.3235068563786 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0048

    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 ('10128','10145','10146','10147','10148','10149','10150','10151','10152','10153','10123','10155','10156','10124','10122','10144','10125','10143','10127','10129','10130','10131','10132','10133','10134','10136','10137','10138','10139','10126','10141','10142','10121','10100','10140','10154','10135','10156','10133','10156','10095','10095','10132','10036','10024','10099','10093','10078','10078','10025','10024','10093','10093','10020','10093','10042','10095','10024','10024','10024','10024','10071','10093','10092','10020','10020','10036','10092','10024','10042','10024','10028','10090','10028','10020','10040','10044','10098','10040','10040','10020','10072','10072','10048','10023','10098','10098','10090','10040','10020','10040','10040','10090','10020','10091','10098','10040','10043','10060','10040','10048','10077','10020','10090','10020','10090','10090','10090','10026','10077','10090','10088','10040','10040','10040','10040','10090','10032','10023','10077','10070','10029','10020','10090','10045','10020','10090','10040','10070','10046','10040','10040','10020','10020','10090','10020','10040','10060','10090','10040','10041','10090','10080','10090','14024','10073','10073','10046','10046','10090','10045','10040','10090','10040','10020','10070','10090','10070','10046','10034','10020','14020','10076','10053','10090','10051','10040','10040','10060','14021','10070','14022','10070','14022','10017','10080','10070','10051','14022','10040','10070','10040','10070','10090','10041','10041','10034','10070','10060','10075','14020','10022','10070','10020','10070','14019','10034','14019','10040','14020','14022','10022','10060','10086','14020','10040','10070','10090','10034','10060','10076','10046','14023','10057','10022','10022','10070','10040','10038','14010','14020','14020','10020','14020','10038','10080','14014','10040','10094','10040','10014','10014','10070','10060','10094','10022','10022','10060','14023','10020','10070','14020','10060','10060','14010','10014','10070','14023','10037','10074','14014','14023','14023','10070','10080','10040','12030','10050','14026','14017','10086','10014','10090','10083','10040','10080','10094','10080','10070','10070','10030','10067','10080','10070','14010','10038','10070','10070','10070','14020','10070','14018','10020','10060','10055','10080','10050','12030','10014','14020','14010','10020','14018','12030','10090','10070','10020','10070','10060','10020','10035','14010','10080','10080','10084','10060','10050','13040','14013','10010','14018','14020','10090','10080','10010','12040','10035','10070','10080','10070','14020','10060','14026','12030','12040','14026','10080','14012','10010','14026','14010','10050','14020','14020','10020','10060','10087','10080','10064','10090','10011','10010','14013','10070','12035','12048','10064','10064','14020','14026','14025','10068','14013','13044','10080','10070','10064','10060','10081','13040','14010','14010','10030','14100','10080','14025','14026','15020','12046','10010','10050','10010','10070','10050','10070','14020','10060','10030','10050','14020','10090','10082','12030','14015','10010','10019','12033','10060','12040','10085','14020','10082','14011','12030','14010','14020','13046','14016','10060','10060','10060','10060','10060','10060','10010','14100','12040','10060','13043','10081','10081','10082','10062','10010','15020','12040','15020','14010','13040','10050','10019','12046','15020','10010','14100','10080','10060','15020','10070','14016','13044','15020','10069','12040','12040','14100','15020','10080','10060','10080','15020','10080','13046','10060','14030','12030','12043','10080','13044','10090','12030','10060','10050','14100','10061','10080','12043','14015','15021','10060','10010','15020','10080','12069','10080','14039','12030','10019','12040','10081','10030','10060','10065','10031','15020','12042','10010','10080','14100','12030','10070','10050','12046','15020','10070','10010','10063','10060','12049','10030','10080','15021','15020','12030','14100','10010','10060','10080','10050','10050','15020','14033','10010','10063','10080','14100','14010','12030','10051','13040','15021','10080','12040','10070','13040','10080','10039','10030','14033','10010','12060','14100','12050','14100','14100','14100','14100','14100','10010','12040','10010','15020','10080','12040','10070','10065','10039','10010','12030','13041','10035','14033','10094','14010','10053','10018','12040','12042','15020','10060','14010','12036','12040','10060','15020','12040','14100','14100','12066','12060','10039','14010','15020','10060','10060','12050','12030','10070','12030','10010','10010','14030','12037','10010','13040','15020','15020','10070','15020','10060','13040','10080','10080','10080','10010','14100','12050','10050','10060','10060','14036','12031','14031','10010','10062','10062','15020','12040','10010','10060','12030','12066','12042','12037','12069','12050','12069','12069','12050','10010','12050','12050','10080','12062','10066','14055','14050','10010','10015','10015','10015','15020','12050','15020','14037','15020','10050','10050','14057','14057','10089','12038','14057','10070','10089','12062','15020','10060','12050','14100','14031','10060','14100','10089','12032','12032','10080','12051','10080','14030','14037','10010','12040','14040','15020','10016','13853','13049','10010','10010','12064','13040','13886','14031','10070','10012','10010','12060','13881','10080','12060','10080','13883','14035','12040','10050','10060','12062','14037','12051','14054','14054','12037','12050','10010','15020','10013','13039','12030','10059') AND fami_id='5' AND cate_id='87' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='71' AND wish_id<>'383297' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  27. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 71

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

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

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

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

  43. 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 (93) ORDER BY ssrubr_order ASC

  44. 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 (193) ORDER BY ssrubr_order ASC

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

  46. 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 (232) ORDER BY ssrubr_order ASC

  47. 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 (92) ORDER BY ssrubr_order ASC

  48. 0.0012

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

  49. 0.0222

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

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

50 requetes sql en 0.0574

Taille variable Globale : 74.77 KB