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

Coiffure/soins (Homme)

Autres annonces du voisin

Tout voir
Service service a personne

Il y a + de 30j

Il y a + de 30j

Création flyer/logo/carte de visite

40€

Issoudun

Demande un service de service a la personne entre voisins ou proposer mes services de service a la personne.

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='coiffure-homme' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='943'

  9. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'coiffure-homme' 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='43'

  11. 0

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

  12. 0.0001

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

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

  15. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=943 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  19. 0.0001

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

  23. 0.0002

    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='123118' AND wish_id<>'322346' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  24. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1092' LIMIT 0,1

  25. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=123118 AND note_visu IN (1,3,4)

  26. 0.0003

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 123118

  27. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='36100'

  28. 0.0096

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((45.5467*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((45.5467*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((11.5475- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>45.097039197041 AND ville_latitude_deg<45.996360802959 AND ville_longitude_deg>10.905421399255 AND ville_longitude_deg<12.189578600745 HAVING distance <= 50 ORDER BY distance ASC

  29. 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 ('36100','36100','36057','36030','36057','36050','36050','36057','36057','36051','36010','36050','36040','36030','36030','36023','36077','36040','36077','36050','36077','36050','36010','36022','36057','36030','36040','36040','36040','36050','36050','36023','36050','36065','36050','36031','36031','36023','36029','36040','36033','36050','36040','36030','36075','36075','36075','36075','36020','35010','36033','36030','36040','36024','36043','36045','36070','36020','36050','35010','36100','36100','36100','36066','36030','36070','36020','36020','36071','36024','36024','36040','36051','36060','36070','36034','36030','36070','36050','36047','35010','36016','36040','36021','36047','36070','36042','36050','35010','36040','36040','36040','36050','35016','36021','36054','36034','36042','35010','36040','35035','36030','36060','36056','36056','36071','35030','36073','36040','35010','36030','36021','35030','36042','36071','36050','36040','36030','36030','36060','36073','35016','35013','36053','35014','36035','36030','35030','35030','36064','36030','36045','36064','37030','35010','35013','36030','35035','36070','35010','35016','36078','36030','36030','36030','36015','36072','35010','36030','36060','36010','37030','36020','36070','36040','35013','36050','36060','36060','35010','36030','35030','36055','35010','35010','36045','35016','36030','36045','36078','36040','35010','35030','35019','36015','37047','35030','36060','35030','37032','36064','35010','36070','36016','36078','36078','35010','35030','36020','36040','36010','35037','36015','37032','36070','36063','35019','35030','37030','36027','35037','35030','35030','35037','35037','35037','35010','36070','36014','35010','37035','36078','35037','36015','36015','36030','35010','36040','35010','36020','37032','35010','36013','35010','35030','35010','36045','37030','35030','36010','36063','35030','35015','36010','37047','35030','36070','35010','35010','35010','35010','36063','36078','35030','35030','36036','36036','36026','35030','37040','36063','36030','35034','36070','36028','35010','35030','36046','35018','35010','37047','36015','37040','37038','35010','35038','35010','36020','36010','36025','37030','35010','35031','35031','35010','36061','37044','37047','35034','37030','36062','36022','36046','36026','36022','36022','36046','36015','36010','31037','37044','37040','36061','31033','37030','37031','37044','35011','35011','35010','35010','37040','37040','37031','35020','35042','35125','37039','37030','35030','37040','35012','36010','35036','37039','31030','35136','35143','35128','35125','35124','35123','35122','35137','35121','35100','35138','35126','35143','35135','35134','35138','35133','35132','35131','35130','35139','35140','35141','35142','35129','35127','35124','35010','35010','36076','36076','35020','35020','36030','37030','36060','37030','31037','36010','36010','35030','37040','36020','31033','35030','37040','36061','35010','35010','35129','37050','35010','31037','31037','36030','36011','31039','37039','37042','31033','31033','37030','36065','37044','37041','35020','35127','37038','36020','36010','31023','37040','31020','37030','36029','35129','35020','37041','35012','37040','37030','35010','37041','37055','35032','37042','36010','35017','35010','37030','35030','37040','31030','31039','36030','36030','37055','31020','36029','37030','35041','37041','31023','31020','37030','35010','37059','31030','37030','36010','37055','36029','31039','35010','36011','35020','35010','36040','35046','35127','35017','37030','35020','35020','35010','35044','35030','35010','35010','37036','35020','36010','36020','37030','37030','31023','36040','35020','31033','31030','31010','35040','36012','35045','35020','31030','30036','35040','37040','36010','36010','35020','35042','31011','30030','35040','35020','36100','36010','36010','31010','37040','37028','36010','36032','35043','30030','36012','35040','37036','37059','36040','35017','37036','37046','35027','35027','36012','36012','30036','30036','37040','37036','35020','31017','31050','31011','35025','30036','37059','37023','37050','35010','31050','35040','37050','35043','31030','37050','35025','37050','31011','30039','31011','37050','36010','35040','37020','37040','31017','37023','37045','35020','30039','35020','35020','31050','35040','30036','37040','30030','35042','30032','30033','37040','35040','31050','30033','36040','31030','37050','36020','35017','35040','37059','35043','37021','37132','37021','30030','35020','31050','31010','35020','30031','37023','31050','31050','35040','37029','37050','36040','35010','35040','30033','30033','30035','30039','37050','36052','31050','30030','30035','38060','38060','35040','38060','31050','31054','30030','30030','37021','30030','31010','35040','35040','37050','37023','37023','31050','35040','30035','30030','31036','37040','35142','37057','35024','35020','35026','37050','37045','37045','37127','35020','31059','30030','37045','31031','35047','37020','35020','30031','37050','38060','38060','30037','30035','31010','37059','35020','30037','31034','37057','30035','35020','30030','35040','31050','35048','35028','31010','38040','35040','30034','37045','37057','31036','35020','37020','31040','36052','37040','31036','37133','37142','37100','37121','37122','37123','37135','37134','37132','37125','37140','37126','37131','37127','37130','37129','37137','37136','37124','37138','37141','37139','37128','37125','37045','37051','30031','30010','30010','31036','36040','37049','35020','37051','37053','31059','38060','30030','37020','31044','35040','37053','37060','37049','30034','30034','37060','35020','37020','37049','35028','31055','35040','30034','30034','30034','30034','30030','31044','37053','35040','37024','31038','35040','37024','31041','31040','30038','30038','35040','37024','37024','35048','38060','35023','37139','30010','30030','37020','32030','35028','31040','36020','38046','38046','31059','45026','38061','38064','37060','37050','30038','45020','35040','35048','31040','31040','37020','31040','35028','30010','32031','31040','37043','35040','38064','38064','38060','45021','31040','37056','37063','37020','38061','30037','37029','31055','38061','37056','32031','45021','38064','37020','31038','35020','31040','35020','45026','31035','38061','38061','38064','38064','35023','37029','38064','31035','31035','31038') AND fami_id='3' AND cate_id='43' AND type_id='2' AND ssrubr_id='943' AND wish_id<>'322346' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10

  30. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 943

  31. 0.0001

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

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

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

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

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

  44. 0.0012

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

  45. 0.0268

    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'

  46. 0.0205

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

46 requetes sql en 0.0656

Taille variable Globale : 54.29 KB