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

Boulonneuse à choc

Louer boulonneuse entre particuliers ou proposer boulonneuse 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.0002

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

  8. 0

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='boulonneuse' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1157'

  9. 0

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

  11. 0

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

  12. 0.0001

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

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1157 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  19. 0

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

  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='467635' AND wish_id<>'599040' 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='95590'

  25. 0.015

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.1333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.1333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.683639197041 AND ville_latitude_deg<49.582960802959 AND ville_longitude_deg>1.6127549238713 AND ville_longitude_deg<2.9872450761287 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0015

    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 ('95590','95260','95590','95260','95270','95340','95660','95270','95340','95820','95270','95290','95270','60230','60820','60530','95590','95560','95620','95340','95570','95560','60530','95560','95270','60530','95760','95270','95690','95270','95840','60460','95430','95630','95570','60530','60530','95560','95570','60540','60540','95690','60260','95270','95840','95570','60270','95270','95540','95720','60540','60460','95690','95690','95740','60530','95330','95270','95270','60530','60540','60340','95720','95460','95430','95850','95850','60580','60340','60540','95150','95550','95300','95270','95680','95390','95190','95810','60110','95320','95350','95470','95720','60500','60740','95440','95190','95810','95580','95580','95250','95600','60660','95300','95160','60110','60500','95380','95810','95670','60730','95130','60660','60660','95350','60560','60660','60660','95400','95200','60570','60160','95480','95720','95310','95300','60110','60730','95230','60730','60250','95120','95170','60520','95810','95410','95810','60570','95300','95130','95220','60160','95190','95810','95650','95810','60730','95240','60520','95380','60300','60300','95520','95210','95218','95880','95470','60250','95370','95400','95110','95360','60730','95640','93380','60180','95500','60175','60300','95380','60110','95610','60119','93430','60660','95500','60100','95500','95470','95000','95530','95140','93800','95380','60250','95640','60520','95830','95100','60250','95650','95470','95500','60128','60300','93240','95380','60870','95000','60570','60290','95700','60119','60300','95830','60128','78500','93440','60110','95640','60430','60290','78700','92230','60173','92390','93450','95490','60240','95650','95650','60149','60250','78780','60119','95650','93200','93210','60790','60550','95870','77230','95640','60290','78600','95640','95280','60430','60290','77990','95450','60140','93350','78570','60250','92270','60250','60250','60290','60790','60870','60700','92700','60790','95800','95450','60250','60790','92600','60430','93700','93150','60240','60300','93120','93300','77230','60790','60940','78260','93420','60430','78800','60290','78600','60140','60300','95000','77990','95640','95640','78420','78570','60940','93600','92110','60790','60870','92300','60370','93400','60250','60370','92250','60240','60370','60430','60140','78360','95180','92400','60140','60240','77230','95450','95750','92000','93500','95450','60300','95450','60940','60240','60240','78510','78740','60240','60700','95450','60600','60810','95450','95640','92200','95450','93270','60300','60300','60140','60430','60950','93000','78955','93290','60240','60810','77230','60810','60134','60600','77280','78480','77290','60240','78740','60700','93140','60134','60600','92500','93310','78300','60390','60950','95450','60430','78110','60240','77230','60390','93260','93230','60240','93410','78540','60240','95450','60330','77230','78230','60700','60600','60840','78400','78670','78670','60240','92800','92150','60930','60700','93190','93390','93130','60140','95750','78100','93320','93340','60240','60810','77290','75001','75000','75002','75003','75004','75005','75006','75007','75008','75009','75010','75011','75012','75013','75014','75015','75016','75017','75018','75019','75020','75116','78250','60240','60600','93170','78560','60390','60390','77230','60600','93100','77230','60600','93250','60700','60510','60240','60810','60510','78130','60390','60510','77181','93470','60300','95450','78250','60950','60000','78250','78750','95450','60430','78290','78380','77270','95450','78240','93370','60240','60240','60410','60700','60000','78130','77410','78430','93110','78112','93220','60510','78250','77230','95420','95450','60240','60240','60240','95420','94300','92210','77230','78240','60330','60700','60510','60600','78170','78630','92170','77181','60810','60510','60410','95450','92380','92100','77410','78160','93360','60240','60600','60810','78250','60440','60390','78440','77230','60510','95420','60330','78620','60600','94120','60240','60600','94160','60240','60410','78410','77410','78920','92430','92420','60190','60190','78250','94170','60190','78630','77230','60710','77410','95420','60800','60240','92410','92240','60600','78440','92120','77230','60510','78870','92130','94250','77500','93460','60600','60190','60240','94270','77410','60440','94200','94205','78590','93330','60600','78150','94130','92310','78440','78820','60190','60155','94220','60240','60680','77165','60440','92190','92360','60130','60410','78150','60330','78410','78440','60390','60710','60155','60000','78580','94360','77177','60000','93160','94410','92220','92320','77165','60240','92140','94110','60130','77178','60390','94340','60510','94800','60240','60410','60800','60510','60130','60590','95420','60190','95420','78410','78860','60590','92370','95420','95420','60590','60000','60190','60190','78590','94350','78140','94140','78440','77165','60130','60240','78440','77165','77165','60390','60650','60510','78220','94700','95510','78810','77178','77420','60440','60510','60000','78121','60800','94500','60590','78580','77410','60410','60126','60240','77410','77410','95420','60320','92260','92330','95420','77410','92350','94240','94230','94231','94232','94233','94234','94235','94236','94237','94238','94239','60130','60130','78000','60650','78450','60510','77360','78450','60390','60000','77400','60800','60590','94400','60590','60126','78126','78410','78410','78330','60590','78440','77186','60510','60650','94100','94210','94340','92340','78440','78810','78580','77400','95420','60440','60130','60130','60190','60440','60680','60680','94420','94430','60240','60800','60510','78440','60190','77200','77185','60320','60190','78680','78580','77410','95510','77400','94000','60880','78210','60130','92290','78970','78124','60130','94550','77122','60130','27140','77165','77165','60480','77400','94320','60510','60000','60190','60440','60650','60190','60190','95510','60240','60130','78440','95420','77400','60440','94600','77410','77450','77450','60320','60320','60240','60510','60130','95510','78350','60190','60650','60650','78124','77400','78340','77184','78850','77600','60800','60850','95420','78390','77400','60480','78350','78530','60590','60610','92160','60800','60129','60480','94260','60480','60800','91370','60590','60480','77090','77183','94150','60240','94380','60112','77600','77600','94490','94880','94880','60130','77124','78440','91570','60480','77139','60680','94310','94390','60130','77340','77600','78370','60112','95710','60480','77450','77450','27140','60880','60880','77139','77144','77700','60130','60190','94510','60420','78280','94370','94380','77144','60650','95780','78640','94460','27830','60129','78520','77910','91300','60480','60112','78520','77124','91320','77600','78650','60112','78190','78117','78580','77700','78930','60190','78770','91430','60620','95710','60800','60650','77680','60190','60130','60480','91430','78520','78180','95770','95510','94290','60112','95770','95770','60800','94470','27720','77139','91400','60129','77164','60590','60190','60112','60190','78200','77124','78640','78930','77450','77450','27720','60130','94190','60650','78770','77100','77124','60480','60620','77910','60112','60129','60850','78200','78711','78960','27630','60480','95780','94450','60112','91120','78640','78990','60130','91550','60190','27420','60590','78840','60480','77450','60420','78117','60420','77600','91200','78930','77100','78770','60650','60190','60130','94480','60650','78930','77135','60190','77700','95710','78640','60620','27630','60480','27660','27660','78930','27630','77139','95510','60620','60850','60130','91560','78114','78650','60127','78770','77450','60190','27140','60420','91190','78770','77700','60200','78470','94440','60117','91380','91160','60480','78770','60360','60480','91190','78270','91160','91420','91140','60860','60800','77910','27870','60650','78770','60480','91330','60650','78200','27630','78760','60620','60190','27150','60120','77330','78790','78790','60620','77860','95780','77139','91400','91270','60850','78490','60420','60112','60620','78470','78200','78930','78930','77100','91440','60120','60420','27420','94440','60113','60113','91230','77440','78310','60860','60127','77910','27140','60590','78320','77470','27630','60620','60860','60420','60620','78270','77860','77860','77580','60200','60420','60620') AND fami_id='5' AND cate_id='227' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='1157' AND wish_id<>'599040' 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 = 1157

  28. 0

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

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

  49. 0.0245

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

Taille variable Globale : 74.77 KB