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

Service : Depannage ordi

Demande un service informatique; depannage informatique entre voisins ou proposer mes services informatique; depannage informatique.

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

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

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='depannage-informatique' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='975'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'depannage-informatique' 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='231'

  11. 0.0001

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('74' 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='158877' 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` = 158877

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=975 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  19. 0

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

  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='158877' AND wish_id<>'352445' 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='74550'

  25. 0.0073

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((46.3167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((46.3167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>45.867039197041 AND ville_latitude_deg<46.766360802959 AND ville_longitude_deg>5.8489447359389 AND ville_longitude_deg<7.1510552640611 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0025

    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 ('74550','74200','74200','74470','74200','74550','74550','74470','74200','74200','74200','74500','74550','74500','74200','74470','74890','74420','74200','74200','74500','74500','74890','74890','74200','74140','74420','74430','74500','74420','74500','74890','74430','74500','74420','74500','74140','74420','74500','74430','74140','74420','74140','74360','74490','74140','74500','74250','74360','74500','74500','74430','74140','74490','74420','74140','74140','01164','74140','01165','74140','74500','74140','01162','01166','74500','74140','01195','74110','74360','01180','01195','74440','74490','01131','74500','01251','01254','74380','74110','01025','01196','01163','74110','74250','74250','01110','01028','74140','74100','01197','01173','01248','01007','01167','74250','74250','01132','01170','74380','01243','74380','01260','01185','01247','01183','01175','01172','01168','74250','74360','01110','01252','01110','01006','01299','01180','01184','01134','74250','01246','74110','01184','01260','01260','01182','01009','74260','01135','01094','01267','01298','01174','01296','74500','01299','01266','01026','74100','74100','01015','01297','01096','01267','01134','01244','74440','74250','01186','01241','01027','01112','01262','01268','01174','01095','01024','74380','74130','01125','01176','74970','01245','01274','01136','01274','01022','01096','01222','01001','01002','01169','74130','74100','01295','01277','01268','01003','01126','74380','01026','01026','01000','01000','01019','01000','01000','01000','01019','01014','01014','01000','01295','01187','74100','01253','01272','01020','01020','01004','01274','01005','74100','01898','01128','01113','01279','01896','01277','74930','01011','01121','74390','01270','01008','01291','01189','01127','74300','01093','74440','01071','01012','01263','74240','01226','74130','01018','01091','01030','01114','01290','01271','01279','01223','01294','01122','74300','74130','01225','01091','01071','01261','01091','01008','74930','01143','74800','01023','01010','01092','01224','01023','01097','01899','01090','01098','74930','74130','01290','74460','74440','01144','01123','01897','01068','01293','01897','01261','01292','01029','01188','74560','74300','01115','74800','01141','01071','01802','01000','01220','01207','01208','74300','01211','01116','01231','01302','01032','01803','01275','01066','01070','01261','01145','01031','01873','01875','01239','01052','01202','01220','01188','01220','74440','01201','74130','01800','01255','74130','01206','01124','01269','01204','01200','01240','74950','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','01211','74800','01276','01873','01210','01033','01218','01000','01142','01073','74800','01211','01215','01845','01234','01039','01895','01846','01205','01814','01209','01149','01117','01896','01210','01036','01210','01278','01893','74800','01146','01264','01811','01800','01811','01304','74800','01304','01227','01203','01227','01303','74340','01801','01215','74160','01870','01870','74800','01072','01874','01220','01216','01815','74560','01170','01256','01000','01054','74300','01219','01170','01804','01053','01273','74800','01148','74930','01213','01034','01073','01805','01037','01148','01213','01212','01211','01847','01035','01872','01280','01212','01852','01305','01148','01219','01820','01304','01170','01170','01053','01219','74300','74160','01147','01816','01211','01217','74800','01809','01228','01614','01217','01213','74950','01308','01873','01214','01081','01853','01868','01820','01616','01607','01042','01817','74300','01080','01055','01257','01042','74160','01822','01042','01306','01265','01307','01148','01148','01304','01078','01232','01607','01041','01808','01832','01615','01341','01077','01871','01170','01870','01870','01610','74740','01170','74130','01823','01806','01148','01860','01040','01258','01082','01083','01607','01871','01316','01820','01867','74350','01233','01348','01617','01610','01607','01346','01807','01820','01820','01818','01818','01832','01041','01377','39220','01040','01844','01312','01058','01341','01076','01242','01315','74570','01148','01376','01610','01170','01612','01673','01856','01630','01288','74160','74160','39220','01084','01088','74160','01041','01617','01313','01891','01869','01824','01148','74350','01344','01833','01608','74350','01867','01170','74160','01059','01673','01376','01630','01902','01236','01347','01041','01608','01854','01317','39220','01608','01286','01613','01376','01148','01608','01281','01043','01890','01040','01287','01884','01041','01318','74160','01673','01867','01509','01061','01347','01880','01372','74350','01513','01673','01345','01699','01085','01041','01609','01710','01342','01326','01322','01880','74450','01283','01345','01323','01609','01618','74570','01890','01283','01923','01375','01675','01321','01619','01410','01063','01885','01062','01892','74130','74570','01325','01044','39310','01237','01673','01510','01285','39400','39400','01892','01880','74580','01410','74350','01863','01418','01699','01699','01609','01609','01669','01343','01353','01063','01925','01513','25240','01884','01675','01063','74350','74160','01674','01675','01373','01670','01063','01630','01374','01630','01624','01624','74700','01324','01892','01922','01624','39400','01880','01284','39310','39310','74350','74520','01329','01699','39400','01674','01038','01337','01416','74700','01623','01866','74570','74350','74350','01352','01670','01862','01046','01923','01884','01670','01624','39310','74350','74450','01922','01512','01925','01410','01903','01658','01510','01904','01630','01611','01417','01677','01669','74230','01674','01433','01660','01350','01669','74660','74350','39400','74370','74350','74700','01356','39310','01697','01435','01658','01354','01688','74520','74480','01047','74220','01045','01905','01550','01356','01338','01669','01862','74310','74370','01410','01683','01676','74370','74270','01688','01683','01413','01864','01515','74920','01417','01432','01514','01550','01678','01880','01697','39400','01358','01882','01412','01434','01928','01355','01357','01410','01660','01407','01663','74520','01687','01683','01200','01355','74350','25240','25240','39200','39200','01412','01669','74370','39200','74190','74230','39520','01409','01407','25240','01438','25240','01921','01679','01432','74270','74370','01625','01522','01666','01687','74370','74270','01515','74520','74520','01920','01681','74230','74520','01439','01929','01408','39370','01437') AND fami_id='3' AND cate_id='231' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='975' AND wish_id<>'352445' 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 = 975

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

  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 (50) 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 (38) 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 (45) 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 (231) 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 (47) ORDER BY ssrubr_order ASC

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

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

  41. 0.0009

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

  42. 0.0211

    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'

  43. 0.0161

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

43 requetes sql en 0.0524

Taille variable Globale : 53.37 KB