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

Indiquer un code postal ou une ville Indiquer un code postal

Flèche vers le champ lieu

Service garde chat à 91760 Itteville


Service garde chat : 0 annonces de garde chat entre particuliers à 91760 Itteville Pendant vos vacances et déplacements vous pouvez faire garder votre chat en votre absence. 2 formes de garde de chat existent : confiez votre chat à un voisin qui le garde à son domicile pendant vos vacances ou demandez à un voisin de venir visiter votre chat à votre domicile pour le nourrir, changer sa litière le cajoler pour profter de vos vacances ... Des particuliers, amoureux des chats, se proposent pour garder votre chat, ainsi vous partez l'esprit tranquille en vous disant "mon chat est entre de bonnes mains". La visite ou garde de chat à domicile se négocie en général pour un prix à la journée. Publiez une annonce pour proposer ou faire garder votre chat.
 ... voir la suite
Demander un service / jobbing de garde de chat ou proposer un service de garde de chat entre particuliers.
Poster une annonce

Retour
Fermer

Service › Garde d'animaux

Lancez votre recherche pour voir les annonces.

Trouver

Trouver
Demandes des voisins

Demandes

 créer une annonce
Messagerie

Messages

 Mon profil

Profil

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wall.php

  1. 0.0001

    SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL

  2. 0.0001

    SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='garde-d-animaux'

  3. 0

    SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=45

  4. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('91' USING utf8mb4) COLLATE utf8mb4_general_ci

  5. 0.0001

    SELECT ville_nom FROM villes WHERE ville_cp='91760' AND ville_nom like '%itteville%' ORDER BY ville_population_2012 DESC LIMIT 0,1

  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 ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%chat%' OR ssrubr_title like '%chat%' OR ssrubr_slug like '%chat%') AND cate_id='45' ORDER BY ssrubr_id LIMIT 0,1

  8. 0.0001

    SHOW TABLES LIKE 'pays'

  9. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  10. 0.0002

    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

  11. 0.0001

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

  12. 0.0021

    SELECT ville_cp, ROUND((((acos(sin((48.5167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.336835678816 AND ville_latitude_deg<48.696564321184 AND ville_longitude_deg>2.0617959585847 AND ville_longitude_deg<2.6048640414153 HAVING distance <= 20 ORDER BY distance ASC

  13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='chat'

  14. 0.0002

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='45' AND ssrubr_id='950' AND wish_visu IN (1,6,10) AND wish_cp like '91760%'

  15. 0.0001

    SELECT * FROM texte WHERE cate_id=45

  16. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='chat' OR ssrubr_slug='chat' OR (ssrubr_title like '%chat%')) AND cate_id='45' ORDER BY ssrubr_id LIMIT 0,1

  17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='chat' AND cate_id='45'

  18. 0.0001

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

  19. 0.0016

    SELECT ville_cp, ROUND((((acos(sin((48.5167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.336835678816 AND ville_latitude_deg<48.696564321184 AND ville_longitude_deg>2.0617959585847 AND ville_longitude_deg<2.6048640414153 HAVING distance <= 20 ORDER BY distance ASC

  20. 0.005

    SELECT ville_cp, ROUND((((acos(sin((48.5167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.067039197041 AND ville_latitude_deg<48.966360802959 AND ville_longitude_deg>1.654489042763 AND ville_longitude_deg<3.012170957237 HAVING distance <= 50 ORDER BY distance ASC

  21. 0.006

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.5167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='45' AND ssrubr_id='950' AND wish_visu IN (1,6,10) AND wish_cp IN (91760,91760,91770,91590,91850,91590,91610,91710,91510,91510,91590,91590,91630,91810,91630,91630,91540,91590,91590,91630,91590,91540,91730,91750,91580,91580,91590,91630,91750,91730,91290,91540,91890,91540,91790,91820,91820,91880,91290,91580,91090,91180,91220,91220,91830,91910,91730,91100,91520,91340,91720,91070,91080,91490,91150,91650,91840,91750,91580,91310,91700,91490,91240,91700,91250,91650,91830,91310,91680,91720,91490,91580,91310,91310,91150,91650,91100,77930,91720,91460,91700,91350,91250,91000,91090,91620,91250,77310,77930,91580,91130,91000,91450,91490,91720,91680,91530,77240,91150,77930,91150,91280,91620,91150,91360,91360,91390,91600,77930,91160,91170,91450,77310,77310,91640,91530,77930,91250,91720,91490,91150,77350,91640,91530,91150,77176,91150,91260,91720,91160,91150,77176,91870,77930,91150,91640,91210,77630,91140,91150,77190) AND type_id=1 GROUP BY wish_id

  22. 0.0001

    SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (15463,32177,56954,69437,86510,88222,119314,128107,146626,191513,208826,212287,228792,235108,260936,289623,301787,89962,250085,99783,312352,316620,344175,355941,357813,204983,420450,512927,211686,322674)

  23. 0.0001

    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 = 15463 AND W.type_id = 1) OR (W.util_id <> 15463 AND W.type_id = 2)) AND (M.post_util_id = 15463 OR M.dest_util_id = 15463) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  24. 0.0001

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

  25. 0.0001

    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 = 32177 AND W.type_id = 1) OR (W.util_id <> 32177 AND W.type_id = 2)) AND (M.post_util_id = 32177 OR M.dest_util_id = 32177) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  26. 0.0001

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

  27. 0.0001

    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 = 56954 AND W.type_id = 1) OR (W.util_id <> 56954 AND W.type_id = 2)) AND (M.post_util_id = 56954 OR M.dest_util_id = 56954) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  28. 0.0001

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

  29. 0.0001

    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 = 69437 AND W.type_id = 1) OR (W.util_id <> 69437 AND W.type_id = 2)) AND (M.post_util_id = 69437 OR M.dest_util_id = 69437) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  30. 0.0001

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

  31. 0.0001

    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 = 86510 AND W.type_id = 1) OR (W.util_id <> 86510 AND W.type_id = 2)) AND (M.post_util_id = 86510 OR M.dest_util_id = 86510) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  32. 0.0001

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

  33. 0.0001

    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 = 88222 AND W.type_id = 1) OR (W.util_id <> 88222 AND W.type_id = 2)) AND (M.post_util_id = 88222 OR M.dest_util_id = 88222) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  34. 0.0001

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

  35. 0.0001

    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 = 119314 AND W.type_id = 1) OR (W.util_id <> 119314 AND W.type_id = 2)) AND (M.post_util_id = 119314 OR M.dest_util_id = 119314) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  36. 0.0001

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

  37. 0.0001

    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 = 128107 AND W.type_id = 1) OR (W.util_id <> 128107 AND W.type_id = 2)) AND (M.post_util_id = 128107 OR M.dest_util_id = 128107) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  38. 0.0001

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

  39. 0.0001

    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 = 146626 AND W.type_id = 1) OR (W.util_id <> 146626 AND W.type_id = 2)) AND (M.post_util_id = 146626 OR M.dest_util_id = 146626) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  40. 0.0001

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

  41. 0.0001

    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 = 191513 AND W.type_id = 1) OR (W.util_id <> 191513 AND W.type_id = 2)) AND (M.post_util_id = 191513 OR M.dest_util_id = 191513) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  42. 0.0001

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

  43. 0.0001

    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 = 208826 AND W.type_id = 1) OR (W.util_id <> 208826 AND W.type_id = 2)) AND (M.post_util_id = 208826 OR M.dest_util_id = 208826) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  44. 0.0001

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

  45. 0.0001

    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 = 212287 AND W.type_id = 1) OR (W.util_id <> 212287 AND W.type_id = 2)) AND (M.post_util_id = 212287 OR M.dest_util_id = 212287) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  46. 0.0001

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

  47. 0.0001

    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 = 228792 AND W.type_id = 1) OR (W.util_id <> 228792 AND W.type_id = 2)) AND (M.post_util_id = 228792 OR M.dest_util_id = 228792) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  48. 0.0001

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

  49. 0.0001

    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 = 235108 AND W.type_id = 1) OR (W.util_id <> 235108 AND W.type_id = 2)) AND (M.post_util_id = 235108 OR M.dest_util_id = 235108) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  50. 0.0001

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

  51. 0.0001

    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 = 260936 AND W.type_id = 1) OR (W.util_id <> 260936 AND W.type_id = 2)) AND (M.post_util_id = 260936 OR M.dest_util_id = 260936) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  52. 0.0001

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

  53. 0.0001

    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 = 289623 AND W.type_id = 1) OR (W.util_id <> 289623 AND W.type_id = 2)) AND (M.post_util_id = 289623 OR M.dest_util_id = 289623) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  54. 0.0001

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

  55. 0.0001

    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 = 301787 AND W.type_id = 1) OR (W.util_id <> 301787 AND W.type_id = 2)) AND (M.post_util_id = 301787 OR M.dest_util_id = 301787) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  56. 0.0001

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

  57. 0.0001

    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 = 89962 AND W.type_id = 1) OR (W.util_id <> 89962 AND W.type_id = 2)) AND (M.post_util_id = 89962 OR M.dest_util_id = 89962) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  58. 0.0001

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

  59. 0.0001

    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 = 250085 AND W.type_id = 1) OR (W.util_id <> 250085 AND W.type_id = 2)) AND (M.post_util_id = 250085 OR M.dest_util_id = 250085) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  60. 0.0001

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

  61. 0.0001

    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 = 99783 AND W.type_id = 1) OR (W.util_id <> 99783 AND W.type_id = 2)) AND (M.post_util_id = 99783 OR M.dest_util_id = 99783) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  62. 0.0001

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

  63. 0.0001

    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 = 312352 AND W.type_id = 1) OR (W.util_id <> 312352 AND W.type_id = 2)) AND (M.post_util_id = 312352 OR M.dest_util_id = 312352) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  64. 0.0001

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

  65. 0.0001

    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 = 316620 AND W.type_id = 1) OR (W.util_id <> 316620 AND W.type_id = 2)) AND (M.post_util_id = 316620 OR M.dest_util_id = 316620) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  66. 0.0001

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

  67. 0.0001

    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 = 344175 AND W.type_id = 1) OR (W.util_id <> 344175 AND W.type_id = 2)) AND (M.post_util_id = 344175 OR M.dest_util_id = 344175) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  68. 0.0001

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

  69. 0.0001

    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 = 355941 AND W.type_id = 1) OR (W.util_id <> 355941 AND W.type_id = 2)) AND (M.post_util_id = 355941 OR M.dest_util_id = 355941) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  70. 0.0001

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

  71. 0.0001

    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 = 357813 AND W.type_id = 1) OR (W.util_id <> 357813 AND W.type_id = 2)) AND (M.post_util_id = 357813 OR M.dest_util_id = 357813) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  72. 0.0001

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

  73. 0.0001

    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 = 204983 AND W.type_id = 1) OR (W.util_id <> 204983 AND W.type_id = 2)) AND (M.post_util_id = 204983 OR M.dest_util_id = 204983) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  74. 0.0001

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

  75. 0.0001

    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 = 420450 AND W.type_id = 1) OR (W.util_id <> 420450 AND W.type_id = 2)) AND (M.post_util_id = 420450 OR M.dest_util_id = 420450) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  76. 0.0001

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

  77. 0.0001

    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 = 512927 AND W.type_id = 1) OR (W.util_id <> 512927 AND W.type_id = 2)) AND (M.post_util_id = 512927 OR M.dest_util_id = 512927) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  78. 0.0001

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

  79. 0.0001

    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 = 211686 AND W.type_id = 1) OR (W.util_id <> 211686 AND W.type_id = 2)) AND (M.post_util_id = 211686 OR M.dest_util_id = 211686) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  80. 0.0001

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

  81. 0.0001

    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 = 322674 AND W.type_id = 1) OR (W.util_id <> 322674 AND W.type_id = 2)) AND (M.post_util_id = 322674 OR M.dest_util_id = 322674) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  82. 0.0001

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

  83. 0.0001

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

  84. 0.0016

    SELECT ville_cp, ROUND((((acos(sin((48.5167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.336835678816 AND ville_latitude_deg<48.696564321184 AND ville_longitude_deg>2.0617959585847 AND ville_longitude_deg<2.6048640414153 HAVING distance <= 20 ORDER BY distance ASC

  85. 0.0052

    SELECT ville_cp, ROUND((((acos(sin((48.5167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.067039197041 AND ville_latitude_deg<48.966360802959 AND ville_longitude_deg>1.654489042763 AND ville_longitude_deg<3.012170957237 HAVING distance <= 50 ORDER BY distance ASC

  86. 0.0001

    SELECT ss.fami_id, fami_url, ss.cate_id, cate_title_slug, keywords_title FROM `ssrubr_keywords` sk, ssrubr ss, category c, family f WHERE sk.ssrubr_id=ss.ssrubr_id AND ss.cate_id=c.cate_id AND c.fami_id=f.fami_id AND (ssrubr_slug='chat' OR ssrubr_slug like '%chat%' OR MATCH (ssrubr_slug) AGAINST ('(+chat)')) AND sk.ssrubr_id='950' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

  87. 0.0001

    SELECT * FROM actu WHERE ssrubr_id='950' AND actu_niveau=0 ORDER BY actu_ordre DESC

  88. 0

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

  89. 0.0001

    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

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

  91. 0.0009

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

  92. 0.0212

    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'

  93. 0.0162

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

93 requetes sql en 0.0687

Taille variable Globale : 80.88 KB