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

Machine à glace

Louer Machine glace; machine a glace entre particuliers ou proposer Machine glace; machine a glace 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.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='507065'

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='machine-a-glace' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='846'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'machine-a-glace' 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='207'

  11. 0.0001

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

  12. 0.0001

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

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

  15. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=846 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  19. 0.0001

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

  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='345945' AND wish_id<>'507065' 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='59490'

  25. 0.0149

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.28333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.917039197041 AND ville_latitude_deg<50.816360802959 AND ville_longitude_deg>2.578383505516 AND ville_longitude_deg<3.988276494484 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0017

    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 ('59490','59179','59870','59490','59171','59171','59215','59870','59580','59870','59146','59176','59870','59165','59171','59124','59580','59176','59870','59182','59156','59172','59870','59870','59220','59178','59172','59135','59182','59167','59287','59255','59178','59234','59293','59178','59252','59252','59111','59287','59148','59230','59169','59194','59169','59220','59234','59282','59310','59230','59135','59195','59310','59234','59178','59111','59252','59220','59111','59310','59282','59450','59119','59187','59195','59194','59121','59151','59247','59111','59494','59310','59230','59295','59295','59310','59121','59310','59690','59247','59226','59265','59226','59169','59224','59169','59494','59310','59247','59590','59174','59296','59141','59310','59141','59286','59125','59554','59552','59500','59410','59310','59265','59151','59192','59265','59169','59151','59224','59283','59233','59235','59198','59158','07624','59553','59553','59552','59310','59400','59141','59283','59128','59151','62112','62790','59554','59151','62860','59268','07623','59950','62860','62112','59300','59230','62860','59265','59860','59300','59246','59300','59227','62490','07611','59158','59230','59161','59161','62490','59242','59265','59188','07620','59161','07621','59553','59880','59710','59158','59199','62860','59227','59227','59213','59269','59770','59242','59277','59188','62141','62117','59554','62970','62860','59129','59199','59213','59162','62490','62860','62860','59242','59158','59554','59269','59830','59710','59161','59551','59830','59554','07620','07622','59278','59990','59259','07610','07620','59239','59970','62860','07620','59554','07618','59830','62490','07620','59710','62490','59990','59188','62860','59294','07620','59261','62950','62860','59213','59213','62490','59269','59239','59830','59400','59830','59292','62119','59400','59970','59264','59990','59990','59830','59217','59990','62820','62156','62156','59273','59267','07502','59970','59163','59710','59551','62860','07506','07641','07504','62490','62118','59243','59273','59400','07608','62590','62156','59530','59213','59213','62860','59400','59214','59780','59400','07500','59144','59730','07500','62118','59217','59730','07604','59830','59217','59133','62182','07640','62490','07640','59530','62110','59262','59267','59730','62860','59730','07640','62860','07642','62640','62220','62156','59530','59400','07522','59990','59780','62320','62320','62580','07643','59990','62182','62156','59400','59217','59152','59281','59159','59730','59163','62710','07521','59154','59152','59152','59144','59157','07501','59810','07522','07604','59400','59157','62156','59113','59133','59175','62740','59400','07600','62118','07387','59530','62320','07603','59920','07536','59271','07538','07522','07604','59163','62147','62118','59540','59175','62420','62860','07500','59144','59530','59112','07601','62156','59530','59540','59147','59152','59241','59144','59218','59218','62880','07522','62580','62320','62580','62118','59155','07320','62147','62580','07530','59159','62440','07604','07380','07548','07503','59144','59530','62182','59790','07387','59218','59139','59730','07387','07380','07350','62118','62118','59147','07602','07387','62860','59218','62580','07604','59258','59258','59127','62680','59780','59144','59263','62128','59251','62860','07904','59191','62430','62182','59530','59260','59267','59540','59147','62880','62880','62221','62218','59191','07540','59510','59530','07321','07531','59139','07534','59540','07387','59530','62580','59360','07520','59185','62128','59530','59112','62580','07350','07382','59225','62147','62128','59570','07540','07971','07971','59390','07387','62880','07321','59258','07971','07904','07387','07520','59159','62410','62580','07387','59510','59530','59191','07971','62210','62223','62147','59530','59222','07322','62128','07532','59980','59222','59225','59144','62300','59320','62223','59221','07972','59272','62147','59370','07542','07973','62128','62128','59530','62580','62128','07350','59144','59231','07743','62410','59127','59570','59000','59800','59160','59350','59777','07730','07370','07370','59320','62300','59390','07743','07906','07534','59570','59120','59360','59980','59390','59570','07730','07533','07322','62159','59222','07543','59266','62138','62128','59184','07540','59136','59390','62128','59288','62147','62580','59360','62410','59570','07973','62147','59980','59550','59170','59290','07904','62128','59496','07387','07730','07387','62217','07350','59320','59110','62124','59211','07972','62223','62124','07370','62128','59115','59127','59980','59980','07540','59550','62410','59570','62217','59127','07730','59266','59127','07740','59320','62124','59274','62223','59570','59530','62138','07387','07901','59130','07972','59700','59570','07760','07334','59231','59238','07911','59360','59491','59493','59650','59655','62750','62580','62000','59134','62580','62124','07760','59350','62159','62124','62223','62223','59496','62128','59134','07300','62800','07370','02420','59142','62128','59320','59134','59231','62217','59570','59320','59320','59266','62124','59360','59360','62124','59150','62217','62223','07903','07742','07730','07903','59520','07730','07740','07760','59570','62153','59320','07900','07900','59134','07903','07970','59100','62128','07911','59320','62124','62124','62138','62175','62143','62223','59297','07334','62217','62217','07340','07730','07910','59420','59160','07911','59360','59480','59118','59480','59840','62121','62450','62121','62124','59570','07332','07950','07330','62159','62138','07333','02420','07712','59570','59910','07301','59137','59840','02110','59550','02110','59360','08587','59134','62450','07910','62138','07911','59200','62160','62175','07950','59249','62124','59840','07812','62153','07910','07340','07760','08587','07332','59237','59570','80360','02420','07711','07340','02110','62160','02420','07910','07910','62450','07340','07390','07331','02110','62980','59249','62450','07911','62175','62124','02110','62121','62121','07812','08587','62000','62149','07812','62149','02110','62144','62144','80122','62450','07700','62124','80240','59360','07760','80360','08510','62149','62160','07910','07950','07802','62161','62161','62173','62840','62124','59360','07910','62121','07080','62121','59145','62217','07390','59550','07080','80740','62980','62175','59145','59138','07951','02110','02110','59280','07911','07700','59570','62450','59360','59138','07812','07812','07080','62450','62149','80360','62670','62840','02420','62121','59223','59250','59126','07040','80240','62161','08554','07910','62175','59620','62450','08583','07012','07950','59138','02420','80740','07801','62114','07750','62173','62450','59550','59960','07080','62144','59890','07912','62450','02110','62113','62113','07812','59550','07912','62149','62121','62450','80360','59360','80240','07012','62172','59620','07040','02110','08510','62161','07050','59930','02420','07950','62450','80112','62450','07750','59138','07040','08582','02110','62123','62840','07750','07750','62450','59550','62144','62116','02630','80240','02110','07760','62530','62173','59330','62121','59280','62136','62123','59330','59116','62530','80360','07011','80240','07750','08552','02420','59750','62290','07800','08510','62660','07080','02450','62173','62450','07040','62530','62116','08511','07033','62116','59620','07911','62690','59236','62113','62690','07803','07810','62116','07870','62144','07040','62123','07050','02420','07811','02420','07050','02420','02110','59550','59193','59166','02630','07040','62123','62136','07040','02420','09690','08580','62121','62840','59620','08551','59890','08930','07024','07040','07783','02230','62690','62690','62123','62123','59330','62690','59117','59600','62450','80360','80240','80240','02450','07941','80360','07940','09600','62136','62123','62123','59440','07050','59330','07942','07040','07890','08930','07804','07780','07780','62620','80240','80300','59244','62400','02420','02450','80760','62840','02420','59560','07804','62111','59560','62131','62131','80240','02630','07022','07000','80360','80360','59440','62131','02110','62123','62690','62123','59600','07022','09690','59620','80300','07022','07800','62150','62450','59850','08560','02490','62116','80360','02450','09690','09690','62620','07784','62400','80360','62123','08510','62123','80300','59244','07782','02490','07020','62690','08940','07940','08930','08581','07784','80240','59600','62400','07890','80240','02110','62690','07041','08550','62123','59330','59330','02170','59720','59940','08553','62150','62116','62690','59600','80200','02510') AND fami_id='5' AND cate_id='207' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='846' AND wish_id<>'507065' 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 = 846

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

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

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

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

  49. 0.0247

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

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

50 requetes sql en 0.0687

Taille variable Globale : 74.77 KB