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

Garder mon enfant à  domicile

Demande un service babysitter; babysitting; baby sitting; baby-sitter entre voisins ou proposer mes services babysitter; babysitting; baby sitting; baby-sitter.

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

  8. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='babysitter' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='1031'

  9. 0.0001

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

  11. 0.0001

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

  12. 0.0001

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

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

  15. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1031 LIMIT 1

  16. 0.0001

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

  17. 0.0001

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

  19. 0

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

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

  24. 0.0002

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

  25. 0.0177

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.21667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.917039197041 AND ville_latitude_deg<50.816360802959 AND ville_longitude_deg>1.511723505516 AND ville_longitude_deg<2.921616494484 HAVING distance <= 50 ORDER BY distance ASC

  26. 0.0098

    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 ('62130','62130','62130','62130','62270','62770','62130','62130','62130','62130','62770','62770','62130','62770','62770','62130','62130','62270','62770','62270','62134','62130','62770','62770','62130','62770','62770','62130','62130','62270','62130','62130','62770','62130','62134','62270','62270','62390','62134','62770','62770','62130','62130','62270','62770','62770','62134','62134','62270','62134','62270','62770','62310','62130','62770','62270','62270','62130','62130','62140','62140','62130','62134','62130','62390','62270','62390','62134','62130','62134','62310','62390','62134','62140','62140','62130','62130','62770','62130','62390','62270','62310','62270','62130','62140','62550','62310','62134','62550','62390','62140','62310','62390','62270','62130','62140','62310','62270','62270','62130','62140','62127','62310','62390','62270','62270','62140','62140','62127','62140','62310','62550','62270','62310','62134','62390','62140','62134','62390','62134','62127','62140','62310','62270','62140','62127','62127','62140','62140','62810','62140','62140','62270','62550','62140','62390','62390','62310','62140','62130','62310','62134','62390','62127','62127','80150','62310','62550','62140','62390','62390','62810','62390','62127','62550','62310','62310','62810','62550','62270','80150','62990','62460','62550','62960','80370','62127','80600','62310','62960','80370','80600','80600','62127','62990','62810','62140','62144','62127','62310','62310','62550','62810','62127','62150','62810','62550','62810','62960','80600','80370','62990','80150','62810','62810','62310','62140','62127','80600','62550','80600','80150','62310','80370','62550','80370','62127','62960','62990','62460','62990','62990','62550','62310','62310','80370','62550','62550','62810','80150','62150','62810','62127','62260','62990','62470','62990','62140','80150','62810','62990','62260','80370','62960','80600','62560','62690','62960','62960','62870','80370','62990','80600','80370','62310','62690','62810','80150','62260','62560','62470','62460','62810','62190','80600','62260','62990','62810','62690','80150','62150','80600','80370','80600','62690','62690','80370','62690','62870','80600','80370','62960','62150','62150','62870','62810','80150','62145','62120','62810','62190','62690','62190','80150','62560','80150','80150','62810','80150','62990','62870','62150','62145','80600','62150','80150','80150','62151','80600','62560','80600','62990','62540','80600','62560','62690','62870','62540','62650','80370','80600','62650','80120','80150','62560','62190','62120','62760','62650','62990','62158','62690','62150','62690','62700','80370','62650','80370','80370','62810','80150','62650','62190','62760','62145','62810','62560','62870','62690','80120','62650','62157','62158','62120','62620','62145','62560','80620','62810','62190','62150','80750','62129','80150','62650','62122','62170','80370','62120','62120','62810','80600','62158','62123','80370','80150','62940','62620','62870','80370','62690','62650','62690','62760','62120','62650','62690','62560','62170','62170','62158','62158','62120','62120','80620','62170','62760','62123','62190','62650','62123','62123','62170','80150','62690','62690','62380','62129','62120','80750','80600','62144','62620','80620','62122','80150','62190','80135','62760','62650','62760','62560','80135','62560','80620','80620','62650','62760','62123','62123','62120','62870','62120','80630','62760','62144','80150','62199','62196','62170','62920','62530','80620','62620','80670','80135','62760','62530','80150','62760','62760','62129','62650','62380','80150','80670','62760','62129','62232','62144','62158','62120','62380','62530','62350','80135','62170','62650','62330','62120','62760','62172','62131','80132','62123','62650','62161','62650','62232','80620','62123','80135','62760','62131','62131','62158','62123','62170','62380','80120','62123','62920','62650','62760','80560','80135','62129','80120','62380','80120','62330','62129','62170','62123','62232','62232','62170','62170','80150','62161','62920','62123','62111','80150','62170','62170','80690','80600','80690','80620','62123','62123','62144','80560','62180','62144','62114','62760','80132','62290','80135','62111','80132','62120','62160','62170','62161','62161','62400','62170','62123','80120','80620','62170','80560','80560','80690','62650','80132','62113','62570','80670','80670','80670','80850','80690','62170','62170','62153','62170','62380','80120','62380','62380','62350','80780','62120','62380','62170','80560','80860','62170','62350','80260','80132','62232','62670','80132','62111','59189','62120','62160','62170','62380','80690','62173','62240','62350','62650','80560','62000','80120','62180','80600','62380','62660','62111','80120','80670','62173','62570','62170','62380','80670','62350','80620','59189','62380','62350','80132','80560','62113','62113','62240','62575','80260','80120','80132','62380','62170','62980','62170','80610','62160','62400','62170','62153','62111','80970','80132','80560','80260','62180','80132','62650','62170','62111','80560','62143','62380','62223','59189','80560','62650','62149','62120','62217','62830','62980','62400','62630','62570','80690','80650','62570','62219','80690','62180','62580','62580','62575','62223','62380','80830','62173','80860','62380','59173','80830','62800','62111','80560','62149','80560','80610','62173','80560','62350','62180','62180','62223','62120','62116','62120','80420','80420','62380','62630','62180','80560','62170','80560','80132','80100','80132','62111','62223','62180','62240','62170','62180','59173','62223','62217','80120','62217','80560','80510','62111','80260','62219','62630','80260','62630','62240','62500','80580','80860','80132','62510','62240','62175','62380','80580','62500','62750','62000','62149','59173','62580','80890','80260','62240','80580','80510','62217','80120','80120','59660','80560','62630','62136','80260','62149','62116','62830','62223','62240','59173','62175','80510','80510','62149','80132','80580','80260','80560','62580','62600','62500','62500','62500','59190','62380','59173','80560','62136','62630','80260','62500','62300','62116','62240','62240','62116','80560','80132','80560','62240','80560','62136','62175','62240','80580','62500','80260','62138','62630','62155','62580','80580','62210','62136','62116','80310','80310','62217','80230','62217','62830','62121','80132','80300','80310','62138','62116','62380','80260','62175','62300','62830','62223','80300','80490','62410','62780','62600','62500','62500','80260','62217','80300','62138','80300','62175','80260','62830','59940','62830','62910','62500','62240','59190','59190','80230','80300','62580','80560','80560','62630','80310','80310','62580','62850','80132','80310','62240','59253','59480','62850','80490','62850','80260','62410','59190','62850','62890','80260','80260','62128','62630','80550','62840','62223','80120','62850','80790','62121','80132','80300','62580','62850','59940','80230','80270','62680','62128','80132','62910','80870','62430','62128','59143','80310','80310','62221','62218','62410','62138','62142','62840','80300','62830','62128','80210','62121','80132','80260','62142','80260','80300','62121','62580','80260','62320','59232','62580','62880','59496','62580','62240','80260','80300','80300','80310','62520','62118','62121','62176','62128','62830','62240','62850','80300','62910','80470','80300','80490','62830','59143','80470','59190','62910','80270','80870','62910','80300','62890','80260','62320','62128','62880','62880','62910','80260','62420','80870','62850','62152','80490','59270','80800','80260','62118','62890','59285','62840','62121','59190','62121','62138','59480','80230','80300','62128','80260','62121','62890','80300','80270','59190','62850','62142','62440','80300','62128','80300','62410','59670','59496','80310','62320','62320','62580','80490','62152','62118','62187','80270','59940','59670','80820','80300','59670') AND fami_id='3' AND cate_id='39' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='1031' AND wish_id<>'279815' 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 = 1031

  28. 0.0001

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

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

  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 (47) 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 (42) 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 (37) 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 (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.0014

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

  42. 0.0287

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

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

43 requetes sql en 0.086

Taille variable Globale : 53.35 KB