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 maquillage à 92110 Clichy


Service maquillage : 0 annonces de maquillage entre particuliers à 92110 Clichy Si vous avez besoin d'un maquillage de mariage, d'un maquillage d'halloween, ou autre évènement, mais que vous ne disposez pas de palette de maquillage ou pinceau maquillage et que les tutos maquillage ne vous suffisent pas. Faites appel à une maquilleuse à domicile déjà équipée d’un coffret maquillage, pour un maquillage pas cher et éviter le déplacement dans un salon de maquillage. Trouvez aussi une maquilleuse professionnelle pour vos maquillages permanents, maquillage des yeux, teint, cils, lèvres, qui vous aidera pour le démaquillage et le choix de vos marques de maquillage comme : maquillage …
 ... voir la suite
Demander un service / jobbing de maquillage ou proposer un service de maquillage entre particuliers.
Poster une annonce

Retour
Fermer

Service › Coiffure/esthétique

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='coiffure-esthetique'

  3. 0.0001

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

  4. 0.0001

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

  5. 0.0001

    SELECT ville_nom FROM villes WHERE ville_cp='92110' AND ville_nom like '%clichy%' 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.0002

    SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%maquillage%' OR ssrubr_title like '%maquillage%' OR ssrubr_slug like '%maquillage%') AND cate_id='43' 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.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.0002

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

  12. 0.0026

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.720135678816 AND ville_latitude_deg<49.079864321184 AND ville_longitude_deg>2.0263897328734 AND ville_longitude_deg<2.5736102671266 HAVING distance <= 20 ORDER BY distance ASC

  13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='maquillage'

  14. 0.0013

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

  15. 0.0001

    SELECT * FROM texte WHERE cate_id=43

  16. 0.0002

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

  17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='maquillage' AND cate_id='43'

  18. 0.0001

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

  19. 0.0023

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.720135678816 AND ville_latitude_deg<49.079864321184 AND ville_longitude_deg>2.0263897328734 AND ville_longitude_deg<2.5736102671266 HAVING distance <= 20 ORDER BY distance ASC

  20. 0.0064

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.450339197041 AND ville_latitude_deg<49.349660802959 AND ville_longitude_deg>1.6159684337256 AND ville_longitude_deg<2.9840315662744 HAVING distance <= 50 ORDER BY distance ASC

  21. 0.0027

    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.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- 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='43' AND ssrubr_id='566' AND wish_visu IN (1,6,10) AND wish_cp IN (92110,92110,92300,92600,93400,92200,92270,92400,92250,92230,92700,92390,93450,75008,75009,75011,75012,75013,75017,75007,75006,75005,75004,75010,75003,75002,75000,75001,75014,75015,75116,75020,75019,75018,75016,93800,93210,93200,92800,92150,93300,93120,95100,95870,93430,92000,93500,92170,95210,95218,95880,78800,92500,93310,93240,95110,95360,92100,78420,93380,92210,92240,95230,93350,93170,92120,95120,92130,95170,94250,93230,93260,95410,93440,78500,93100,95130,94270,92380,93000,92360,92190,94200,94205,95580,95580,92220,78400,78360,92320,95600,94300,95140,95530,94160,94110,95160,92140,92410,93700,93150,92420,92430,95240,92310,95350,95130,94800,93140,95500,78600,78170,93130,95370,95400,94220,95200,95400,78290,78380,95680,92330,92260,94237,94238,94239,94236,94235,94234,94240,94230,92350,95390,94232,94231,94233,92370,78600,78110,95320,95350,78560,93110,78430,92340,94140,78140,95440,95500,94120,78230,93250,95220,78220,94700,94410,95250,94400,95330,92290,94550,78150,94340,78150,94130,95460,94170,78100,93340,93320,78750,95550,95150,94320,95720,95480,93360,78160,95500,78000,92160,95570,94260,93600,78870,95570,95560,91370,95570,95840,94150,95720,94600,78112,93220,78700,95500,93270,78620,94360,78350,95740,91570,95190,94000,78590,93330,94390,94310,95720,94500,93190,93390,94340,94210,94100,95560,95560,91300,93420,78260,78300,91320,95840,78350,78530,95700,94430,78570,93370,78240,91430,95610,94350,78590,93410,93460,95720,95540,91430,95190,94380) 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 (9732,15924,31102,73840,127745,145111,165262,203495,204353,205855,216673,219996,220477,85941,236168,245228,250157,203657,254073,261194,272809,277299,300457,306604,330598,285481,267855,329212,333530,344720,358137,385731,259967,400755,407061,427448,430379,426894,449348,453419,61221,372272,490093,498875,516953,541621,549471)

  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 = 9732 AND W.type_id = 1) OR (W.util_id <> 9732 AND W.type_id = 2)) AND (M.post_util_id = 9732 OR M.dest_util_id = 9732) 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=9732 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 = 15924 AND W.type_id = 1) OR (W.util_id <> 15924 AND W.type_id = 2)) AND (M.post_util_id = 15924 OR M.dest_util_id = 15924) 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=15924 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 = 31102 AND W.type_id = 1) OR (W.util_id <> 31102 AND W.type_id = 2)) AND (M.post_util_id = 31102 OR M.dest_util_id = 31102) 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=31102 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 = 73840 AND W.type_id = 1) OR (W.util_id <> 73840 AND W.type_id = 2)) AND (M.post_util_id = 73840 OR M.dest_util_id = 73840) 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=73840 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 = 127745 AND W.type_id = 1) OR (W.util_id <> 127745 AND W.type_id = 2)) AND (M.post_util_id = 127745 OR M.dest_util_id = 127745) 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=127745 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 = 145111 AND W.type_id = 1) OR (W.util_id <> 145111 AND W.type_id = 2)) AND (M.post_util_id = 145111 OR M.dest_util_id = 145111) 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=145111 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 = 165262 AND W.type_id = 1) OR (W.util_id <> 165262 AND W.type_id = 2)) AND (M.post_util_id = 165262 OR M.dest_util_id = 165262) 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=165262 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 = 203495 AND W.type_id = 1) OR (W.util_id <> 203495 AND W.type_id = 2)) AND (M.post_util_id = 203495 OR M.dest_util_id = 203495) 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=203495 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 = 204353 AND W.type_id = 1) OR (W.util_id <> 204353 AND W.type_id = 2)) AND (M.post_util_id = 204353 OR M.dest_util_id = 204353) 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=204353 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 = 205855 AND W.type_id = 1) OR (W.util_id <> 205855 AND W.type_id = 2)) AND (M.post_util_id = 205855 OR M.dest_util_id = 205855) 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=205855 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 = 216673 AND W.type_id = 1) OR (W.util_id <> 216673 AND W.type_id = 2)) AND (M.post_util_id = 216673 OR M.dest_util_id = 216673) 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=216673 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 = 219996 AND W.type_id = 1) OR (W.util_id <> 219996 AND W.type_id = 2)) AND (M.post_util_id = 219996 OR M.dest_util_id = 219996) 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=219996 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 = 220477 AND W.type_id = 1) OR (W.util_id <> 220477 AND W.type_id = 2)) AND (M.post_util_id = 220477 OR M.dest_util_id = 220477) 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=220477 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 = 85941 AND W.type_id = 1) OR (W.util_id <> 85941 AND W.type_id = 2)) AND (M.post_util_id = 85941 OR M.dest_util_id = 85941) 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=85941 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 = 236168 AND W.type_id = 1) OR (W.util_id <> 236168 AND W.type_id = 2)) AND (M.post_util_id = 236168 OR M.dest_util_id = 236168) 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=236168 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 = 245228 AND W.type_id = 1) OR (W.util_id <> 245228 AND W.type_id = 2)) AND (M.post_util_id = 245228 OR M.dest_util_id = 245228) 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=245228 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 = 250157 AND W.type_id = 1) OR (W.util_id <> 250157 AND W.type_id = 2)) AND (M.post_util_id = 250157 OR M.dest_util_id = 250157) 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=250157 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 = 203657 AND W.type_id = 1) OR (W.util_id <> 203657 AND W.type_id = 2)) AND (M.post_util_id = 203657 OR M.dest_util_id = 203657) 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=203657 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 = 254073 AND W.type_id = 1) OR (W.util_id <> 254073 AND W.type_id = 2)) AND (M.post_util_id = 254073 OR M.dest_util_id = 254073) 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=254073 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 = 261194 AND W.type_id = 1) OR (W.util_id <> 261194 AND W.type_id = 2)) AND (M.post_util_id = 261194 OR M.dest_util_id = 261194) 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=261194 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 = 272809 AND W.type_id = 1) OR (W.util_id <> 272809 AND W.type_id = 2)) AND (M.post_util_id = 272809 OR M.dest_util_id = 272809) 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=272809 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 = 277299 AND W.type_id = 1) OR (W.util_id <> 277299 AND W.type_id = 2)) AND (M.post_util_id = 277299 OR M.dest_util_id = 277299) 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=277299 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 = 300457 AND W.type_id = 1) OR (W.util_id <> 300457 AND W.type_id = 2)) AND (M.post_util_id = 300457 OR M.dest_util_id = 300457) 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=300457 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 = 306604 AND W.type_id = 1) OR (W.util_id <> 306604 AND W.type_id = 2)) AND (M.post_util_id = 306604 OR M.dest_util_id = 306604) 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=306604 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 = 330598 AND W.type_id = 1) OR (W.util_id <> 330598 AND W.type_id = 2)) AND (M.post_util_id = 330598 OR M.dest_util_id = 330598) 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=330598 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 = 285481 AND W.type_id = 1) OR (W.util_id <> 285481 AND W.type_id = 2)) AND (M.post_util_id = 285481 OR M.dest_util_id = 285481) 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=285481 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 = 267855 AND W.type_id = 1) OR (W.util_id <> 267855 AND W.type_id = 2)) AND (M.post_util_id = 267855 OR M.dest_util_id = 267855) 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=267855 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 = 329212 AND W.type_id = 1) OR (W.util_id <> 329212 AND W.type_id = 2)) AND (M.post_util_id = 329212 OR M.dest_util_id = 329212) 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=329212 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 = 333530 AND W.type_id = 1) OR (W.util_id <> 333530 AND W.type_id = 2)) AND (M.post_util_id = 333530 OR M.dest_util_id = 333530) 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=333530 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 = 344720 AND W.type_id = 1) OR (W.util_id <> 344720 AND W.type_id = 2)) AND (M.post_util_id = 344720 OR M.dest_util_id = 344720) 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=344720 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 = 358137 AND W.type_id = 1) OR (W.util_id <> 358137 AND W.type_id = 2)) AND (M.post_util_id = 358137 OR M.dest_util_id = 358137) 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=358137 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 = 385731 AND W.type_id = 1) OR (W.util_id <> 385731 AND W.type_id = 2)) AND (M.post_util_id = 385731 OR M.dest_util_id = 385731) 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=385731 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 = 259967 AND W.type_id = 1) OR (W.util_id <> 259967 AND W.type_id = 2)) AND (M.post_util_id = 259967 OR M.dest_util_id = 259967) 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=259967 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 = 400755 AND W.type_id = 1) OR (W.util_id <> 400755 AND W.type_id = 2)) AND (M.post_util_id = 400755 OR M.dest_util_id = 400755) 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=400755 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 = 407061 AND W.type_id = 1) OR (W.util_id <> 407061 AND W.type_id = 2)) AND (M.post_util_id = 407061 OR M.dest_util_id = 407061) 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=407061 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 = 427448 AND W.type_id = 1) OR (W.util_id <> 427448 AND W.type_id = 2)) AND (M.post_util_id = 427448 OR M.dest_util_id = 427448) 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=427448 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 = 430379 AND W.type_id = 1) OR (W.util_id <> 430379 AND W.type_id = 2)) AND (M.post_util_id = 430379 OR M.dest_util_id = 430379) 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=430379 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 = 426894 AND W.type_id = 1) OR (W.util_id <> 426894 AND W.type_id = 2)) AND (M.post_util_id = 426894 OR M.dest_util_id = 426894) 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=426894 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 = 449348 AND W.type_id = 1) OR (W.util_id <> 449348 AND W.type_id = 2)) AND (M.post_util_id = 449348 OR M.dest_util_id = 449348) 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=449348 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 = 453419 AND W.type_id = 1) OR (W.util_id <> 453419 AND W.type_id = 2)) AND (M.post_util_id = 453419 OR M.dest_util_id = 453419) 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=453419 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 = 61221 AND W.type_id = 1) OR (W.util_id <> 61221 AND W.type_id = 2)) AND (M.post_util_id = 61221 OR M.dest_util_id = 61221) 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=61221 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 = 372272 AND W.type_id = 1) OR (W.util_id <> 372272 AND W.type_id = 2)) AND (M.post_util_id = 372272 OR M.dest_util_id = 372272) 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=372272 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 = 490093 AND W.type_id = 1) OR (W.util_id <> 490093 AND W.type_id = 2)) AND (M.post_util_id = 490093 OR M.dest_util_id = 490093) 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=490093 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 = 498875 AND W.type_id = 1) OR (W.util_id <> 498875 AND W.type_id = 2)) AND (M.post_util_id = 498875 OR M.dest_util_id = 498875) 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=498875 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 = 516953 AND W.type_id = 1) OR (W.util_id <> 516953 AND W.type_id = 2)) AND (M.post_util_id = 516953 OR M.dest_util_id = 516953) 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=516953 AND note_visu IN (1,3,4)

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

  114. 0.0001

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

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

  116. 0.0001

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

  117. 0.0001

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

  118. 0.002

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.720135678816 AND ville_latitude_deg<49.079864321184 AND ville_longitude_deg>2.0263897328734 AND ville_longitude_deg<2.5736102671266 HAVING distance <= 20 ORDER BY distance ASC

  119. 0.0068

    SELECT ville_cp, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.450339197041 AND ville_latitude_deg<49.349660802959 AND ville_longitude_deg>1.6159684337256 AND ville_longitude_deg<2.9840315662744 HAVING distance <= 50 ORDER BY distance ASC

  120. 0.0002

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

  121. 0.0001

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

  122. 0

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

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

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

  125. 0.0009

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

  126. 0.0222

    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'

  127. 0.0175

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

127 requetes sql en 0.078

Taille variable Globale : 96.73 KB