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
20 € / heure
Paiement 100% sécurisé
  • Service client réactif
  • Dépôt remboursé si annulé

Demande un service Papier peint; pose de papier peint entre voisins ou proposer mes services Papier peint; pose de papier peint.

Poster une annonce
Retour
Fermer

Services 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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='pose-de-papier-peint' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='594'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'pose-de-papier-peint' 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='3' AND c.cate_id='50'

  11. 0.0001

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('68' USING utf8mb4) COLLATE utf8mb4_general_ci

  12. 0.0001

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

  13. 0.0001

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

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=594 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  18. 0.0001

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

  19. 0.0001

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

  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='89690' AND wish_id<>'299436' 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='68620'

  25. 0.0057

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.8333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.8333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((7.08333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.383639197041 AND ville_latitude_deg<48.282960802959 AND ville_longitude_deg>6.4134772243577 AND ville_longitude_deg<7.7531827756423 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0029

    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 ('68620','68800','68760','68800','68800','68760','68290','68690','68800','68550','68700','68800','68690','68290','68700','68700','68700','68700','68470','68550','68470','68700','68290','68700','68500','68116','68470','68500','68290','68780','68290','68470','68290','68780','68500','68290','68500','68290','68470','68500','68290','68290','68500','68520','68530','68780','68121','68470','68610','68290','68830','68520','68610','68360','68850','68310','68500','68780','68540','68530','90110','90360','90360','68610','68820','90110','68290','68520','90170','68950','68780','68210','68780','68780','68210','68540','68500','68500','90110','90150','68500','68990','68500','68190','68120','68840','68210','68790','90110','68210','68460','68210','68380','68210','90200','68210','68210','90150','68120','90110','90170','68500','68210','90110','68990','88540','68190','90150','68210','68210','68210','68570','90170','90170','68250','68270','68820','90150','68250','90150','68260','68380','68570','68720','68110','68210','90150','90150','68230','88310','90200','90200','68720','68720','68720','68190','68210','68380','68380','90150','68140','90200','68350','90200','68200','68100','68210','68140','68250','90150','68270','68890','90200','68210','68390','68720','68720','90150','68720','90150','90150','68350','68390','68250','68890','88560','88160','68380','68210','90380','68720','68250','68210','68390','68210','68210','68210','90330','68720','68720','90300','68210','90150','90150','68210','68400','90300','68130','90160','68140','88250','68420','90300','88310','90300','68230','90160','68210','68210','68140','68210','88160','68210','68210','68140','68140','68130','68720','68170','90300','90130','90200','90130','68140','90200','90300','90340','68420','68230','68440','68250','68250','68440','70290','68140','68420','68420','68720','68210','68210','68130','90340','90160','70440','88160','68210','88360','88160','68127','90130','70290','68420','68420','68130','88290','70440','68440','68130','68440','68440','90340','68130','68130','90000','68440','68740','90350','90300','68118','90100','68250','90100','68440','68580','68210','90140','68230','68230','68130','90400','68740','68250','70400','68440','68440','68420','68130','90400','68740','90140','70290','68510','68740','90100','68130','90400','90850','68130','68580','88230','88400','68920','88120','70440','88290','68580','90100','90100','70310','68127','88120','90100','68510','88400','68560','90850','90140','68580','90400','68510','70400','88120','68490','68280','68920','90400','90140','68230','90400','68560','68510','70400','68490','90140','68130','68130','68490','68130','68580','68580','88120','68560','90140','90400','68510','68740','70270','68510','68560','90600','68910','90800','68130','90800','90400','68960','70400','90800','88360','68600','68280','70290','70400','68510','68230','68230','68600','68280','90100','68510','90120','90400','90800','68130','90400','68040','68960','68960','68370','90100','90100','88120','68510','70400','70270','68740','90700','68960','70400','68580','70310','68740','68740','68770','68680','68640','68490','70310','68490','68000','70310','90100','68870','68680','90100','25600','68510','70400','68240','90120','70250','70270','70400','68130','68650','68180','68280','68510','68580','68740','68640','68640','25490','88120','70400','68870','88400','68240','68480','68600','88530','70400','68240','88430','90100','25600','90370','68650','70310','68600','88200','90100','88530','68640','88430','68220','70400','68580','88230','88200','90100','68480','25600','70310','68730','25490','88230','68220','68240','02935','68320','88120','70400','88640','70310','25200','68480','90100','70270','70270','68600','70310','68125','02933','25490','70270','68640','02926','88120','02924','68320','68320','68730','25490','68480','68600','68600','68630','68630','70400','70200','70400','88230','68320','70200','25200','70200','70400','68220','68730','90100','70270','68980','25600','25600','70400','88430','68480','02925','70200','02933','68600','68320','02944','88650','68640','68128','70400','68340','25460','68480','68480','68600','68320','70400','90500','68480','88640','68320','70200','88430','68150','68340','25550','68480','25400','68480','68150','70310','25200','68320','68220','70400','68600','68600','88200','25230','70400','68600','70200','70200','25400','88640','68320','88640','90100','68480','68220','70270','88340','02923','70200','68150','25750','70310','68480','70310','02932','70200','25550','70280','88200','70200','70200','25750','25750','90500','02943','68480','88520','68220','25230','68480','90100','88650','70200','25550','25400','25550','25420','88640','68480','88460','68320','68220','68480','70280','68320','70310','70270','70200','70300','25400','68480','68480','88650','90100','25230','88640','68220','70200','25630','02922','68480','70400','88430','68150','68480','02915','88200','70200','68128','68320','70200','88640','25550','68480','25550','68320','70200','70280','70280','25550','25700','70400','68220','88600','88650','68480','02942','02946','70400','88600','88580','25550','68220','68220','70200','68970','68330','88460','25420','68300','68128','70200','25750','88510','88340','70200','02900','02900','02900','04124','88600','68750','68480','68320','70280','25230','68220','88600','02947','25310','88520','88520','70300','88460','88520','88100','68480','70200','04123','04123','68970','88600','25113','02916','25550','68160','25310','02905','04056','25750','04055','88370','25420','68480','68480','68590','04118','70200','70300','88600','68590','88430','25350','70200','02953','04057','02807','04091','04002','04005','04000','70400','04075','04030','04018','04009','04010','04020','04019','04070','25420','68220','02953','04031','02952','88600','04054','02902','88520','88520','88100','67390','25260','25420','70200','88550','88600','88220','70400','70400','25310','68590','02813','88600','70400','04001','02807','04051','88100','04105','04039','04039','04089','04041','04089','04041','04089','04089','88600','02950','04102','04102','88600','88600','88460','25310','88100','68220','88600','25260','68480','68160','68590','70200','68480','88600','04058','88460','02906','25310','02814','04104','04112','04112','88550','88600','67390','67600','70300','04115','70200','04112','25700','02950','70400','04117') AND fami_id='3' AND cate_id='50' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='594' AND wish_id<>'299436' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

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

  29. 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 (50) 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 (38) ORDER BY ssrubr_order ASC

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

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

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

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

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

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

  40. 0.0011

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

  41. 0.0228

    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'

  42. 0.0164

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

42 requetes sql en 0.054

Taille variable Globale : 53.35 KB