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

Blouson à  capuche

Louer Manteau; blouson manteau entre particuliers ou proposer Manteau; blouson manteau 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.0003

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0002

    SHOW TABLES LIKE 'pays'

  3. 0.0003

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

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

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

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

  8. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'blouson-manteau' LIMIT 1

  9. 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='91'

  10. 0.0001

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

  11. 0.0721

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='74603' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  12. 0.0001

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 74603

  13. 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 = 286108

  14. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=639 LIMIT 1

  15. 0.0001

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

  16. 0.0001

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

  17. 0.0001

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

  18. 0.0001

    SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=74603 LIMIT 1

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

  20. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='74603' AND note_visu IN (1,3,4)

  21. 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 = '286108'

  22. 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='74603' AND wish_id<>'286108' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  23. 0.0001

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

  24. 0.0192

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.83333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.517039197041 AND ville_latitude_deg<50.416360802959 AND ville_longitude_deg>3.1342588806145 AND ville_longitude_deg<4.5324011193855 HAVING distance <= 50 ORDER BY distance ASC

  25. 0.0046

    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 ('02620','02260','02170','02260','02260','02260','02170','02170','02260','02260','02580','02120','02580','02260','02170','02120','02260','02120','02260','59219','02450','02260','02170','02580','59550','02500','59219','02120','02120','02120','02450','02450','02260','02450','02450','02140','59219','02120','02510','02120','02500','02500','02140','02140','02260','02120','59212','02450','02140','02510','02500','59550','59440','02140','02450','02510','02140','02120','02500','59244','02140','59244','59244','59610','02550','02510','02140','02140','59610','02120','59440','02120','02120','59177','02140','59550','02500','02120','59360','02140','02140','59360','02500','02140','02630','02120','02500','59360','59440','02250','02120','02120','02120','59440','02140','59440','02140','02140','02500','02140','59177','59360','59132','02140','59440','02120','59186','59550','59440','02110','02500','02110','02500','59440','02630','59440','02630','59550','02140','02140','02120','59440','59550','02140','02140','59360','02140','59550','02140','02140','02250','02120','02140','02110','02110','59177','02120','02250','59132','02830','59132','02140','59620','02120','59360','59620','02140','02250','02140','02140','59360','02110','02110','59360','02110','59440','02120','02140','59440','06594','59620','02140','59440','02500','59145','02250','02250','59550','59740','06590','06593','59550','59740','02110','02500','59360','02120','59740','59222','59216','59216','59288','59440','59360','59620','02250','59145','02250','02110','02500','59360','59132','02120','02250','02270','02140','02110','59620','02250','02270','02270','59330','59330','02250','59222','59222','02500','02360','59137','59530','02830','59132','59530','59216','02110','02110','59138','02250','02360','02360','59138','59530','02250','02340','02390','59980','06591','59740','59740','59740','02500','02110','02250','02340','02250','59680','59132','06592','02390','08380','59360','02390','59330','59980','59980','59740','02360','02250','59330','02230','59218','06596','59132','59730','59980','02110','02240','02500','02500','02360','59330','02340','59980','02240','06596','59680','59530','02270','02270','59218','59740','06460','59540','02390','06460','59238','59680','02240','59740','59218','59218','02110','59530','59138','02350','06460','02270','59138','59740','02270','02340','02110','02340','59540','02250','59530','08290','02240','59740','02110','02270','02360','59330','02360','02250','02340','02110','59680','06470','59530','02340','02270','08380','02360','02270','02360','02350','59271','59225','02360','08290','59530','02350','59730','06470','02270','02360','08380','06470','02350','59570','59225','08380','59740','08380','59730','59680','59530','59740','59330','02270','02110','59730','02110','06460','06460','59540','02350','02240','02340','02240','02100','02350','59144','02340','02720','02110','59530','59530','59680','59127','02270','02340','59720','59730','59530','59540','02270','59730','02360','08380','59570','59149','02360','59570','59570','02350','59131','59570','02350','06470','06470','59191','08290','06460','59191','02110','02720','02360','02340','59213','59213','59144','06464','02270','02360','08290','59680','02420','02270','59530','59680','59600','02100','02100','02360','02360','59144','02270','06464','02360','08260','08380','59157','02350','59214','02240','02350','02420','02000','59570','02240','02340','59127','06470','59294','59127','06461','59750','59600','59191','02720','02240','59530','02000','59217','59127','59213','59213','59570','59157','02100','02270','02420','02240','06500','06464','02110','59245','59168','59530','02340','59292','59188','02100','08260','08260','59149','59142','02270','59144','59570','02000','59217','02340','59570','02240','02240','02100','02240','59600','02420','02340','02000','06464','02340','59570','02350','06462','02100','02420','08220','06500','02420','02350','59127','06560','59570','02350','02100','08260','59269','02840','02150','08290','06500','59400','59217','59213','08220','59227','59227','59144','59600','08220','08260','06463','06500','08220','06440','59144','59600','59188','59570','06440','02240','59213','59570','02800','59217','59144','02350','59164','59990','02420','59570','08290','02610','02240','59129','08290','08290','02100','08260','02420','59188','59600','59460','59227','59149','06500','02270','02420','07040','59269','02800','07387','59600','59144','02420','08230','02270','02420','08290','59269','02690','59400','06440','07040','02000','05660','02800','05660','02350','06560','02100','06464','59600','02000','06500','02420','07387','05660','59258','59277','59400','02240','02100','02840','06560','59198','59990','02870','06500','08220','08220','02240','07387','02490','59600','07040','07387','02800','59224','02430','08260','07387','06560','59990','08220','59400','02420','02440','59258','05660','07387','59400','06560','07387','08260','05660','02800','02420','59990','02870','59990','07040','02680','59233','02150','07387','02490','59258','08260','02760','59296','59300','08260','06560','59161','02800','07080','07370','07041','07040','08290','02690','07040','05660','07387','02800','07387','05660','02760','59990','02840','59300','59224','59161','02150','02680','08220','06441','08220','59266','59125','59266','08220','06567','08260','02490','08150','08460','59990','59400','02870','06567','02420','02840','59266','08230','02420','02680','02680','08220','02800','02840','07370','08220','07382','05630','59241','07080','59141','02150','02000','07120','07120','59770','02440','02440','08260','05660','02800','07387','02440','59141','07040','07040','07120','05650','59121','08150','59282','02800','06530','59300','80740','02420','08260','08220','06567','02870','59281','08220','02800','02800','07380','59920','02490','02870','07041','07370','02680','06511','59111','59161','05660','02820','05660','59121','02820','59400','02440','02870','07340','08220','02440','05650','06440','02870','02790','02840','07022','07370','59243','07080','59880','08150','80240','07120','08220','02840','07080','07340','08230','59282','08150','02490','07080','59161','59400','02800','59554','59141','06536','07040','08230','59264','59159','59174','06542','59297','02000','06567','02590','08150','02490','07120','07120','59231','59111','59220','06532','05660','07340','05630','07340','02800') AND fami_id='5' AND cate_id='91' AND type_id='1' AND ssrubr_id='639' AND wish_id<>'286108' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  26. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 639

  27. 0.0001

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

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

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

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

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

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

  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 (227) 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 (176) 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 (79) 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 (208) 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 (228) ORDER BY ssrubr_order ASC

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

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

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

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

  47. 0.0017

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

  48. 0.0259

    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'

  49. 0.0177

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

49 requetes sql en 1.1679

Taille variable Globale : 74.76 KB