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

M amener faire des courses et me les porter

Demande un service course; aide aux courses entre voisins ou proposer mes services course; aide aux courses.

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

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

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='aide-aux-courses' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='1149'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'aide-aux-courses' 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='229'

  11. 0

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

  12. 0.0001

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

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

  15. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1149 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  19. 0

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

  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='407141' AND wish_id<>'551501' 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='13011'

  25. 0.0063

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((45.7387*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((45.7387*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((8.259- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>45.289039197041 AND ville_latitude_deg<46.188360802959 AND ville_longitude_deg>7.6147171738869 AND ville_longitude_deg<8.9032828261131 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0082

    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 ('13011','13011','13011','13017','13017','13010','13024','13020','13861','13018','13864','13019','13018','13037','13867','13867','13010','13863','13019','13037','13867','28075','13868','13833','13019','13019','28076','13835','28894','13037','13835','13835','28899','28010','28017','13020','28010','28010','13835','13835','13835','13835','13865','28016','13027','13020','28010','13020','28047','28016','28077','13020','13028','13825','28010','28891','13020','13831','13822','13835','13868','28010','28016','28024','28014','13045','13020','28028','28010','13866','13835','13020','13823','28010','13060','28891','28010','13060','13022','13020','28010','28078','13824','13835','13823','13866','13045','13821','13821','13060','28021','28021','28021','28021','13020','13862','28896','13853','13841','28887','28011','28060','13847','13847','28898','13853','13025','13022','28045','28887','13843','28019','13025','13841','13853','13023','28887','28011','13854','28897','13844','28897','13020','28887','28046','28011','13836','28010','13020','13020','28887','28040','28897','28895','28074','28010','13844','13026','28887','13843','28013','28893','28897','13811','13811','13848','13854','28040','28010','13816','13855','13812','13812','13812','13864','13821','13825','13836','13836','28013','13816','13812','28012','28041','28895','28010','13845','13812','28046','13035','28883','28010','13026','28041','13040','28070','28881','28881','13900','13856','13856','13815','28010','28881','13818','28041','28010','13812','13836','13899','28060','28040','28040','28836','28881','13900','13900','13900','13900','13812','28010','13851','28010','28883','13026','13878','28883','13900','13900','28040','21020','13900','21021','28019','28836','13030','13021','28073','28064','28833','21018','13894','13814','28831','28832','13874','28010','28838','28838','28838','28838','13871','28838','28838','13030','13875','28831','28831','28040','13874','28010','13898','28072','28010','21020','13021','13897','13876','13871','28064','28877','28871','13873','28881','28877','21027','13040','13031','21027','13817','13895','21027','13877','28802','28802','21018','28053','28015','11020','28879','28879','13891','13895','13895','28064','28040','28875','28803','28803','28040','28028','28050','28805','13895','28922','28886','13888','21062','21019','28060','28804','13888','13888','13872','13882','28876','28060','21062','28040','13040','28804','21010','28801','28873','28885','28873','28873','21020','21038','21020','21020','11020','11020','13882','28876','28876','11020','21038','21020','13896','21028','13885','28072','28010','28060','28814','21029','28060','28817','13030','13882','28047','28884','21020','21023','21014','21029','28060','13030','21019','28876','13888','28819','21019','21032','13885','28811','13030','21020','21020','11020','13884','28811','21020','21029','28851','28811','28813','28010','28846','28043','21019','28061','21020','13884','28846','21036','28823','28823','28823','21029','28060','21024','28815','13893','13030','21034','21033','13885','21020','13010','13010','21010','28060','21034','21034','21020','13887','28843','13887','21034','28060','13040','21020','13881','28844','28060','21019','21030','28818','21020','21010','21020','28841','28816','28841','21020','10010','11020','13030','21020','21026','21026','10010','10010','28851','28851','21020','10010','13886','13883','10010','21030','10010','21011','13030','21020','21020','28060','10012','13030','28812','21030','13853','10010','21025','21010','13881','10010','28100','21015','21030','28881','21010','21020','10013','11022','10010','21020','21017','28100','21020','21100','21010','21020','21010','21010','21010','21010','21010','10010','10010','21020','21020','21015','11020','21040','21030','21013','13030','10010','21010','21010','10010','28060','28062','21010','28062','11020','11020','21010','28824','11022','21030','21020','10016','13010','28824','21015','10010','21020','03905','28100','21022','13048','20020','21040','21030','13047','28845','11020','10010','21041','21013','21013','21030','10013','10015','10015','10015','21017','11020','21010','21044','21014','11020','21017','28842','28842','28842','21040','28100','28859','21020','21040','21048','13047','21100','28100','28100','28100','21100','28060','11020','21045','21100','28826','21040','21040','21040','10010','11022','13040','13030','21100','21100','21100','21100','20029','28060','21030','21030','21048','21030','21030','10035','21045','21030','11020','10010','21040','10010','21030','20020','21010','21040','11020','10010','10030','10010','13049','21017','21100','21100','21040','28066','21012','13040','10010','28855','21045','28100','21100','10080','21030','11029','11020','11020','10010','28100','10010','21030','28827','28827','28827','28100','11020','20022','28865','28821','28828','13012','11020','13040','11020','11020','21040','28825','28827','21010','28865','10018','21030','21039','20020','10030','21050','13040','28853','11027','11027','11029','28854','20020','13040','28864','28864','10089','21030','21100','21030','10089','28854','21056','21040','21040','21043','10080','21050','10031','28857','28060','28068','28854','11020','10080','21010','21054','21054','21039','10019','10089','21039','10030','28864','21050','28100','21043','21016','21035','10010','03906','28858','21052','13040','13100','03920','28852','28852','20010','21050','21039','10090','10039','21059','21052','28856','21046','28060','21016','21016','03907','11024','21040','28856','21051','21052','13041','10019','10039','03929','03910','21058','28822','21040','10010','10039','10010','21050','21040','13040','21057','21057','10010','21016','13100','11024','21051','28070') AND fami_id='3' AND cate_id='229' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='1149' AND wish_id<>'551501' 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 = 1149

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

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

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

43 requetes sql en 0.059

Taille variable Globale : 53.37 KB