Service réparateur à Paris 75001Service réparateur à Paris 75001à domicile entre voisins. Jobbing Réparateur entre particuliers. Kiwiiz

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
0.0001
SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='depanneur-reparateur'
0
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=231
0.0001
SELECT filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('75' USING utf8mb4) COLLATE utf8mb4_general_ci
0.0001
SELECT ville_nom FROM villes WHERE ville_cp='75001' AND ville_nom like '%paris%' ORDER BY ville_population_2012 DESC LIMIT 0,1
0.0001
SHOW TABLES LIKE 'pays'
0.0002
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
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
0.0001
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='75001'
0.0022
SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.680135678816 AND ville_latitude_deg<49.039864321184 AND ville_longitude_deg>2.0710584569437 AND ville_longitude_deg<2.6178415430563 HAVING distance <= 20 ORDER BY distance ASC
0.0005
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<>''
0.0009
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='231' AND wish_visu IN (1,6,10) AND wish_cp like '75001%'
0.0001
SELECT * FROM texte WHERE cate_id=231
0.0001
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='75001'
0.0008
SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.797047487586 AND ville_latitude_deg<48.922952512414 AND ville_longitude_deg>2.2487630978401 AND ville_longitude_deg<2.4401369021599 HAVING distance <= 7 ORDER BY distance ASC
0.0077
SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.410339197041 AND ville_latitude_deg<49.309660802959 AND ville_longitude_deg>1.6609652486165 AND ville_longitude_deg<3.0279347513835 HAVING distance <= 50 ORDER BY distance ASC
0.0298
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.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- 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='231' AND wish_visu IN (1,6,10) AND wish_cp IN (75001,75007,75002,75000,75001,75017,75006,75116,75020,75018,75015,75019,75003,75004,75014,75013,75012,75011,75010,75009,75008,75016,75005,92170,93400,93310,94250,94270,92120,93170,92110,94205,94200,92240,93500,94160,92200,92300,93100,94300,94110,94800,93120,93300,93230,93260,92600,94220,92220,92130,92100,92400,92320,92800,92150,93450,92390,92250,93200,93210,92270,94140,94233,94235,94231,94232,94236,94237,94234,94230,94239,94238,94240,92140,92230,93000,93130,94700,92700,94400,92360,92190,92210,94410,92260,92330,92340,93350,93140,94340,93110,94120,92350,93800,94550,93240,94130,94320,92500,93430,93700,93150,93440,94170,92000,92310,94600,93250,92290,92410,95360,92380,93380,95880,95100,94150,78800,94000,95870,94260,92370,93360,92160,95218,95210,92420,92430,94390,94310,94360,95140,94100,94210,94340,78420,93320,93340,91370,94500,95500,78140,95410,95110,95170,93330,93220,95230,91320,94430,78170,78400,94380,78220,95400,91300,95120,94290,94460,94350,91570,78500,78290,78380,78360,95160,95350,95500,95400,95200,95580,95580,95130,91550,93270,94190,93600,95600,93460,93190,93390,93160,91200,78150,78350,78430,95530,94480,78000,93370,78560,91430,78150,94420,78110,94380,94370,95240,94490,94880,94880,91120,78600,94450,95350,95130,94470,91430,95440,91560,91420,95500,95680,78600,95370,91160,91380,93410,93420,95390,78230,91270,93470,77181,95500,95720,78530,78350,91160,77420,95320,77500,91140,78160,78870,91400,78750,95330,95460,91230,94510,95190,91330,78100,91260,95720) AND type_id=1 GROUP BY wish_id
0.0012
SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (19403,22471,24548,32408,38748,40535,44104,42590,47496,59022,59798,59877,60664,63876,50564,57423,69176,69823,62563,2546,73863,74082,68770,77295,79443,80637,81404,81459,75466,84164,85685,83197,86145,83350,92452,96411,98206,98502,98525,98790,100424,100673,102482,103964,106864,108290,109087,110970,111573,113080,113127,62433,114887,116125,117631,120850,121710,40211,122065,12540,124092,83225,124588,90225,125410,125456,116502,129076,129729,130899,131655,132805,132873,133309,133694,134234,79935,126904,136779,143726,144718,147840,149779,152716,86370,154416,148046,52599,160647,10531,163101,105032,152652,165668,112528,168421,171450,178162,38190,180910,173269,185806,186046,193524,197347,197629,200771,201393,203972,7740,208121,208305,205622,209862,31004,213149,214654,177830,220044,220555,212243,222804,10019,224477,225367,227669,228646,229462,228755,227958,232649,237871,237886,171695,241074,242363,242757,234765,245061,247268,250058,126285,233329,82134,235412,261808,262519,185528,215679,265473,271050,66864,277417,88046,278831,278944,279478,280768,280871,277299,270634,282588,209731,216278,227181,290915,120955,264734,292399,289029,128251,294294,295607,254147,28751,302525,303808,304388,200588,306262,258058,310139,310388,262874,308730,12612,230310,317950,250960,319954,323359,324296,323936,326223,323850,328498,120654,329548,46170,161508,339969,309464,341749,344700,349587,349935,350316,354413,356279,358515,361252,363877,364781,365299,367227,111977,369634,100949,370877,373393,376559,376867,378382,380584,380700,322816,383874,387475,389038,389107,390003,390990,254358,336281,396263,399184,77383,402376,91194,403681,27384,321736,407886,53678,180325,411733,311698,415606,421432,332348,41253,427383,432286,436329,396860,111961,441381,446145,446400,447007,447847,449430,455016,455857,412551,456375,301503,135787,74760,465921,212528,462406,472587,473313,475508,475843,476041,478394,479293,480697,156721,482655,488921,87618,478655,496473,467104,497057,225807,502907,503798,400093,387170,507500,507661,5981,511333,512719,513806,220309,520383,521878,521936,524235,524504,525805,526302,207753,392319,530755,533869,224902,537709,540196,415110,542333,536440,293705,545564,545634,546562,548462)
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 = 19403 AND W.type_id = 1) OR (W.util_id <> 19403 AND W.type_id = 2)) AND (M.post_util_id = 19403 OR M.dest_util_id = 19403) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=19403 AND note_visu IN (1,3,4)
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 = 22471 AND W.type_id = 1) OR (W.util_id <> 22471 AND W.type_id = 2)) AND (M.post_util_id = 22471 OR M.dest_util_id = 22471) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=22471 AND note_visu IN (1,3,4)
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 = 24548 AND W.type_id = 1) OR (W.util_id <> 24548 AND W.type_id = 2)) AND (M.post_util_id = 24548 OR M.dest_util_id = 24548) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=24548 AND note_visu IN (1,3,4)
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 = 32408 AND W.type_id = 1) OR (W.util_id <> 32408 AND W.type_id = 2)) AND (M.post_util_id = 32408 OR M.dest_util_id = 32408) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=32408 AND note_visu IN (1,3,4)
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 = 38748 AND W.type_id = 1) OR (W.util_id <> 38748 AND W.type_id = 2)) AND (M.post_util_id = 38748 OR M.dest_util_id = 38748) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=38748 AND note_visu IN (1,3,4)
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 = 40535 AND W.type_id = 1) OR (W.util_id <> 40535 AND W.type_id = 2)) AND (M.post_util_id = 40535 OR M.dest_util_id = 40535) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=40535 AND note_visu IN (1,3,4)
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 = 44104 AND W.type_id = 1) OR (W.util_id <> 44104 AND W.type_id = 2)) AND (M.post_util_id = 44104 OR M.dest_util_id = 44104) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=44104 AND note_visu IN (1,3,4)
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 = 42590 AND W.type_id = 1) OR (W.util_id <> 42590 AND W.type_id = 2)) AND (M.post_util_id = 42590 OR M.dest_util_id = 42590) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=42590 AND note_visu IN (1,3,4)
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 = 47496 AND W.type_id = 1) OR (W.util_id <> 47496 AND W.type_id = 2)) AND (M.post_util_id = 47496 OR M.dest_util_id = 47496) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=47496 AND note_visu IN (1,3,4)
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 = 59022 AND W.type_id = 1) OR (W.util_id <> 59022 AND W.type_id = 2)) AND (M.post_util_id = 59022 OR M.dest_util_id = 59022) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=59022 AND note_visu IN (1,3,4)
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 = 59798 AND W.type_id = 1) OR (W.util_id <> 59798 AND W.type_id = 2)) AND (M.post_util_id = 59798 OR M.dest_util_id = 59798) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=59798 AND note_visu IN (1,3,4)
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 = 59877 AND W.type_id = 1) OR (W.util_id <> 59877 AND W.type_id = 2)) AND (M.post_util_id = 59877 OR M.dest_util_id = 59877) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=59877 AND note_visu IN (1,3,4)
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 = 60664 AND W.type_id = 1) OR (W.util_id <> 60664 AND W.type_id = 2)) AND (M.post_util_id = 60664 OR M.dest_util_id = 60664) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=60664 AND note_visu IN (1,3,4)
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 = 63876 AND W.type_id = 1) OR (W.util_id <> 63876 AND W.type_id = 2)) AND (M.post_util_id = 63876 OR M.dest_util_id = 63876) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=63876 AND note_visu IN (1,3,4)
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 = 50564 AND W.type_id = 1) OR (W.util_id <> 50564 AND W.type_id = 2)) AND (M.post_util_id = 50564 OR M.dest_util_id = 50564) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=50564 AND note_visu IN (1,3,4)
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 = 57423 AND W.type_id = 1) OR (W.util_id <> 57423 AND W.type_id = 2)) AND (M.post_util_id = 57423 OR M.dest_util_id = 57423) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=57423 AND note_visu IN (1,3,4)
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 = 69176 AND W.type_id = 1) OR (W.util_id <> 69176 AND W.type_id = 2)) AND (M.post_util_id = 69176 OR M.dest_util_id = 69176) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=69176 AND note_visu IN (1,3,4)
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 = 69823 AND W.type_id = 1) OR (W.util_id <> 69823 AND W.type_id = 2)) AND (M.post_util_id = 69823 OR M.dest_util_id = 69823) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=69823 AND note_visu IN (1,3,4)
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 = 62563 AND W.type_id = 1) OR (W.util_id <> 62563 AND W.type_id = 2)) AND (M.post_util_id = 62563 OR M.dest_util_id = 62563) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=62563 AND note_visu IN (1,3,4)
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 = 2546 AND W.type_id = 1) OR (W.util_id <> 2546 AND W.type_id = 2)) AND (M.post_util_id = 2546 OR M.dest_util_id = 2546) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=2546 AND note_visu IN (1,3,4)
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 = 73863 AND W.type_id = 1) OR (W.util_id <> 73863 AND W.type_id = 2)) AND (M.post_util_id = 73863 OR M.dest_util_id = 73863) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=73863 AND note_visu IN (1,3,4)
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 = 74082 AND W.type_id = 1) OR (W.util_id <> 74082 AND W.type_id = 2)) AND (M.post_util_id = 74082 OR M.dest_util_id = 74082) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=74082 AND note_visu IN (1,3,4)
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 = 68770 AND W.type_id = 1) OR (W.util_id <> 68770 AND W.type_id = 2)) AND (M.post_util_id = 68770 OR M.dest_util_id = 68770) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=68770 AND note_visu IN (1,3,4)
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 = 77295 AND W.type_id = 1) OR (W.util_id <> 77295 AND W.type_id = 2)) AND (M.post_util_id = 77295 OR M.dest_util_id = 77295) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=77295 AND note_visu IN (1,3,4)
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 = 79443 AND W.type_id = 1) OR (W.util_id <> 79443 AND W.type_id = 2)) AND (M.post_util_id = 79443 OR M.dest_util_id = 79443) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=79443 AND note_visu IN (1,3,4)
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 = 80637 AND W.type_id = 1) OR (W.util_id <> 80637 AND W.type_id = 2)) AND (M.post_util_id = 80637 OR M.dest_util_id = 80637) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=80637 AND note_visu IN (1,3,4)
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 = 81404 AND W.type_id = 1) OR (W.util_id <> 81404 AND W.type_id = 2)) AND (M.post_util_id = 81404 OR M.dest_util_id = 81404) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=81404 AND note_visu IN (1,3,4)
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 = 81459 AND W.type_id = 1) OR (W.util_id <> 81459 AND W.type_id = 2)) AND (M.post_util_id = 81459 OR M.dest_util_id = 81459) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=81459 AND note_visu IN (1,3,4)
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 = 75466 AND W.type_id = 1) OR (W.util_id <> 75466 AND W.type_id = 2)) AND (M.post_util_id = 75466 OR M.dest_util_id = 75466) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=75466 AND note_visu IN (1,3,4)
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 = 84164 AND W.type_id = 1) OR (W.util_id <> 84164 AND W.type_id = 2)) AND (M.post_util_id = 84164 OR M.dest_util_id = 84164) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=84164 AND note_visu IN (1,3,4)
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 = 85685 AND W.type_id = 1) OR (W.util_id <> 85685 AND W.type_id = 2)) AND (M.post_util_id = 85685 OR M.dest_util_id = 85685) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=85685 AND note_visu IN (1,3,4)
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 = 83197 AND W.type_id = 1) OR (W.util_id <> 83197 AND W.type_id = 2)) AND (M.post_util_id = 83197 OR M.dest_util_id = 83197) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=83197 AND note_visu IN (1,3,4)
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 = 86145 AND W.type_id = 1) OR (W.util_id <> 86145 AND W.type_id = 2)) AND (M.post_util_id = 86145 OR M.dest_util_id = 86145) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=86145 AND note_visu IN (1,3,4)
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 = 83350 AND W.type_id = 1) OR (W.util_id <> 83350 AND W.type_id = 2)) AND (M.post_util_id = 83350 OR M.dest_util_id = 83350) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=83350 AND note_visu IN (1,3,4)
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 = 92452 AND W.type_id = 1) OR (W.util_id <> 92452 AND W.type_id = 2)) AND (M.post_util_id = 92452 OR M.dest_util_id = 92452) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=92452 AND note_visu IN (1,3,4)
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 = 96411 AND W.type_id = 1) OR (W.util_id <> 96411 AND W.type_id = 2)) AND (M.post_util_id = 96411 OR M.dest_util_id = 96411) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=96411 AND note_visu IN (1,3,4)
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 = 98206 AND W.type_id = 1) OR (W.util_id <> 98206 AND W.type_id = 2)) AND (M.post_util_id = 98206 OR M.dest_util_id = 98206) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=98206 AND note_visu IN (1,3,4)
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 = 98502 AND W.type_id = 1) OR (W.util_id <> 98502 AND W.type_id = 2)) AND (M.post_util_id = 98502 OR M.dest_util_id = 98502) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=98502 AND note_visu IN (1,3,4)
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 = 98525 AND W.type_id = 1) OR (W.util_id <> 98525 AND W.type_id = 2)) AND (M.post_util_id = 98525 OR M.dest_util_id = 98525) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=98525 AND note_visu IN (1,3,4)
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 = 98790 AND W.type_id = 1) OR (W.util_id <> 98790 AND W.type_id = 2)) AND (M.post_util_id = 98790 OR M.dest_util_id = 98790) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=98790 AND note_visu IN (1,3,4)
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 = 100424 AND W.type_id = 1) OR (W.util_id <> 100424 AND W.type_id = 2)) AND (M.post_util_id = 100424 OR M.dest_util_id = 100424) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=100424 AND note_visu IN (1,3,4)
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 = 100673 AND W.type_id = 1) OR (W.util_id <> 100673 AND W.type_id = 2)) AND (M.post_util_id = 100673 OR M.dest_util_id = 100673) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=100673 AND note_visu IN (1,3,4)
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 = 102482 AND W.type_id = 1) OR (W.util_id <> 102482 AND W.type_id = 2)) AND (M.post_util_id = 102482 OR M.dest_util_id = 102482) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=102482 AND note_visu IN (1,3,4)
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 = 103964 AND W.type_id = 1) OR (W.util_id <> 103964 AND W.type_id = 2)) AND (M.post_util_id = 103964 OR M.dest_util_id = 103964) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=103964 AND note_visu IN (1,3,4)
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 = 106864 AND W.type_id = 1) OR (W.util_id <> 106864 AND W.type_id = 2)) AND (M.post_util_id = 106864 OR M.dest_util_id = 106864) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=106864 AND note_visu IN (1,3,4)
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 = 108290 AND W.type_id = 1) OR (W.util_id <> 108290 AND W.type_id = 2)) AND (M.post_util_id = 108290 OR M.dest_util_id = 108290) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=108290 AND note_visu IN (1,3,4)
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 = 109087 AND W.type_id = 1) OR (W.util_id <> 109087 AND W.type_id = 2)) AND (M.post_util_id = 109087 OR M.dest_util_id = 109087) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=109087 AND note_visu IN (1,3,4)
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 = 110970 AND W.type_id = 1) OR (W.util_id <> 110970 AND W.type_id = 2)) AND (M.post_util_id = 110970 OR M.dest_util_id = 110970) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=110970 AND note_visu IN (1,3,4)
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 = 111573 AND W.type_id = 1) OR (W.util_id <> 111573 AND W.type_id = 2)) AND (M.post_util_id = 111573 OR M.dest_util_id = 111573) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=111573 AND note_visu IN (1,3,4)
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 = 113080 AND W.type_id = 1) OR (W.util_id <> 113080 AND W.type_id = 2)) AND (M.post_util_id = 113080 OR M.dest_util_id = 113080) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=113080 AND note_visu IN (1,3,4)
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 = 113127 AND W.type_id = 1) OR (W.util_id <> 113127 AND W.type_id = 2)) AND (M.post_util_id = 113127 OR M.dest_util_id = 113127) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=113127 AND note_visu IN (1,3,4)
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 = 62433 AND W.type_id = 1) OR (W.util_id <> 62433 AND W.type_id = 2)) AND (M.post_util_id = 62433 OR M.dest_util_id = 62433) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=62433 AND note_visu IN (1,3,4)
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 = 114887 AND W.type_id = 1) OR (W.util_id <> 114887 AND W.type_id = 2)) AND (M.post_util_id = 114887 OR M.dest_util_id = 114887) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=114887 AND note_visu IN (1,3,4)
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 = 116125 AND W.type_id = 1) OR (W.util_id <> 116125 AND W.type_id = 2)) AND (M.post_util_id = 116125 OR M.dest_util_id = 116125) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=116125 AND note_visu IN (1,3,4)
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 = 117631 AND W.type_id = 1) OR (W.util_id <> 117631 AND W.type_id = 2)) AND (M.post_util_id = 117631 OR M.dest_util_id = 117631) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=117631 AND note_visu IN (1,3,4)
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 = 120850 AND W.type_id = 1) OR (W.util_id <> 120850 AND W.type_id = 2)) AND (M.post_util_id = 120850 OR M.dest_util_id = 120850) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=120850 AND note_visu IN (1,3,4)
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 = 121710 AND W.type_id = 1) OR (W.util_id <> 121710 AND W.type_id = 2)) AND (M.post_util_id = 121710 OR M.dest_util_id = 121710) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=121710 AND note_visu IN (1,3,4)
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 = 40211 AND W.type_id = 1) OR (W.util_id <> 40211 AND W.type_id = 2)) AND (M.post_util_id = 40211 OR M.dest_util_id = 40211) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=40211 AND note_visu IN (1,3,4)
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 = 122065 AND W.type_id = 1) OR (W.util_id <> 122065 AND W.type_id = 2)) AND (M.post_util_id = 122065 OR M.dest_util_id = 122065) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=122065 AND note_visu IN (1,3,4)
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 = 12540 AND W.type_id = 1) OR (W.util_id <> 12540 AND W.type_id = 2)) AND (M.post_util_id = 12540 OR M.dest_util_id = 12540) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=12540 AND note_visu IN (1,3,4)
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 = 124092 AND W.type_id = 1) OR (W.util_id <> 124092 AND W.type_id = 2)) AND (M.post_util_id = 124092 OR M.dest_util_id = 124092) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=124092 AND note_visu IN (1,3,4)
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 = 83225 AND W.type_id = 1) OR (W.util_id <> 83225 AND W.type_id = 2)) AND (M.post_util_id = 83225 OR M.dest_util_id = 83225) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=83225 AND note_visu IN (1,3,4)
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 = 124588 AND W.type_id = 1) OR (W.util_id <> 124588 AND W.type_id = 2)) AND (M.post_util_id = 124588 OR M.dest_util_id = 124588) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=124588 AND note_visu IN (1,3,4)
0.0003
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 = 90225 AND W.type_id = 1) OR (W.util_id <> 90225 AND W.type_id = 2)) AND (M.post_util_id = 90225 OR M.dest_util_id = 90225) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=90225 AND note_visu IN (1,3,4)
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 = 125410 AND W.type_id = 1) OR (W.util_id <> 125410 AND W.type_id = 2)) AND (M.post_util_id = 125410 OR M.dest_util_id = 125410) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=125410 AND note_visu IN (1,3,4)
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 = 125456 AND W.type_id = 1) OR (W.util_id <> 125456 AND W.type_id = 2)) AND (M.post_util_id = 125456 OR M.dest_util_id = 125456) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=125456 AND note_visu IN (1,3,4)
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 = 116502 AND W.type_id = 1) OR (W.util_id <> 116502 AND W.type_id = 2)) AND (M.post_util_id = 116502 OR M.dest_util_id = 116502) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=116502 AND note_visu IN (1,3,4)
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 = 129076 AND W.type_id = 1) OR (W.util_id <> 129076 AND W.type_id = 2)) AND (M.post_util_id = 129076 OR M.dest_util_id = 129076) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=129076 AND note_visu IN (1,3,4)
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 = 129729 AND W.type_id = 1) OR (W.util_id <> 129729 AND W.type_id = 2)) AND (M.post_util_id = 129729 OR M.dest_util_id = 129729) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=129729 AND note_visu IN (1,3,4)
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 = 130899 AND W.type_id = 1) OR (W.util_id <> 130899 AND W.type_id = 2)) AND (M.post_util_id = 130899 OR M.dest_util_id = 130899) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=130899 AND note_visu IN (1,3,4)
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 = 131655 AND W.type_id = 1) OR (W.util_id <> 131655 AND W.type_id = 2)) AND (M.post_util_id = 131655 OR M.dest_util_id = 131655) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=131655 AND note_visu IN (1,3,4)
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 = 132805 AND W.type_id = 1) OR (W.util_id <> 132805 AND W.type_id = 2)) AND (M.post_util_id = 132805 OR M.dest_util_id = 132805) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=132805 AND note_visu IN (1,3,4)
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 = 132873 AND W.type_id = 1) OR (W.util_id <> 132873 AND W.type_id = 2)) AND (M.post_util_id = 132873 OR M.dest_util_id = 132873) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=132873 AND note_visu IN (1,3,4)
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 = 133309 AND W.type_id = 1) OR (W.util_id <> 133309 AND W.type_id = 2)) AND (M.post_util_id = 133309 OR M.dest_util_id = 133309) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=133309 AND note_visu IN (1,3,4)
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 = 133694 AND W.type_id = 1) OR (W.util_id <> 133694 AND W.type_id = 2)) AND (M.post_util_id = 133694 OR M.dest_util_id = 133694) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=133694 AND note_visu IN (1,3,4)
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 = 134234 AND W.type_id = 1) OR (W.util_id <> 134234 AND W.type_id = 2)) AND (M.post_util_id = 134234 OR M.dest_util_id = 134234) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=134234 AND note_visu IN (1,3,4)
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 = 79935 AND W.type_id = 1) OR (W.util_id <> 79935 AND W.type_id = 2)) AND (M.post_util_id = 79935 OR M.dest_util_id = 79935) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=79935 AND note_visu IN (1,3,4)
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 = 126904 AND W.type_id = 1) OR (W.util_id <> 126904 AND W.type_id = 2)) AND (M.post_util_id = 126904 OR M.dest_util_id = 126904) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=126904 AND note_visu IN (1,3,4)
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 = 136779 AND W.type_id = 1) OR (W.util_id <> 136779 AND W.type_id = 2)) AND (M.post_util_id = 136779 OR M.dest_util_id = 136779) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=136779 AND note_visu IN (1,3,4)
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 = 143726 AND W.type_id = 1) OR (W.util_id <> 143726 AND W.type_id = 2)) AND (M.post_util_id = 143726 OR M.dest_util_id = 143726) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=143726 AND note_visu IN (1,3,4)
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 = 144718 AND W.type_id = 1) OR (W.util_id <> 144718 AND W.type_id = 2)) AND (M.post_util_id = 144718 OR M.dest_util_id = 144718) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=144718 AND note_visu IN (1,3,4)
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 = 147840 AND W.type_id = 1) OR (W.util_id <> 147840 AND W.type_id = 2)) AND (M.post_util_id = 147840 OR M.dest_util_id = 147840) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=147840 AND note_visu IN (1,3,4)
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 = 149779 AND W.type_id = 1) OR (W.util_id <> 149779 AND W.type_id = 2)) AND (M.post_util_id = 149779 OR M.dest_util_id = 149779) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=149779 AND note_visu IN (1,3,4)
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 = 152716 AND W.type_id = 1) OR (W.util_id <> 152716 AND W.type_id = 2)) AND (M.post_util_id = 152716 OR M.dest_util_id = 152716) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=152716 AND note_visu IN (1,3,4)
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 = 86370 AND W.type_id = 1) OR (W.util_id <> 86370 AND W.type_id = 2)) AND (M.post_util_id = 86370 OR M.dest_util_id = 86370) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=86370 AND note_visu IN (1,3,4)
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 = 154416 AND W.type_id = 1) OR (W.util_id <> 154416 AND W.type_id = 2)) AND (M.post_util_id = 154416 OR M.dest_util_id = 154416) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=154416 AND note_visu IN (1,3,4)
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 = 148046 AND W.type_id = 1) OR (W.util_id <> 148046 AND W.type_id = 2)) AND (M.post_util_id = 148046 OR M.dest_util_id = 148046) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=148046 AND note_visu IN (1,3,4)
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 = 52599 AND W.type_id = 1) OR (W.util_id <> 52599 AND W.type_id = 2)) AND (M.post_util_id = 52599 OR M.dest_util_id = 52599) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=52599 AND note_visu IN (1,3,4)
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 = 160647 AND W.type_id = 1) OR (W.util_id <> 160647 AND W.type_id = 2)) AND (M.post_util_id = 160647 OR M.dest_util_id = 160647) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=160647 AND note_visu IN (1,3,4)
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 = 10531 AND W.type_id = 1) OR (W.util_id <> 10531 AND W.type_id = 2)) AND (M.post_util_id = 10531 OR M.dest_util_id = 10531) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=10531 AND note_visu IN (1,3,4)
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 = 163101 AND W.type_id = 1) OR (W.util_id <> 163101 AND W.type_id = 2)) AND (M.post_util_id = 163101 OR M.dest_util_id = 163101) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=163101 AND note_visu IN (1,3,4)
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 = 105032 AND W.type_id = 1) OR (W.util_id <> 105032 AND W.type_id = 2)) AND (M.post_util_id = 105032 OR M.dest_util_id = 105032) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=105032 AND note_visu IN (1,3,4)
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 = 152652 AND W.type_id = 1) OR (W.util_id <> 152652 AND W.type_id = 2)) AND (M.post_util_id = 152652 OR M.dest_util_id = 152652) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=152652 AND note_visu IN (1,3,4)
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 = 165668 AND W.type_id = 1) OR (W.util_id <> 165668 AND W.type_id = 2)) AND (M.post_util_id = 165668 OR M.dest_util_id = 165668) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=165668 AND note_visu IN (1,3,4)
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 = 112528 AND W.type_id = 1) OR (W.util_id <> 112528 AND W.type_id = 2)) AND (M.post_util_id = 112528 OR M.dest_util_id = 112528) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=112528 AND note_visu IN (1,3,4)
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 = 168421 AND W.type_id = 1) OR (W.util_id <> 168421 AND W.type_id = 2)) AND (M.post_util_id = 168421 OR M.dest_util_id = 168421) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=168421 AND note_visu IN (1,3,4)
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 = 171450 AND W.type_id = 1) OR (W.util_id <> 171450 AND W.type_id = 2)) AND (M.post_util_id = 171450 OR M.dest_util_id = 171450) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=171450 AND note_visu IN (1,3,4)
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 = 178162 AND W.type_id = 1) OR (W.util_id <> 178162 AND W.type_id = 2)) AND (M.post_util_id = 178162 OR M.dest_util_id = 178162) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=178162 AND note_visu IN (1,3,4)
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 = 38190 AND W.type_id = 1) OR (W.util_id <> 38190 AND W.type_id = 2)) AND (M.post_util_id = 38190 OR M.dest_util_id = 38190) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=38190 AND note_visu IN (1,3,4)
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 = 180910 AND W.type_id = 1) OR (W.util_id <> 180910 AND W.type_id = 2)) AND (M.post_util_id = 180910 OR M.dest_util_id = 180910) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=180910 AND note_visu IN (1,3,4)
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 = 173269 AND W.type_id = 1) OR (W.util_id <> 173269 AND W.type_id = 2)) AND (M.post_util_id = 173269 OR M.dest_util_id = 173269) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=173269 AND note_visu IN (1,3,4)
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 = 185806 AND W.type_id = 1) OR (W.util_id <> 185806 AND W.type_id = 2)) AND (M.post_util_id = 185806 OR M.dest_util_id = 185806) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=185806 AND note_visu IN (1,3,4)
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 = 186046 AND W.type_id = 1) OR (W.util_id <> 186046 AND W.type_id = 2)) AND (M.post_util_id = 186046 OR M.dest_util_id = 186046) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=186046 AND note_visu IN (1,3,4)
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 = 193524 AND W.type_id = 1) OR (W.util_id <> 193524 AND W.type_id = 2)) AND (M.post_util_id = 193524 OR M.dest_util_id = 193524) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=193524 AND note_visu IN (1,3,4)
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 = 197347 AND W.type_id = 1) OR (W.util_id <> 197347 AND W.type_id = 2)) AND (M.post_util_id = 197347 OR M.dest_util_id = 197347) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=197347 AND note_visu IN (1,3,4)
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 = 197629 AND W.type_id = 1) OR (W.util_id <> 197629 AND W.type_id = 2)) AND (M.post_util_id = 197629 OR M.dest_util_id = 197629) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=197629 AND note_visu IN (1,3,4)
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 = 200771 AND W.type_id = 1) OR (W.util_id <> 200771 AND W.type_id = 2)) AND (M.post_util_id = 200771 OR M.dest_util_id = 200771) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=200771 AND note_visu IN (1,3,4)
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 = 201393 AND W.type_id = 1) OR (W.util_id <> 201393 AND W.type_id = 2)) AND (M.post_util_id = 201393 OR M.dest_util_id = 201393) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=201393 AND note_visu IN (1,3,4)
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 = 203972 AND W.type_id = 1) OR (W.util_id <> 203972 AND W.type_id = 2)) AND (M.post_util_id = 203972 OR M.dest_util_id = 203972) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=203972 AND note_visu IN (1,3,4)
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 = 7740 AND W.type_id = 1) OR (W.util_id <> 7740 AND W.type_id = 2)) AND (M.post_util_id = 7740 OR M.dest_util_id = 7740) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=7740 AND note_visu IN (1,3,4)
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 = 208121 AND W.type_id = 1) OR (W.util_id <> 208121 AND W.type_id = 2)) AND (M.post_util_id = 208121 OR M.dest_util_id = 208121) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=208121 AND note_visu IN (1,3,4)
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 = 208305 AND W.type_id = 1) OR (W.util_id <> 208305 AND W.type_id = 2)) AND (M.post_util_id = 208305 OR M.dest_util_id = 208305) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=208305 AND note_visu IN (1,3,4)
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 = 205622 AND W.type_id = 1) OR (W.util_id <> 205622 AND W.type_id = 2)) AND (M.post_util_id = 205622 OR M.dest_util_id = 205622) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=205622 AND note_visu IN (1,3,4)
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 = 209862 AND W.type_id = 1) OR (W.util_id <> 209862 AND W.type_id = 2)) AND (M.post_util_id = 209862 OR M.dest_util_id = 209862) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=209862 AND note_visu IN (1,3,4)
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 = 31004 AND W.type_id = 1) OR (W.util_id <> 31004 AND W.type_id = 2)) AND (M.post_util_id = 31004 OR M.dest_util_id = 31004) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=31004 AND note_visu IN (1,3,4)
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 = 213149 AND W.type_id = 1) OR (W.util_id <> 213149 AND W.type_id = 2)) AND (M.post_util_id = 213149 OR M.dest_util_id = 213149) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=213149 AND note_visu IN (1,3,4)
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 = 214654 AND W.type_id = 1) OR (W.util_id <> 214654 AND W.type_id = 2)) AND (M.post_util_id = 214654 OR M.dest_util_id = 214654) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=214654 AND note_visu IN (1,3,4)
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 = 177830 AND W.type_id = 1) OR (W.util_id <> 177830 AND W.type_id = 2)) AND (M.post_util_id = 177830 OR M.dest_util_id = 177830) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=177830 AND note_visu IN (1,3,4)
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 = 220044 AND W.type_id = 1) OR (W.util_id <> 220044 AND W.type_id = 2)) AND (M.post_util_id = 220044 OR M.dest_util_id = 220044) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=220044 AND note_visu IN (1,3,4)
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 = 220555 AND W.type_id = 1) OR (W.util_id <> 220555 AND W.type_id = 2)) AND (M.post_util_id = 220555 OR M.dest_util_id = 220555) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=220555 AND note_visu IN (1,3,4)
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 = 212243 AND W.type_id = 1) OR (W.util_id <> 212243 AND W.type_id = 2)) AND (M.post_util_id = 212243 OR M.dest_util_id = 212243) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=212243 AND note_visu IN (1,3,4)
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 = 222804 AND W.type_id = 1) OR (W.util_id <> 222804 AND W.type_id = 2)) AND (M.post_util_id = 222804 OR M.dest_util_id = 222804) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=222804 AND note_visu IN (1,3,4)
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 = 10019 AND W.type_id = 1) OR (W.util_id <> 10019 AND W.type_id = 2)) AND (M.post_util_id = 10019 OR M.dest_util_id = 10019) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=10019 AND note_visu IN (1,3,4)
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 = 224477 AND W.type_id = 1) OR (W.util_id <> 224477 AND W.type_id = 2)) AND (M.post_util_id = 224477 OR M.dest_util_id = 224477) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=224477 AND note_visu IN (1,3,4)
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 = 225367 AND W.type_id = 1) OR (W.util_id <> 225367 AND W.type_id = 2)) AND (M.post_util_id = 225367 OR M.dest_util_id = 225367) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=225367 AND note_visu IN (1,3,4)
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 = 227669 AND W.type_id = 1) OR (W.util_id <> 227669 AND W.type_id = 2)) AND (M.post_util_id = 227669 OR M.dest_util_id = 227669) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=227669 AND note_visu IN (1,3,4)
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 = 228646 AND W.type_id = 1) OR (W.util_id <> 228646 AND W.type_id = 2)) AND (M.post_util_id = 228646 OR M.dest_util_id = 228646) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=228646 AND note_visu IN (1,3,4)
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 = 229462 AND W.type_id = 1) OR (W.util_id <> 229462 AND W.type_id = 2)) AND (M.post_util_id = 229462 OR M.dest_util_id = 229462) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=229462 AND note_visu IN (1,3,4)
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 = 228755 AND W.type_id = 1) OR (W.util_id <> 228755 AND W.type_id = 2)) AND (M.post_util_id = 228755 OR M.dest_util_id = 228755) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=228755 AND note_visu IN (1,3,4)
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 = 227958 AND W.type_id = 1) OR (W.util_id <> 227958 AND W.type_id = 2)) AND (M.post_util_id = 227958 OR M.dest_util_id = 227958) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=227958 AND note_visu IN (1,3,4)
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 = 232649 AND W.type_id = 1) OR (W.util_id <> 232649 AND W.type_id = 2)) AND (M.post_util_id = 232649 OR M.dest_util_id = 232649) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=232649 AND note_visu IN (1,3,4)
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 = 237871 AND W.type_id = 1) OR (W.util_id <> 237871 AND W.type_id = 2)) AND (M.post_util_id = 237871 OR M.dest_util_id = 237871) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=237871 AND note_visu IN (1,3,4)
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 = 237886 AND W.type_id = 1) OR (W.util_id <> 237886 AND W.type_id = 2)) AND (M.post_util_id = 237886 OR M.dest_util_id = 237886) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=237886 AND note_visu IN (1,3,4)
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 = 171695 AND W.type_id = 1) OR (W.util_id <> 171695 AND W.type_id = 2)) AND (M.post_util_id = 171695 OR M.dest_util_id = 171695) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=171695 AND note_visu IN (1,3,4)
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 = 241074 AND W.type_id = 1) OR (W.util_id <> 241074 AND W.type_id = 2)) AND (M.post_util_id = 241074 OR M.dest_util_id = 241074) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=241074 AND note_visu IN (1,3,4)
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 = 242363 AND W.type_id = 1) OR (W.util_id <> 242363 AND W.type_id = 2)) AND (M.post_util_id = 242363 OR M.dest_util_id = 242363) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=242363 AND note_visu IN (1,3,4)
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 = 242757 AND W.type_id = 1) OR (W.util_id <> 242757 AND W.type_id = 2)) AND (M.post_util_id = 242757 OR M.dest_util_id = 242757) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=242757 AND note_visu IN (1,3,4)
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 = 234765 AND W.type_id = 1) OR (W.util_id <> 234765 AND W.type_id = 2)) AND (M.post_util_id = 234765 OR M.dest_util_id = 234765) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=234765 AND note_visu IN (1,3,4)
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 = 245061 AND W.type_id = 1) OR (W.util_id <> 245061 AND W.type_id = 2)) AND (M.post_util_id = 245061 OR M.dest_util_id = 245061) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=245061 AND note_visu IN (1,3,4)
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 = 247268 AND W.type_id = 1) OR (W.util_id <> 247268 AND W.type_id = 2)) AND (M.post_util_id = 247268 OR M.dest_util_id = 247268) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=247268 AND note_visu IN (1,3,4)
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 = 250058 AND W.type_id = 1) OR (W.util_id <> 250058 AND W.type_id = 2)) AND (M.post_util_id = 250058 OR M.dest_util_id = 250058) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=250058 AND note_visu IN (1,3,4)
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 = 126285 AND W.type_id = 1) OR (W.util_id <> 126285 AND W.type_id = 2)) AND (M.post_util_id = 126285 OR M.dest_util_id = 126285) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=126285 AND note_visu IN (1,3,4)
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 = 233329 AND W.type_id = 1) OR (W.util_id <> 233329 AND W.type_id = 2)) AND (M.post_util_id = 233329 OR M.dest_util_id = 233329) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=233329 AND note_visu IN (1,3,4)
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 = 82134 AND W.type_id = 1) OR (W.util_id <> 82134 AND W.type_id = 2)) AND (M.post_util_id = 82134 OR M.dest_util_id = 82134) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=82134 AND note_visu IN (1,3,4)
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 = 235412 AND W.type_id = 1) OR (W.util_id <> 235412 AND W.type_id = 2)) AND (M.post_util_id = 235412 OR M.dest_util_id = 235412) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=235412 AND note_visu IN (1,3,4)
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 = 261808 AND W.type_id = 1) OR (W.util_id <> 261808 AND W.type_id = 2)) AND (M.post_util_id = 261808 OR M.dest_util_id = 261808) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=261808 AND note_visu IN (1,3,4)
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 = 262519 AND W.type_id = 1) OR (W.util_id <> 262519 AND W.type_id = 2)) AND (M.post_util_id = 262519 OR M.dest_util_id = 262519) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=262519 AND note_visu IN (1,3,4)
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 = 185528 AND W.type_id = 1) OR (W.util_id <> 185528 AND W.type_id = 2)) AND (M.post_util_id = 185528 OR M.dest_util_id = 185528) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=185528 AND note_visu IN (1,3,4)
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 = 215679 AND W.type_id = 1) OR (W.util_id <> 215679 AND W.type_id = 2)) AND (M.post_util_id = 215679 OR M.dest_util_id = 215679) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=215679 AND note_visu IN (1,3,4)
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 = 265473 AND W.type_id = 1) OR (W.util_id <> 265473 AND W.type_id = 2)) AND (M.post_util_id = 265473 OR M.dest_util_id = 265473) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=265473 AND note_visu IN (1,3,4)
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 = 271050 AND W.type_id = 1) OR (W.util_id <> 271050 AND W.type_id = 2)) AND (M.post_util_id = 271050 OR M.dest_util_id = 271050) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=271050 AND note_visu IN (1,3,4)
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 = 66864 AND W.type_id = 1) OR (W.util_id <> 66864 AND W.type_id = 2)) AND (M.post_util_id = 66864 OR M.dest_util_id = 66864) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=66864 AND note_visu IN (1,3,4)
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 = 277417 AND W.type_id = 1) OR (W.util_id <> 277417 AND W.type_id = 2)) AND (M.post_util_id = 277417 OR M.dest_util_id = 277417) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=277417 AND note_visu IN (1,3,4)
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 = 88046 AND W.type_id = 1) OR (W.util_id <> 88046 AND W.type_id = 2)) AND (M.post_util_id = 88046 OR M.dest_util_id = 88046) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=88046 AND note_visu IN (1,3,4)
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 = 278831 AND W.type_id = 1) OR (W.util_id <> 278831 AND W.type_id = 2)) AND (M.post_util_id = 278831 OR M.dest_util_id = 278831) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=278831 AND note_visu IN (1,3,4)
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 = 278944 AND W.type_id = 1) OR (W.util_id <> 278944 AND W.type_id = 2)) AND (M.post_util_id = 278944 OR M.dest_util_id = 278944) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=278944 AND note_visu IN (1,3,4)
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 = 279478 AND W.type_id = 1) OR (W.util_id <> 279478 AND W.type_id = 2)) AND (M.post_util_id = 279478 OR M.dest_util_id = 279478) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=279478 AND note_visu IN (1,3,4)
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 = 280768 AND W.type_id = 1) OR (W.util_id <> 280768 AND W.type_id = 2)) AND (M.post_util_id = 280768 OR M.dest_util_id = 280768) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=280768 AND note_visu IN (1,3,4)
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 = 280871 AND W.type_id = 1) OR (W.util_id <> 280871 AND W.type_id = 2)) AND (M.post_util_id = 280871 OR M.dest_util_id = 280871) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=280871 AND note_visu IN (1,3,4)
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 <> ''
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)
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 = 270634 AND W.type_id = 1) OR (W.util_id <> 270634 AND W.type_id = 2)) AND (M.post_util_id = 270634 OR M.dest_util_id = 270634) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=270634 AND note_visu IN (1,3,4)
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 = 282588 AND W.type_id = 1) OR (W.util_id <> 282588 AND W.type_id = 2)) AND (M.post_util_id = 282588 OR M.dest_util_id = 282588) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=282588 AND note_visu IN (1,3,4)
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 = 209731 AND W.type_id = 1) OR (W.util_id <> 209731 AND W.type_id = 2)) AND (M.post_util_id = 209731 OR M.dest_util_id = 209731) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=209731 AND note_visu IN (1,3,4)
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 = 216278 AND W.type_id = 1) OR (W.util_id <> 216278 AND W.type_id = 2)) AND (M.post_util_id = 216278 OR M.dest_util_id = 216278) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=216278 AND note_visu IN (1,3,4)
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 = 227181 AND W.type_id = 1) OR (W.util_id <> 227181 AND W.type_id = 2)) AND (M.post_util_id = 227181 OR M.dest_util_id = 227181) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=227181 AND note_visu IN (1,3,4)
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 = 290915 AND W.type_id = 1) OR (W.util_id <> 290915 AND W.type_id = 2)) AND (M.post_util_id = 290915 OR M.dest_util_id = 290915) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=290915 AND note_visu IN (1,3,4)
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 = 120955 AND W.type_id = 1) OR (W.util_id <> 120955 AND W.type_id = 2)) AND (M.post_util_id = 120955 OR M.dest_util_id = 120955) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=120955 AND note_visu IN (1,3,4)
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 = 264734 AND W.type_id = 1) OR (W.util_id <> 264734 AND W.type_id = 2)) AND (M.post_util_id = 264734 OR M.dest_util_id = 264734) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=264734 AND note_visu IN (1,3,4)
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 = 292399 AND W.type_id = 1) OR (W.util_id <> 292399 AND W.type_id = 2)) AND (M.post_util_id = 292399 OR M.dest_util_id = 292399) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=292399 AND note_visu IN (1,3,4)
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 = 289029 AND W.type_id = 1) OR (W.util_id <> 289029 AND W.type_id = 2)) AND (M.post_util_id = 289029 OR M.dest_util_id = 289029) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=289029 AND note_visu IN (1,3,4)
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 = 128251 AND W.type_id = 1) OR (W.util_id <> 128251 AND W.type_id = 2)) AND (M.post_util_id = 128251 OR M.dest_util_id = 128251) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=128251 AND note_visu IN (1,3,4)
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 = 294294 AND W.type_id = 1) OR (W.util_id <> 294294 AND W.type_id = 2)) AND (M.post_util_id = 294294 OR M.dest_util_id = 294294) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=294294 AND note_visu IN (1,3,4)
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 = 295607 AND W.type_id = 1) OR (W.util_id <> 295607 AND W.type_id = 2)) AND (M.post_util_id = 295607 OR M.dest_util_id = 295607) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=295607 AND note_visu IN (1,3,4)
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 = 254147 AND W.type_id = 1) OR (W.util_id <> 254147 AND W.type_id = 2)) AND (M.post_util_id = 254147 OR M.dest_util_id = 254147) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=254147 AND note_visu IN (1,3,4)
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 = 28751 AND W.type_id = 1) OR (W.util_id <> 28751 AND W.type_id = 2)) AND (M.post_util_id = 28751 OR M.dest_util_id = 28751) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=28751 AND note_visu IN (1,3,4)
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 = 302525 AND W.type_id = 1) OR (W.util_id <> 302525 AND W.type_id = 2)) AND (M.post_util_id = 302525 OR M.dest_util_id = 302525) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=302525 AND note_visu IN (1,3,4)
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 = 303808 AND W.type_id = 1) OR (W.util_id <> 303808 AND W.type_id = 2)) AND (M.post_util_id = 303808 OR M.dest_util_id = 303808) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=303808 AND note_visu IN (1,3,4)
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 = 304388 AND W.type_id = 1) OR (W.util_id <> 304388 AND W.type_id = 2)) AND (M.post_util_id = 304388 OR M.dest_util_id = 304388) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=304388 AND note_visu IN (1,3,4)
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 = 200588 AND W.type_id = 1) OR (W.util_id <> 200588 AND W.type_id = 2)) AND (M.post_util_id = 200588 OR M.dest_util_id = 200588) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=200588 AND note_visu IN (1,3,4)
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 = 306262 AND W.type_id = 1) OR (W.util_id <> 306262 AND W.type_id = 2)) AND (M.post_util_id = 306262 OR M.dest_util_id = 306262) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=306262 AND note_visu IN (1,3,4)
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 = 258058 AND W.type_id = 1) OR (W.util_id <> 258058 AND W.type_id = 2)) AND (M.post_util_id = 258058 OR M.dest_util_id = 258058) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=258058 AND note_visu IN (1,3,4)
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 = 310139 AND W.type_id = 1) OR (W.util_id <> 310139 AND W.type_id = 2)) AND (M.post_util_id = 310139 OR M.dest_util_id = 310139) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=310139 AND note_visu IN (1,3,4)
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 = 310388 AND W.type_id = 1) OR (W.util_id <> 310388 AND W.type_id = 2)) AND (M.post_util_id = 310388 OR M.dest_util_id = 310388) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=310388 AND note_visu IN (1,3,4)
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 = 262874 AND W.type_id = 1) OR (W.util_id <> 262874 AND W.type_id = 2)) AND (M.post_util_id = 262874 OR M.dest_util_id = 262874) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=262874 AND note_visu IN (1,3,4)
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 = 308730 AND W.type_id = 1) OR (W.util_id <> 308730 AND W.type_id = 2)) AND (M.post_util_id = 308730 OR M.dest_util_id = 308730) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=308730 AND note_visu IN (1,3,4)
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 = 12612 AND W.type_id = 1) OR (W.util_id <> 12612 AND W.type_id = 2)) AND (M.post_util_id = 12612 OR M.dest_util_id = 12612) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=12612 AND note_visu IN (1,3,4)
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 = 230310 AND W.type_id = 1) OR (W.util_id <> 230310 AND W.type_id = 2)) AND (M.post_util_id = 230310 OR M.dest_util_id = 230310) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=230310 AND note_visu IN (1,3,4)
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 = 317950 AND W.type_id = 1) OR (W.util_id <> 317950 AND W.type_id = 2)) AND (M.post_util_id = 317950 OR M.dest_util_id = 317950) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=317950 AND note_visu IN (1,3,4)
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 = 250960 AND W.type_id = 1) OR (W.util_id <> 250960 AND W.type_id = 2)) AND (M.post_util_id = 250960 OR M.dest_util_id = 250960) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=250960 AND note_visu IN (1,3,4)
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 = 319954 AND W.type_id = 1) OR (W.util_id <> 319954 AND W.type_id = 2)) AND (M.post_util_id = 319954 OR M.dest_util_id = 319954) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=319954 AND note_visu IN (1,3,4)
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 = 323359 AND W.type_id = 1) OR (W.util_id <> 323359 AND W.type_id = 2)) AND (M.post_util_id = 323359 OR M.dest_util_id = 323359) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=323359 AND note_visu IN (1,3,4)
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 = 324296 AND W.type_id = 1) OR (W.util_id <> 324296 AND W.type_id = 2)) AND (M.post_util_id = 324296 OR M.dest_util_id = 324296) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=324296 AND note_visu IN (1,3,4)
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 = 323936 AND W.type_id = 1) OR (W.util_id <> 323936 AND W.type_id = 2)) AND (M.post_util_id = 323936 OR M.dest_util_id = 323936) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=323936 AND note_visu IN (1,3,4)
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 = 326223 AND W.type_id = 1) OR (W.util_id <> 326223 AND W.type_id = 2)) AND (M.post_util_id = 326223 OR M.dest_util_id = 326223) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=326223 AND note_visu IN (1,3,4)
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 = 323850 AND W.type_id = 1) OR (W.util_id <> 323850 AND W.type_id = 2)) AND (M.post_util_id = 323850 OR M.dest_util_id = 323850) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=323850 AND note_visu IN (1,3,4)
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 = 328498 AND W.type_id = 1) OR (W.util_id <> 328498 AND W.type_id = 2)) AND (M.post_util_id = 328498 OR M.dest_util_id = 328498) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=328498 AND note_visu IN (1,3,4)
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 = 120654 AND W.type_id = 1) OR (W.util_id <> 120654 AND W.type_id = 2)) AND (M.post_util_id = 120654 OR M.dest_util_id = 120654) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=120654 AND note_visu IN (1,3,4)
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 = 329548 AND W.type_id = 1) OR (W.util_id <> 329548 AND W.type_id = 2)) AND (M.post_util_id = 329548 OR M.dest_util_id = 329548) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=329548 AND note_visu IN (1,3,4)
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 = 46170 AND W.type_id = 1) OR (W.util_id <> 46170 AND W.type_id = 2)) AND (M.post_util_id = 46170 OR M.dest_util_id = 46170) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=46170 AND note_visu IN (1,3,4)
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 = 161508 AND W.type_id = 1) OR (W.util_id <> 161508 AND W.type_id = 2)) AND (M.post_util_id = 161508 OR M.dest_util_id = 161508) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=161508 AND note_visu IN (1,3,4)
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 = 339969 AND W.type_id = 1) OR (W.util_id <> 339969 AND W.type_id = 2)) AND (M.post_util_id = 339969 OR M.dest_util_id = 339969) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=339969 AND note_visu IN (1,3,4)
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 = 309464 AND W.type_id = 1) OR (W.util_id <> 309464 AND W.type_id = 2)) AND (M.post_util_id = 309464 OR M.dest_util_id = 309464) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=309464 AND note_visu IN (1,3,4)
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 = 341749 AND W.type_id = 1) OR (W.util_id <> 341749 AND W.type_id = 2)) AND (M.post_util_id = 341749 OR M.dest_util_id = 341749) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=341749 AND note_visu IN (1,3,4)
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 = 344700 AND W.type_id = 1) OR (W.util_id <> 344700 AND W.type_id = 2)) AND (M.post_util_id = 344700 OR M.dest_util_id = 344700) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=344700 AND note_visu IN (1,3,4)
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 = 349587 AND W.type_id = 1) OR (W.util_id <> 349587 AND W.type_id = 2)) AND (M.post_util_id = 349587 OR M.dest_util_id = 349587) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=349587 AND note_visu IN (1,3,4)
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 = 349935 AND W.type_id = 1) OR (W.util_id <> 349935 AND W.type_id = 2)) AND (M.post_util_id = 349935 OR M.dest_util_id = 349935) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=349935 AND note_visu IN (1,3,4)
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 = 350316 AND W.type_id = 1) OR (W.util_id <> 350316 AND W.type_id = 2)) AND (M.post_util_id = 350316 OR M.dest_util_id = 350316) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=350316 AND note_visu IN (1,3,4)
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 = 354413 AND W.type_id = 1) OR (W.util_id <> 354413 AND W.type_id = 2)) AND (M.post_util_id = 354413 OR M.dest_util_id = 354413) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=354413 AND note_visu IN (1,3,4)
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 = 356279 AND W.type_id = 1) OR (W.util_id <> 356279 AND W.type_id = 2)) AND (M.post_util_id = 356279 OR M.dest_util_id = 356279) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=356279 AND note_visu IN (1,3,4)
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 = 358515 AND W.type_id = 1) OR (W.util_id <> 358515 AND W.type_id = 2)) AND (M.post_util_id = 358515 OR M.dest_util_id = 358515) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=358515 AND note_visu IN (1,3,4)
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 = 361252 AND W.type_id = 1) OR (W.util_id <> 361252 AND W.type_id = 2)) AND (M.post_util_id = 361252 OR M.dest_util_id = 361252) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=361252 AND note_visu IN (1,3,4)
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 = 363877 AND W.type_id = 1) OR (W.util_id <> 363877 AND W.type_id = 2)) AND (M.post_util_id = 363877 OR M.dest_util_id = 363877) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=363877 AND note_visu IN (1,3,4)
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 = 364781 AND W.type_id = 1) OR (W.util_id <> 364781 AND W.type_id = 2)) AND (M.post_util_id = 364781 OR M.dest_util_id = 364781) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=364781 AND note_visu IN (1,3,4)
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 = 365299 AND W.type_id = 1) OR (W.util_id <> 365299 AND W.type_id = 2)) AND (M.post_util_id = 365299 OR M.dest_util_id = 365299) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=365299 AND note_visu IN (1,3,4)
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 = 367227 AND W.type_id = 1) OR (W.util_id <> 367227 AND W.type_id = 2)) AND (M.post_util_id = 367227 OR M.dest_util_id = 367227) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=367227 AND note_visu IN (1,3,4)
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 = 111977 AND W.type_id = 1) OR (W.util_id <> 111977 AND W.type_id = 2)) AND (M.post_util_id = 111977 OR M.dest_util_id = 111977) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=111977 AND note_visu IN (1,3,4)
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 = 369634 AND W.type_id = 1) OR (W.util_id <> 369634 AND W.type_id = 2)) AND (M.post_util_id = 369634 OR M.dest_util_id = 369634) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=369634 AND note_visu IN (1,3,4)
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 = 100949 AND W.type_id = 1) OR (W.util_id <> 100949 AND W.type_id = 2)) AND (M.post_util_id = 100949 OR M.dest_util_id = 100949) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=100949 AND note_visu IN (1,3,4)
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 = 370877 AND W.type_id = 1) OR (W.util_id <> 370877 AND W.type_id = 2)) AND (M.post_util_id = 370877 OR M.dest_util_id = 370877) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=370877 AND note_visu IN (1,3,4)
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 = 373393 AND W.type_id = 1) OR (W.util_id <> 373393 AND W.type_id = 2)) AND (M.post_util_id = 373393 OR M.dest_util_id = 373393) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=373393 AND note_visu IN (1,3,4)
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 = 376559 AND W.type_id = 1) OR (W.util_id <> 376559 AND W.type_id = 2)) AND (M.post_util_id = 376559 OR M.dest_util_id = 376559) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=376559 AND note_visu IN (1,3,4)
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 = 376867 AND W.type_id = 1) OR (W.util_id <> 376867 AND W.type_id = 2)) AND (M.post_util_id = 376867 OR M.dest_util_id = 376867) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=376867 AND note_visu IN (1,3,4)
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 = 378382 AND W.type_id = 1) OR (W.util_id <> 378382 AND W.type_id = 2)) AND (M.post_util_id = 378382 OR M.dest_util_id = 378382) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=378382 AND note_visu IN (1,3,4)
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 = 380584 AND W.type_id = 1) OR (W.util_id <> 380584 AND W.type_id = 2)) AND (M.post_util_id = 380584 OR M.dest_util_id = 380584) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=380584 AND note_visu IN (1,3,4)
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 = 380700 AND W.type_id = 1) OR (W.util_id <> 380700 AND W.type_id = 2)) AND (M.post_util_id = 380700 OR M.dest_util_id = 380700) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=380700 AND note_visu IN (1,3,4)
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 = 322816 AND W.type_id = 1) OR (W.util_id <> 322816 AND W.type_id = 2)) AND (M.post_util_id = 322816 OR M.dest_util_id = 322816) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=322816 AND note_visu IN (1,3,4)
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 = 383874 AND W.type_id = 1) OR (W.util_id <> 383874 AND W.type_id = 2)) AND (M.post_util_id = 383874 OR M.dest_util_id = 383874) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=383874 AND note_visu IN (1,3,4)
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 = 387475 AND W.type_id = 1) OR (W.util_id <> 387475 AND W.type_id = 2)) AND (M.post_util_id = 387475 OR M.dest_util_id = 387475) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=387475 AND note_visu IN (1,3,4)
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 = 389038 AND W.type_id = 1) OR (W.util_id <> 389038 AND W.type_id = 2)) AND (M.post_util_id = 389038 OR M.dest_util_id = 389038) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=389038 AND note_visu IN (1,3,4)
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 = 389107 AND W.type_id = 1) OR (W.util_id <> 389107 AND W.type_id = 2)) AND (M.post_util_id = 389107 OR M.dest_util_id = 389107) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=389107 AND note_visu IN (1,3,4)
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 = 390003 AND W.type_id = 1) OR (W.util_id <> 390003 AND W.type_id = 2)) AND (M.post_util_id = 390003 OR M.dest_util_id = 390003) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=390003 AND note_visu IN (1,3,4)
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 = 390990 AND W.type_id = 1) OR (W.util_id <> 390990 AND W.type_id = 2)) AND (M.post_util_id = 390990 OR M.dest_util_id = 390990) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=390990 AND note_visu IN (1,3,4)
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 = 254358 AND W.type_id = 1) OR (W.util_id <> 254358 AND W.type_id = 2)) AND (M.post_util_id = 254358 OR M.dest_util_id = 254358) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=254358 AND note_visu IN (1,3,4)
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 = 336281 AND W.type_id = 1) OR (W.util_id <> 336281 AND W.type_id = 2)) AND (M.post_util_id = 336281 OR M.dest_util_id = 336281) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=336281 AND note_visu IN (1,3,4)
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 = 396263 AND W.type_id = 1) OR (W.util_id <> 396263 AND W.type_id = 2)) AND (M.post_util_id = 396263 OR M.dest_util_id = 396263) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=396263 AND note_visu IN (1,3,4)
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 = 399184 AND W.type_id = 1) OR (W.util_id <> 399184 AND W.type_id = 2)) AND (M.post_util_id = 399184 OR M.dest_util_id = 399184) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=399184 AND note_visu IN (1,3,4)
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 = 77383 AND W.type_id = 1) OR (W.util_id <> 77383 AND W.type_id = 2)) AND (M.post_util_id = 77383 OR M.dest_util_id = 77383) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=77383 AND note_visu IN (1,3,4)
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 = 402376 AND W.type_id = 1) OR (W.util_id <> 402376 AND W.type_id = 2)) AND (M.post_util_id = 402376 OR M.dest_util_id = 402376) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=402376 AND note_visu IN (1,3,4)
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 = 91194 AND W.type_id = 1) OR (W.util_id <> 91194 AND W.type_id = 2)) AND (M.post_util_id = 91194 OR M.dest_util_id = 91194) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=91194 AND note_visu IN (1,3,4)
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 = 403681 AND W.type_id = 1) OR (W.util_id <> 403681 AND W.type_id = 2)) AND (M.post_util_id = 403681 OR M.dest_util_id = 403681) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=403681 AND note_visu IN (1,3,4)
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 = 27384 AND W.type_id = 1) OR (W.util_id <> 27384 AND W.type_id = 2)) AND (M.post_util_id = 27384 OR M.dest_util_id = 27384) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=27384 AND note_visu IN (1,3,4)
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 = 321736 AND W.type_id = 1) OR (W.util_id <> 321736 AND W.type_id = 2)) AND (M.post_util_id = 321736 OR M.dest_util_id = 321736) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=321736 AND note_visu IN (1,3,4)
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 = 407886 AND W.type_id = 1) OR (W.util_id <> 407886 AND W.type_id = 2)) AND (M.post_util_id = 407886 OR M.dest_util_id = 407886) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=407886 AND note_visu IN (1,3,4)
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 = 53678 AND W.type_id = 1) OR (W.util_id <> 53678 AND W.type_id = 2)) AND (M.post_util_id = 53678 OR M.dest_util_id = 53678) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=53678 AND note_visu IN (1,3,4)
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 = 180325 AND W.type_id = 1) OR (W.util_id <> 180325 AND W.type_id = 2)) AND (M.post_util_id = 180325 OR M.dest_util_id = 180325) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=180325 AND note_visu IN (1,3,4)
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 = 411733 AND W.type_id = 1) OR (W.util_id <> 411733 AND W.type_id = 2)) AND (M.post_util_id = 411733 OR M.dest_util_id = 411733) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=411733 AND note_visu IN (1,3,4)
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 = 311698 AND W.type_id = 1) OR (W.util_id <> 311698 AND W.type_id = 2)) AND (M.post_util_id = 311698 OR M.dest_util_id = 311698) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=311698 AND note_visu IN (1,3,4)
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 = 415606 AND W.type_id = 1) OR (W.util_id <> 415606 AND W.type_id = 2)) AND (M.post_util_id = 415606 OR M.dest_util_id = 415606) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=415606 AND note_visu IN (1,3,4)
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 = 421432 AND W.type_id = 1) OR (W.util_id <> 421432 AND W.type_id = 2)) AND (M.post_util_id = 421432 OR M.dest_util_id = 421432) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=421432 AND note_visu IN (1,3,4)
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 = 332348 AND W.type_id = 1) OR (W.util_id <> 332348 AND W.type_id = 2)) AND (M.post_util_id = 332348 OR M.dest_util_id = 332348) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=332348 AND note_visu IN (1,3,4)
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 = 41253 AND W.type_id = 1) OR (W.util_id <> 41253 AND W.type_id = 2)) AND (M.post_util_id = 41253 OR M.dest_util_id = 41253) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=41253 AND note_visu IN (1,3,4)
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 = 427383 AND W.type_id = 1) OR (W.util_id <> 427383 AND W.type_id = 2)) AND (M.post_util_id = 427383 OR M.dest_util_id = 427383) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=427383 AND note_visu IN (1,3,4)
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 = 432286 AND W.type_id = 1) OR (W.util_id <> 432286 AND W.type_id = 2)) AND (M.post_util_id = 432286 OR M.dest_util_id = 432286) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=432286 AND note_visu IN (1,3,4)
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 = 436329 AND W.type_id = 1) OR (W.util_id <> 436329 AND W.type_id = 2)) AND (M.post_util_id = 436329 OR M.dest_util_id = 436329) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=436329 AND note_visu IN (1,3,4)
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 = 396860 AND W.type_id = 1) OR (W.util_id <> 396860 AND W.type_id = 2)) AND (M.post_util_id = 396860 OR M.dest_util_id = 396860) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=396860 AND note_visu IN (1,3,4)
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 = 111961 AND W.type_id = 1) OR (W.util_id <> 111961 AND W.type_id = 2)) AND (M.post_util_id = 111961 OR M.dest_util_id = 111961) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=111961 AND note_visu IN (1,3,4)
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 = 441381 AND W.type_id = 1) OR (W.util_id <> 441381 AND W.type_id = 2)) AND (M.post_util_id = 441381 OR M.dest_util_id = 441381) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=441381 AND note_visu IN (1,3,4)
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 = 446145 AND W.type_id = 1) OR (W.util_id <> 446145 AND W.type_id = 2)) AND (M.post_util_id = 446145 OR M.dest_util_id = 446145) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=446145 AND note_visu IN (1,3,4)
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 = 446400 AND W.type_id = 1) OR (W.util_id <> 446400 AND W.type_id = 2)) AND (M.post_util_id = 446400 OR M.dest_util_id = 446400) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=446400 AND note_visu IN (1,3,4)
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 = 447007 AND W.type_id = 1) OR (W.util_id <> 447007 AND W.type_id = 2)) AND (M.post_util_id = 447007 OR M.dest_util_id = 447007) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=447007 AND note_visu IN (1,3,4)
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 = 447847 AND W.type_id = 1) OR (W.util_id <> 447847 AND W.type_id = 2)) AND (M.post_util_id = 447847 OR M.dest_util_id = 447847) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=447847 AND note_visu IN (1,3,4)
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 = 449430 AND W.type_id = 1) OR (W.util_id <> 449430 AND W.type_id = 2)) AND (M.post_util_id = 449430 OR M.dest_util_id = 449430) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=449430 AND note_visu IN (1,3,4)
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 = 455016 AND W.type_id = 1) OR (W.util_id <> 455016 AND W.type_id = 2)) AND (M.post_util_id = 455016 OR M.dest_util_id = 455016) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=455016 AND note_visu IN (1,3,4)
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 = 455857 AND W.type_id = 1) OR (W.util_id <> 455857 AND W.type_id = 2)) AND (M.post_util_id = 455857 OR M.dest_util_id = 455857) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=455857 AND note_visu IN (1,3,4)
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 = 412551 AND W.type_id = 1) OR (W.util_id <> 412551 AND W.type_id = 2)) AND (M.post_util_id = 412551 OR M.dest_util_id = 412551) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=412551 AND note_visu IN (1,3,4)
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 = 456375 AND W.type_id = 1) OR (W.util_id <> 456375 AND W.type_id = 2)) AND (M.post_util_id = 456375 OR M.dest_util_id = 456375) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=456375 AND note_visu IN (1,3,4)
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 = 301503 AND W.type_id = 1) OR (W.util_id <> 301503 AND W.type_id = 2)) AND (M.post_util_id = 301503 OR M.dest_util_id = 301503) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=301503 AND note_visu IN (1,3,4)
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 = 135787 AND W.type_id = 1) OR (W.util_id <> 135787 AND W.type_id = 2)) AND (M.post_util_id = 135787 OR M.dest_util_id = 135787) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=135787 AND note_visu IN (1,3,4)
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 = 74760 AND W.type_id = 1) OR (W.util_id <> 74760 AND W.type_id = 2)) AND (M.post_util_id = 74760 OR M.dest_util_id = 74760) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=74760 AND note_visu IN (1,3,4)
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 = 465921 AND W.type_id = 1) OR (W.util_id <> 465921 AND W.type_id = 2)) AND (M.post_util_id = 465921 OR M.dest_util_id = 465921) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=465921 AND note_visu IN (1,3,4)
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 = 212528 AND W.type_id = 1) OR (W.util_id <> 212528 AND W.type_id = 2)) AND (M.post_util_id = 212528 OR M.dest_util_id = 212528) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=212528 AND note_visu IN (1,3,4)
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 = 462406 AND W.type_id = 1) OR (W.util_id <> 462406 AND W.type_id = 2)) AND (M.post_util_id = 462406 OR M.dest_util_id = 462406) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=462406 AND note_visu IN (1,3,4)
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 = 472587 AND W.type_id = 1) OR (W.util_id <> 472587 AND W.type_id = 2)) AND (M.post_util_id = 472587 OR M.dest_util_id = 472587) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=472587 AND note_visu IN (1,3,4)
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 = 473313 AND W.type_id = 1) OR (W.util_id <> 473313 AND W.type_id = 2)) AND (M.post_util_id = 473313 OR M.dest_util_id = 473313) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=473313 AND note_visu IN (1,3,4)
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 = 475508 AND W.type_id = 1) OR (W.util_id <> 475508 AND W.type_id = 2)) AND (M.post_util_id = 475508 OR M.dest_util_id = 475508) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=475508 AND note_visu IN (1,3,4)
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 = 475843 AND W.type_id = 1) OR (W.util_id <> 475843 AND W.type_id = 2)) AND (M.post_util_id = 475843 OR M.dest_util_id = 475843) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=475843 AND note_visu IN (1,3,4)
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 = 476041 AND W.type_id = 1) OR (W.util_id <> 476041 AND W.type_id = 2)) AND (M.post_util_id = 476041 OR M.dest_util_id = 476041) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=476041 AND note_visu IN (1,3,4)
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 = 478394 AND W.type_id = 1) OR (W.util_id <> 478394 AND W.type_id = 2)) AND (M.post_util_id = 478394 OR M.dest_util_id = 478394) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=478394 AND note_visu IN (1,3,4)
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 = 479293 AND W.type_id = 1) OR (W.util_id <> 479293 AND W.type_id = 2)) AND (M.post_util_id = 479293 OR M.dest_util_id = 479293) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=479293 AND note_visu IN (1,3,4)
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 = 480697 AND W.type_id = 1) OR (W.util_id <> 480697 AND W.type_id = 2)) AND (M.post_util_id = 480697 OR M.dest_util_id = 480697) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=480697 AND note_visu IN (1,3,4)
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 = 156721 AND W.type_id = 1) OR (W.util_id <> 156721 AND W.type_id = 2)) AND (M.post_util_id = 156721 OR M.dest_util_id = 156721) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=156721 AND note_visu IN (1,3,4)
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 = 482655 AND W.type_id = 1) OR (W.util_id <> 482655 AND W.type_id = 2)) AND (M.post_util_id = 482655 OR M.dest_util_id = 482655) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=482655 AND note_visu IN (1,3,4)
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 = 488921 AND W.type_id = 1) OR (W.util_id <> 488921 AND W.type_id = 2)) AND (M.post_util_id = 488921 OR M.dest_util_id = 488921) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=488921 AND note_visu IN (1,3,4)
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 = 87618 AND W.type_id = 1) OR (W.util_id <> 87618 AND W.type_id = 2)) AND (M.post_util_id = 87618 OR M.dest_util_id = 87618) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=87618 AND note_visu IN (1,3,4)
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 = 478655 AND W.type_id = 1) OR (W.util_id <> 478655 AND W.type_id = 2)) AND (M.post_util_id = 478655 OR M.dest_util_id = 478655) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=478655 AND note_visu IN (1,3,4)
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 = 496473 AND W.type_id = 1) OR (W.util_id <> 496473 AND W.type_id = 2)) AND (M.post_util_id = 496473 OR M.dest_util_id = 496473) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=496473 AND note_visu IN (1,3,4)
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 = 467104 AND W.type_id = 1) OR (W.util_id <> 467104 AND W.type_id = 2)) AND (M.post_util_id = 467104 OR M.dest_util_id = 467104) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=467104 AND note_visu IN (1,3,4)
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 = 497057 AND W.type_id = 1) OR (W.util_id <> 497057 AND W.type_id = 2)) AND (M.post_util_id = 497057 OR M.dest_util_id = 497057) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=497057 AND note_visu IN (1,3,4)
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 = 225807 AND W.type_id = 1) OR (W.util_id <> 225807 AND W.type_id = 2)) AND (M.post_util_id = 225807 OR M.dest_util_id = 225807) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=225807 AND note_visu IN (1,3,4)
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 = 502907 AND W.type_id = 1) OR (W.util_id <> 502907 AND W.type_id = 2)) AND (M.post_util_id = 502907 OR M.dest_util_id = 502907) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=502907 AND note_visu IN (1,3,4)
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 = 503798 AND W.type_id = 1) OR (W.util_id <> 503798 AND W.type_id = 2)) AND (M.post_util_id = 503798 OR M.dest_util_id = 503798) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=503798 AND note_visu IN (1,3,4)
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 = 400093 AND W.type_id = 1) OR (W.util_id <> 400093 AND W.type_id = 2)) AND (M.post_util_id = 400093 OR M.dest_util_id = 400093) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=400093 AND note_visu IN (1,3,4)
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 = 387170 AND W.type_id = 1) OR (W.util_id <> 387170 AND W.type_id = 2)) AND (M.post_util_id = 387170 OR M.dest_util_id = 387170) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=387170 AND note_visu IN (1,3,4)
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 = 507500 AND W.type_id = 1) OR (W.util_id <> 507500 AND W.type_id = 2)) AND (M.post_util_id = 507500 OR M.dest_util_id = 507500) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=507500 AND note_visu IN (1,3,4)
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 = 507661 AND W.type_id = 1) OR (W.util_id <> 507661 AND W.type_id = 2)) AND (M.post_util_id = 507661 OR M.dest_util_id = 507661) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=507661 AND note_visu IN (1,3,4)
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 = 5981 AND W.type_id = 1) OR (W.util_id <> 5981 AND W.type_id = 2)) AND (M.post_util_id = 5981 OR M.dest_util_id = 5981) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=5981 AND note_visu IN (1,3,4)
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 = 511333 AND W.type_id = 1) OR (W.util_id <> 511333 AND W.type_id = 2)) AND (M.post_util_id = 511333 OR M.dest_util_id = 511333) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=511333 AND note_visu IN (1,3,4)
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 = 512719 AND W.type_id = 1) OR (W.util_id <> 512719 AND W.type_id = 2)) AND (M.post_util_id = 512719 OR M.dest_util_id = 512719) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=512719 AND note_visu IN (1,3,4)
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 = 513806 AND W.type_id = 1) OR (W.util_id <> 513806 AND W.type_id = 2)) AND (M.post_util_id = 513806 OR M.dest_util_id = 513806) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=513806 AND note_visu IN (1,3,4)
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 = 220309 AND W.type_id = 1) OR (W.util_id <> 220309 AND W.type_id = 2)) AND (M.post_util_id = 220309 OR M.dest_util_id = 220309) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=220309 AND note_visu IN (1,3,4)
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 = 520383 AND W.type_id = 1) OR (W.util_id <> 520383 AND W.type_id = 2)) AND (M.post_util_id = 520383 OR M.dest_util_id = 520383) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=520383 AND note_visu IN (1,3,4)
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 = 521878 AND W.type_id = 1) OR (W.util_id <> 521878 AND W.type_id = 2)) AND (M.post_util_id = 521878 OR M.dest_util_id = 521878) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=521878 AND note_visu IN (1,3,4)
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 = 521936 AND W.type_id = 1) OR (W.util_id <> 521936 AND W.type_id = 2)) AND (M.post_util_id = 521936 OR M.dest_util_id = 521936) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=521936 AND note_visu IN (1,3,4)
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 = 524235 AND W.type_id = 1) OR (W.util_id <> 524235 AND W.type_id = 2)) AND (M.post_util_id = 524235 OR M.dest_util_id = 524235) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=524235 AND note_visu IN (1,3,4)
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 = 524504 AND W.type_id = 1) OR (W.util_id <> 524504 AND W.type_id = 2)) AND (M.post_util_id = 524504 OR M.dest_util_id = 524504) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=524504 AND note_visu IN (1,3,4)
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 = 525805 AND W.type_id = 1) OR (W.util_id <> 525805 AND W.type_id = 2)) AND (M.post_util_id = 525805 OR M.dest_util_id = 525805) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=525805 AND note_visu IN (1,3,4)
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 = 526302 AND W.type_id = 1) OR (W.util_id <> 526302 AND W.type_id = 2)) AND (M.post_util_id = 526302 OR M.dest_util_id = 526302) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=526302 AND note_visu IN (1,3,4)
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 = 207753 AND W.type_id = 1) OR (W.util_id <> 207753 AND W.type_id = 2)) AND (M.post_util_id = 207753 OR M.dest_util_id = 207753) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=207753 AND note_visu IN (1,3,4)
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 = 392319 AND W.type_id = 1) OR (W.util_id <> 392319 AND W.type_id = 2)) AND (M.post_util_id = 392319 OR M.dest_util_id = 392319) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=392319 AND note_visu IN (1,3,4)
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 = 530755 AND W.type_id = 1) OR (W.util_id <> 530755 AND W.type_id = 2)) AND (M.post_util_id = 530755 OR M.dest_util_id = 530755) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=530755 AND note_visu IN (1,3,4)
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 = 533869 AND W.type_id = 1) OR (W.util_id <> 533869 AND W.type_id = 2)) AND (M.post_util_id = 533869 OR M.dest_util_id = 533869) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=533869 AND note_visu IN (1,3,4)
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 = 224902 AND W.type_id = 1) OR (W.util_id <> 224902 AND W.type_id = 2)) AND (M.post_util_id = 224902 OR M.dest_util_id = 224902) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=224902 AND note_visu IN (1,3,4)
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 = 537709 AND W.type_id = 1) OR (W.util_id <> 537709 AND W.type_id = 2)) AND (M.post_util_id = 537709 OR M.dest_util_id = 537709) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=537709 AND note_visu IN (1,3,4)
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 = 540196 AND W.type_id = 1) OR (W.util_id <> 540196 AND W.type_id = 2)) AND (M.post_util_id = 540196 OR M.dest_util_id = 540196) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=540196 AND note_visu IN (1,3,4)
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 = 415110 AND W.type_id = 1) OR (W.util_id <> 415110 AND W.type_id = 2)) AND (M.post_util_id = 415110 OR M.dest_util_id = 415110) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=415110 AND note_visu IN (1,3,4)
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 = 542333 AND W.type_id = 1) OR (W.util_id <> 542333 AND W.type_id = 2)) AND (M.post_util_id = 542333 OR M.dest_util_id = 542333) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=542333 AND note_visu IN (1,3,4)
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 = 536440 AND W.type_id = 1) OR (W.util_id <> 536440 AND W.type_id = 2)) AND (M.post_util_id = 536440 OR M.dest_util_id = 536440) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=536440 AND note_visu IN (1,3,4)
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 = 293705 AND W.type_id = 1) OR (W.util_id <> 293705 AND W.type_id = 2)) AND (M.post_util_id = 293705 OR M.dest_util_id = 293705) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=293705 AND note_visu IN (1,3,4)
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 = 545564 AND W.type_id = 1) OR (W.util_id <> 545564 AND W.type_id = 2)) AND (M.post_util_id = 545564 OR M.dest_util_id = 545564) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=545564 AND note_visu IN (1,3,4)
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 = 545634 AND W.type_id = 1) OR (W.util_id <> 545634 AND W.type_id = 2)) AND (M.post_util_id = 545634 OR M.dest_util_id = 545634) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=545634 AND note_visu IN (1,3,4)
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 = 546562 AND W.type_id = 1) OR (W.util_id <> 546562 AND W.type_id = 2)) AND (M.post_util_id = 546562 OR M.dest_util_id = 546562) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=546562 AND note_visu IN (1,3,4)
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 = 548462 AND W.type_id = 1) OR (W.util_id <> 548462 AND W.type_id = 2)) AND (M.post_util_id = 548462 OR M.dest_util_id = 548462) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=548462 AND note_visu IN (1,3,4)
0.0001
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='75001'
0.0007
SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.797047487586 AND ville_latitude_deg<48.922952512414 AND ville_longitude_deg>2.2487630978401 AND ville_longitude_deg<2.4401369021599 HAVING distance <= 7 ORDER BY distance ASC
0.0063
SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.410339197041 AND ville_latitude_deg<49.309660802959 AND ville_longitude_deg>1.6609652486165 AND ville_longitude_deg<3.0279347513835 HAVING distance <= 50 ORDER BY distance ASC
0.0001
SELECT ssr.ssrubr_id, ssr.ssrubr_slug, ssr.ssrubr_mail, ssr.ssrubr_mail_bis, ssr.ssrubr_keywords, ssr.ssrubr_bt2, ssr.ssrubr_photo, c.cate_title_slug, f.fami_url FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id IN (1132,581,963,1203,582,975,1165,1206)
0.0003
SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (59877,209862,341749,224477,407886,306262,42590,98206,242757,80637,436329,208305,44104,59798,224902,103964,92452,171695,234765,32408,2546,227181,216278,277299,478394,154416,237886,282588,75466,63876,258058,548462,41253,120654,132873,456375,134234,116502,280871,265473,91194,447007,432286,132805,121710,81404,62433,81459,19403,525805,441381,212528,482655)
0.0002
SELECT util_id, util_photo FROM util_info WHERE util_id IN (59877,209862,341749,224477,407886,306262,42590,98206,242757,80637,436329,208305,44104,59798,224902,103964,92452,171695,234765,32408,2546,227181,216278,277299,478394,154416,237886,282588,75466,63876,258058,548462,41253,120654,132873,456375,134234,116502,280871,265473,91194,447007,432286,132805,121710,81404,62433,81459,19403,525805,441381,212528,482655)
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='' OR ssrubr_slug like '%%' OR MATCH (ssrubr_slug) AGAINST ('(+)')) AND sk.ssrubr_id='' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
0.0001
SELECT * FROM actu WHERE ssrubr_id='' AND actu_niveau=0 ORDER BY actu_ordre DESC
0.0001
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
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
0.0002
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (231) ORDER BY ssrubr_order ASC
0.0009
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
0.0282
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'
0.0168
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

Menu

Aide & support

Service réparateur à 75001 Paris

Service › Réparateur

Réparateur électroménager

Réparation téléphone

Réparateur télévision

Mécanicien automobile

Couture & retouche

Réparation tondeuse

Réparation de vélo

Dépannage informatique

Réparation appareil photo

Réparation moto/scooter

Réparation montre

Réparation de bijoux

Réparation instruments

Réparateur divers

Réparation sac/valise

Tout dépannage

676 requetes sql en 0.1657