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 ménage à 33800 Bordeaux


Service ménage : 0 annonces de ménage entre particuliers à 33800 Bordeaux Vous recherchez une femme de ménage pour votre domicile ? Ou vous êtes à la recherche d'un emploi de femme de ménage à domicile : déposez votre annonce pour recevoir les offres de voisins intéressés.
 ... voir la suite
Demander un service / jobbing de menage ou proposer un service de menage entre particuliers.
Poster une annonce

Retour
Fermer

Service › Ménage/repassage

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

    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='menage-repassage'

  3. 0.0001

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

  4. 0.0001

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

  5. 0.0001

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

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

  8. 0.0002

    SHOW TABLES LIKE 'pays'

  9. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

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

  11. 0.0001

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

  12. 0.0024

    SELECT ville_cp, ROUND((((acos(sin((44.8333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.8333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.566667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.653435678816 AND ville_latitude_deg<45.013164321184 AND ville_longitude_deg>-0.82029712703074 AND ville_longitude_deg<-0.31303687296926 HAVING distance <= 20 ORDER BY distance ASC

  13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='menage'

  14. 0.0075

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

  15. 0.0001

    SELECT * FROM texte WHERE cate_id=47

  16. 0.0002

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

  17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='menage' AND cate_id='47'

  18. 0.0001

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

  19. 0.0019

    SELECT ville_cp, ROUND((((acos(sin((44.8333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.8333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.566667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.653435678816 AND ville_latitude_deg<45.013164321184 AND ville_longitude_deg>-0.82029712703074 AND ville_longitude_deg<-0.31303687296926 HAVING distance <= 20 ORDER BY distance ASC

  20. 0.0078

    SELECT ville_cp, ROUND((((acos(sin((44.8333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.8333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.566667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.383639197041 AND ville_latitude_deg<45.282960802959 AND ville_longitude_deg>-1.2007477853052 AND ville_longitude_deg<0.067413785305233 HAVING distance <= 50 ORDER BY distance ASC

  21. 0.0089

    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((44.8333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.8333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.566667- 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='47' AND ssrubr_id='937' AND wish_visu IN (1,6,10) AND wish_cp IN (33800,33000,33800,33300,33100,33200,33072,33270,33400,33150,33270,33370,33130,33310,33700,33600,33114,33110,33520,33140,33360,33560,33370,33170,33530,33320,33360,33360,33370,33140,33370,33185,33610,33360,33290,33370,33360,33320,33560,33850,33360,33440,33370,33290,33450,33880,33670,33370,33440,33650,33370,33670,33450,33750,33610,33880,33640,33160,33160,33650,33290,33750,33127,33880,33450,33670,33640,33440,33290,33650,33670,33127,33640,33240,33240,33550,33670,33550,33450,33550,33750,33640,33640,33650,33750,33750,33240) AND type_id=1 GROUP BY wish_id

  22. 0.0002

    SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (25873,57291,59055,59417,59982,61837,60037,83833,98820,109959,111129,113327,120781,123483,32094,137947,142949,176027,184485,68812,199406,212623,213054,176495,263299,300977,316867,363425,376525,378733,383284,208409,397958,378679,415950,426426,429024,438392,454480,366028,470047,489749,402003,59321,543626)

  23. 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 = 25873 AND W.type_id = 1) OR (W.util_id <> 25873 AND W.type_id = 2)) AND (M.post_util_id = 25873 OR M.dest_util_id = 25873) 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=25873 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 = 57291 AND W.type_id = 1) OR (W.util_id <> 57291 AND W.type_id = 2)) AND (M.post_util_id = 57291 OR M.dest_util_id = 57291) 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=57291 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 = 59055 AND W.type_id = 1) OR (W.util_id <> 59055 AND W.type_id = 2)) AND (M.post_util_id = 59055 OR M.dest_util_id = 59055) 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=59055 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 = 59417 AND W.type_id = 1) OR (W.util_id <> 59417 AND W.type_id = 2)) AND (M.post_util_id = 59417 OR M.dest_util_id = 59417) 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=59417 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 = 59982 AND W.type_id = 1) OR (W.util_id <> 59982 AND W.type_id = 2)) AND (M.post_util_id = 59982 OR M.dest_util_id = 59982) 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=59982 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 = 61837 AND W.type_id = 1) OR (W.util_id <> 61837 AND W.type_id = 2)) AND (M.post_util_id = 61837 OR M.dest_util_id = 61837) 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=61837 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 = 60037 AND W.type_id = 1) OR (W.util_id <> 60037 AND W.type_id = 2)) AND (M.post_util_id = 60037 OR M.dest_util_id = 60037) 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=60037 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 = 83833 AND W.type_id = 1) OR (W.util_id <> 83833 AND W.type_id = 2)) AND (M.post_util_id = 83833 OR M.dest_util_id = 83833) 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=83833 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 = 98820 AND W.type_id = 1) OR (W.util_id <> 98820 AND W.type_id = 2)) AND (M.post_util_id = 98820 OR M.dest_util_id = 98820) 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=98820 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 = 109959 AND W.type_id = 1) OR (W.util_id <> 109959 AND W.type_id = 2)) AND (M.post_util_id = 109959 OR M.dest_util_id = 109959) 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=109959 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 = 111129 AND W.type_id = 1) OR (W.util_id <> 111129 AND W.type_id = 2)) AND (M.post_util_id = 111129 OR M.dest_util_id = 111129) 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=111129 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 = 113327 AND W.type_id = 1) OR (W.util_id <> 113327 AND W.type_id = 2)) AND (M.post_util_id = 113327 OR M.dest_util_id = 113327) 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=113327 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 = 120781 AND W.type_id = 1) OR (W.util_id <> 120781 AND W.type_id = 2)) AND (M.post_util_id = 120781 OR M.dest_util_id = 120781) 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=120781 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 = 123483 AND W.type_id = 1) OR (W.util_id <> 123483 AND W.type_id = 2)) AND (M.post_util_id = 123483 OR M.dest_util_id = 123483) 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=123483 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 = 32094 AND W.type_id = 1) OR (W.util_id <> 32094 AND W.type_id = 2)) AND (M.post_util_id = 32094 OR M.dest_util_id = 32094) 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=32094 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 = 137947 AND W.type_id = 1) OR (W.util_id <> 137947 AND W.type_id = 2)) AND (M.post_util_id = 137947 OR M.dest_util_id = 137947) 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=137947 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 = 142949 AND W.type_id = 1) OR (W.util_id <> 142949 AND W.type_id = 2)) AND (M.post_util_id = 142949 OR M.dest_util_id = 142949) 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=142949 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 = 176027 AND W.type_id = 1) OR (W.util_id <> 176027 AND W.type_id = 2)) AND (M.post_util_id = 176027 OR M.dest_util_id = 176027) 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=176027 AND note_visu IN (1,3,4)

  59. 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 = 184485 AND W.type_id = 1) OR (W.util_id <> 184485 AND W.type_id = 2)) AND (M.post_util_id = 184485 OR M.dest_util_id = 184485) 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=184485 AND note_visu IN (1,3,4)

  61. 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 = 68812 AND W.type_id = 1) OR (W.util_id <> 68812 AND W.type_id = 2)) AND (M.post_util_id = 68812 OR M.dest_util_id = 68812) 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=68812 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 = 199406 AND W.type_id = 1) OR (W.util_id <> 199406 AND W.type_id = 2)) AND (M.post_util_id = 199406 OR M.dest_util_id = 199406) 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=199406 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 = 212623 AND W.type_id = 1) OR (W.util_id <> 212623 AND W.type_id = 2)) AND (M.post_util_id = 212623 OR M.dest_util_id = 212623) 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=212623 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 = 213054 AND W.type_id = 1) OR (W.util_id <> 213054 AND W.type_id = 2)) AND (M.post_util_id = 213054 OR M.dest_util_id = 213054) 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=213054 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 = 176495 AND W.type_id = 1) OR (W.util_id <> 176495 AND W.type_id = 2)) AND (M.post_util_id = 176495 OR M.dest_util_id = 176495) 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=176495 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 = 263299 AND W.type_id = 1) OR (W.util_id <> 263299 AND W.type_id = 2)) AND (M.post_util_id = 263299 OR M.dest_util_id = 263299) 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=263299 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 = 300977 AND W.type_id = 1) OR (W.util_id <> 300977 AND W.type_id = 2)) AND (M.post_util_id = 300977 OR M.dest_util_id = 300977) 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=300977 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 = 316867 AND W.type_id = 1) OR (W.util_id <> 316867 AND W.type_id = 2)) AND (M.post_util_id = 316867 OR M.dest_util_id = 316867) 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=316867 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 = 363425 AND W.type_id = 1) OR (W.util_id <> 363425 AND W.type_id = 2)) AND (M.post_util_id = 363425 OR M.dest_util_id = 363425) 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=363425 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 = 376525 AND W.type_id = 1) OR (W.util_id <> 376525 AND W.type_id = 2)) AND (M.post_util_id = 376525 OR M.dest_util_id = 376525) 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=376525 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 = 378733 AND W.type_id = 1) OR (W.util_id <> 378733 AND W.type_id = 2)) AND (M.post_util_id = 378733 OR M.dest_util_id = 378733) 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=378733 AND note_visu IN (1,3,4)

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

  84. 0.0001

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

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

  86. 0.0001

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

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

  88. 0.0001

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

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

  90. 0.0001

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

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

  92. 0.0001

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

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

  94. 0.0001

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

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

  96. 0.0001

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

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

  98. 0.0001

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

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

  100. 0.0001

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

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

  102. 0.0001

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

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

  104. 0.0001

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

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

  106. 0.0001

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

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

  108. 0.0001

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

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

  110. 0.0001

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

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

  112. 0.0001

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

  113. 0.0001

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

  114. 0.0022

    SELECT ville_cp, ROUND((((acos(sin((44.8333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.8333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.566667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.653435678816 AND ville_latitude_deg<45.013164321184 AND ville_longitude_deg>-0.82029712703074 AND ville_longitude_deg<-0.31303687296926 HAVING distance <= 20 ORDER BY distance ASC

  115. 0.0077

    SELECT ville_cp, ROUND((((acos(sin((44.8333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.8333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.566667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.383639197041 AND ville_latitude_deg<45.282960802959 AND ville_longitude_deg>-1.2007477853052 AND ville_longitude_deg<0.067413785305233 HAVING distance <= 50 ORDER BY distance ASC

  116. 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='menage' OR ssrubr_slug like '%menage%' OR MATCH (ssrubr_slug) AGAINST ('(+menage)')) AND sk.ssrubr_id='937' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

  117. 0.0001

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

  118. 0

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

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

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

  121. 0.0009

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

  122. 0.0225

    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'

  123. 0.0186

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

123 requetes sql en 0.0932

Taille variable Globale : 94.76 KB