Voir les annonces autour de moi Géolocaliser
Poster une annonce
Voir les annonces autour de moi Géolocaliser
Proposer mon aide
Louer du matériel ou proposer un service
Faire appel à mes voisins
Besoin d'un objet ou d'un service ?
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wall.php
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='babysitting'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=39
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('78' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT ville_nom FROM villes WHERE ville_cp='78800' AND ville_nom like '%houilles%' ORDER BY ville_population_2012 DESC LIMIT 0,1
SHOW TABLES LIKE 'pays'
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
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
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='78800'
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<>''
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='39' AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp like '78800%'
SELECT * FROM texte WHERE cate_id=39
SELECT COUNT(*) AS cnt FROM (SELECT wish.wish_id FROM wish LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='39' AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('78800','78800','78420','92000','95870','78360','92700','92500','78500','92250','92400','92270','78600','95100','78400','95530','78600','92150','92800','92200','92600','78110','92300','95110','78560','78380','78290','95240','95370','78230','92110','92230','95130','95218','95210','78430','78170','92210','92380','78100','93800','95120','78750','92420','92430','95130','95220','92390','93450','93400','92100','95880','78160','92410','78700','95230','78112','95600','78150','78300','92310','95250','78260','78620','78870','93430','95480','78150','95320','93210','93200','95580','95580','92170','92130','95390','95170','78570','78590','95360','75018','75016','75014','75001','75017','75003','75020','75015','75002','75000','75019','75013','75004','75009','75010','75006','75116','75011','75012','75008','75007','75005','78240','92360','92190','95680','78955','92370','95150','95550','78140','78220','95410','95610','92240','93380','93120','93300','95160','78780','78240','78000','92140','93240','92120','78570','92320','78590','93500','95000','94250','95740','92220','78670','78670','93310','95840','95350','78860','95560','95350','92350','78330','78630','93350','95310','92330','92260','95330','95000','94110','78210','93440','95200','95400','78450','78510','95280','94270','95570','95300','95540','95140','78540','93170','95430','95840','78350','92290','78350','78530','95440','94200','94205','93260','93230','78480','95400','78450','95570','94232','94238','94230','94231','94235','94239','94240','94237','94233','94234','94236','95490','95460','94800','95500','92340','93100','78810','95300','95560','95000','93700','93150','93000','94160','95570','95630','95430','91570','94300','78390','95560','91370','95520','78280','95180','78340','94220','95590','78117','95800','78630','93140','95500','93130','78121','92160','95650','94550') AND type_id=1 GROUP BY wish_id) t
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.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- 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='39' AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('78800','78800','78420','92000','95870','78360','92700','92500','78500','92250','92400','92270','78600','95100','78400','95530','78600','92150','92800','92200','92600','78110','92300','95110','78560','78380','78290','95240','95370','78230','92110','92230','95130','95218','95210','78430','78170','92210','92380','78100','93800','95120','78750','92420','92430','95130','95220','92390','93450','93400','92100','95880','78160','92410','78700','95230','78112','95600','78150','78300','92310','95250','78260','78620','78870','93430','95480','78150','95320','93210','93200','95580','95580','92170','92130','95390','95170','78570','78590','95360','75018','75016','75014','75001','75017','75003','75020','75015','75002','75000','75019','75013','75004','75009','75010','75006','75116','75011','75012','75008','75007','75005','78240','92360','92190','95680','78955','92370','95150','95550','78140','78220','95410','95610','92240','93380','93120','93300','95160','78780','78240','78000','92140','93240','92120','78570','92320','78590','93500','95000','94250','95740','92220','78670','78670','93310','95840','95350','78860','95560','95350','92350','78330','78630','93350','95310','92330','92260','95330','95000','94110','78210','93440','95200','95400','78450','78510','95280','94270','95570','95300','95540','95140','78540','93170','95430','95840','78350','92290','78350','78530','95440','94200','94205','93260','93230','78480','95400','78450','95570','94232','94238','94230','94231','94235','94239','94240','94237','94233','94234','94236','95490','95460','94800','95500','92340','93100','78810','95300','95560','95000','93700','93150','93000','94160','95570','95630','95430','91570','94300','78390','95560','91370','95520','78280','95180','78340','94220','95590','78117','95800','78630','93140','95500','93130','78121','92160','95650','94550') AND type_id=1 GROUP BY wish_id ORDER BY distance ASC, wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 660,60
SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (86297,75160,57389,358202,357867,207211,47846,492051,292466,37073,220352,201726,82997,196162,157277,130474,86547,83280,51483,312234,429304,218716,217565,215397,171708,119144,75329,19919,30781,78708,440420,384809,381935,297458,207773,196781,151842,153725,115057,8995,125768,121081,114606,91834,71895,70277,64383,64402,28735,15701,118045,93001,73786,418120,210018,201214)
SELECT ssr.ssrubr_id, ssr.ssrubr_slug, ssr.ssrubr_title, 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 (1008,1031,942,939,941,940)
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=86297 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 86297 AND W.type_id = 1) OR (W.util_id <> 86297 AND W.type_id = 2)) AND (M.post_util_id = 86297 OR M.dest_util_id = 86297) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=75160 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 75160 AND W.type_id = 1) OR (W.util_id <> 75160 AND W.type_id = 2)) AND (M.post_util_id = 75160 OR M.dest_util_id = 75160) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=57389 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 57389 AND W.type_id = 1) OR (W.util_id <> 57389 AND W.type_id = 2)) AND (M.post_util_id = 57389 OR M.dest_util_id = 57389) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=358202 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 358202 AND W.type_id = 1) OR (W.util_id <> 358202 AND W.type_id = 2)) AND (M.post_util_id = 358202 OR M.dest_util_id = 358202) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=357867 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 357867 AND W.type_id = 1) OR (W.util_id <> 357867 AND W.type_id = 2)) AND (M.post_util_id = 357867 OR M.dest_util_id = 357867) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=207211 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 207211 AND W.type_id = 1) OR (W.util_id <> 207211 AND W.type_id = 2)) AND (M.post_util_id = 207211 OR M.dest_util_id = 207211) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=47846 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 47846 AND W.type_id = 1) OR (W.util_id <> 47846 AND W.type_id = 2)) AND (M.post_util_id = 47846 OR M.dest_util_id = 47846) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=492051 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 492051 AND W.type_id = 1) OR (W.util_id <> 492051 AND W.type_id = 2)) AND (M.post_util_id = 492051 OR M.dest_util_id = 492051) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=292466 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 292466 AND W.type_id = 1) OR (W.util_id <> 292466 AND W.type_id = 2)) AND (M.post_util_id = 292466 OR M.dest_util_id = 292466) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=37073 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 37073 AND W.type_id = 1) OR (W.util_id <> 37073 AND W.type_id = 2)) AND (M.post_util_id = 37073 OR M.dest_util_id = 37073) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=220352 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 220352 AND W.type_id = 1) OR (W.util_id <> 220352 AND W.type_id = 2)) AND (M.post_util_id = 220352 OR M.dest_util_id = 220352) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=201726 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 201726 AND W.type_id = 1) OR (W.util_id <> 201726 AND W.type_id = 2)) AND (M.post_util_id = 201726 OR M.dest_util_id = 201726) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=82997 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 82997 AND W.type_id = 1) OR (W.util_id <> 82997 AND W.type_id = 2)) AND (M.post_util_id = 82997 OR M.dest_util_id = 82997) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=196162 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 196162 AND W.type_id = 1) OR (W.util_id <> 196162 AND W.type_id = 2)) AND (M.post_util_id = 196162 OR M.dest_util_id = 196162) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=157277 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 157277 AND W.type_id = 1) OR (W.util_id <> 157277 AND W.type_id = 2)) AND (M.post_util_id = 157277 OR M.dest_util_id = 157277) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=130474 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 130474 AND W.type_id = 1) OR (W.util_id <> 130474 AND W.type_id = 2)) AND (M.post_util_id = 130474 OR M.dest_util_id = 130474) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=86547 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 86547 AND W.type_id = 1) OR (W.util_id <> 86547 AND W.type_id = 2)) AND (M.post_util_id = 86547 OR M.dest_util_id = 86547) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=83280 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 83280 AND W.type_id = 1) OR (W.util_id <> 83280 AND W.type_id = 2)) AND (M.post_util_id = 83280 OR M.dest_util_id = 83280) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=51483 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 51483 AND W.type_id = 1) OR (W.util_id <> 51483 AND W.type_id = 2)) AND (M.post_util_id = 51483 OR M.dest_util_id = 51483) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=312234 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 312234 AND W.type_id = 1) OR (W.util_id <> 312234 AND W.type_id = 2)) AND (M.post_util_id = 312234 OR M.dest_util_id = 312234) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=429304 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 429304 AND W.type_id = 1) OR (W.util_id <> 429304 AND W.type_id = 2)) AND (M.post_util_id = 429304 OR M.dest_util_id = 429304) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=218716 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 218716 AND W.type_id = 1) OR (W.util_id <> 218716 AND W.type_id = 2)) AND (M.post_util_id = 218716 OR M.dest_util_id = 218716) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=217565 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 217565 AND W.type_id = 1) OR (W.util_id <> 217565 AND W.type_id = 2)) AND (M.post_util_id = 217565 OR M.dest_util_id = 217565) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=215397 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 215397 AND W.type_id = 1) OR (W.util_id <> 215397 AND W.type_id = 2)) AND (M.post_util_id = 215397 OR M.dest_util_id = 215397) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=171708 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 171708 AND W.type_id = 1) OR (W.util_id <> 171708 AND W.type_id = 2)) AND (M.post_util_id = 171708 OR M.dest_util_id = 171708) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=119144 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 119144 AND W.type_id = 1) OR (W.util_id <> 119144 AND W.type_id = 2)) AND (M.post_util_id = 119144 OR M.dest_util_id = 119144) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=75329 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 75329 AND W.type_id = 1) OR (W.util_id <> 75329 AND W.type_id = 2)) AND (M.post_util_id = 75329 OR M.dest_util_id = 75329) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=19919 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 19919 AND W.type_id = 1) OR (W.util_id <> 19919 AND W.type_id = 2)) AND (M.post_util_id = 19919 OR M.dest_util_id = 19919) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=30781 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 30781 AND W.type_id = 1) OR (W.util_id <> 30781 AND W.type_id = 2)) AND (M.post_util_id = 30781 OR M.dest_util_id = 30781) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=78708 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 78708 AND W.type_id = 1) OR (W.util_id <> 78708 AND W.type_id = 2)) AND (M.post_util_id = 78708 OR M.dest_util_id = 78708) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=440420 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 440420 AND W.type_id = 1) OR (W.util_id <> 440420 AND W.type_id = 2)) AND (M.post_util_id = 440420 OR M.dest_util_id = 440420) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=384809 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 384809 AND W.type_id = 1) OR (W.util_id <> 384809 AND W.type_id = 2)) AND (M.post_util_id = 384809 OR M.dest_util_id = 384809) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=381935 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 381935 AND W.type_id = 1) OR (W.util_id <> 381935 AND W.type_id = 2)) AND (M.post_util_id = 381935 OR M.dest_util_id = 381935) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=297458 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 297458 AND W.type_id = 1) OR (W.util_id <> 297458 AND W.type_id = 2)) AND (M.post_util_id = 297458 OR M.dest_util_id = 297458) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=207773 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 207773 AND W.type_id = 1) OR (W.util_id <> 207773 AND W.type_id = 2)) AND (M.post_util_id = 207773 OR M.dest_util_id = 207773) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=196781 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 196781 AND W.type_id = 1) OR (W.util_id <> 196781 AND W.type_id = 2)) AND (M.post_util_id = 196781 OR M.dest_util_id = 196781) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=151842 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 151842 AND W.type_id = 1) OR (W.util_id <> 151842 AND W.type_id = 2)) AND (M.post_util_id = 151842 OR M.dest_util_id = 151842) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=153725 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 153725 AND W.type_id = 1) OR (W.util_id <> 153725 AND W.type_id = 2)) AND (M.post_util_id = 153725 OR M.dest_util_id = 153725) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=115057 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 115057 AND W.type_id = 1) OR (W.util_id <> 115057 AND W.type_id = 2)) AND (M.post_util_id = 115057 OR M.dest_util_id = 115057) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=8995 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 8995 AND W.type_id = 1) OR (W.util_id <> 8995 AND W.type_id = 2)) AND (M.post_util_id = 8995 OR M.dest_util_id = 8995) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=125768 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 125768 AND W.type_id = 1) OR (W.util_id <> 125768 AND W.type_id = 2)) AND (M.post_util_id = 125768 OR M.dest_util_id = 125768) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=121081 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 121081 AND W.type_id = 1) OR (W.util_id <> 121081 AND W.type_id = 2)) AND (M.post_util_id = 121081 OR M.dest_util_id = 121081) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=114606 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 114606 AND W.type_id = 1) OR (W.util_id <> 114606 AND W.type_id = 2)) AND (M.post_util_id = 114606 OR M.dest_util_id = 114606) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=91834 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 91834 AND W.type_id = 1) OR (W.util_id <> 91834 AND W.type_id = 2)) AND (M.post_util_id = 91834 OR M.dest_util_id = 91834) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=71895 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 71895 AND W.type_id = 1) OR (W.util_id <> 71895 AND W.type_id = 2)) AND (M.post_util_id = 71895 OR M.dest_util_id = 71895) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=70277 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 70277 AND W.type_id = 1) OR (W.util_id <> 70277 AND W.type_id = 2)) AND (M.post_util_id = 70277 OR M.dest_util_id = 70277) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=64383 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 64383 AND W.type_id = 1) OR (W.util_id <> 64383 AND W.type_id = 2)) AND (M.post_util_id = 64383 OR M.dest_util_id = 64383) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=64402 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 64402 AND W.type_id = 1) OR (W.util_id <> 64402 AND W.type_id = 2)) AND (M.post_util_id = 64402 OR M.dest_util_id = 64402) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=28735 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 28735 AND W.type_id = 1) OR (W.util_id <> 28735 AND W.type_id = 2)) AND (M.post_util_id = 28735 OR M.dest_util_id = 28735) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=15701 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 15701 AND W.type_id = 1) OR (W.util_id <> 15701 AND W.type_id = 2)) AND (M.post_util_id = 15701 OR M.dest_util_id = 15701) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=118045 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 118045 AND W.type_id = 1) OR (W.util_id <> 118045 AND W.type_id = 2)) AND (M.post_util_id = 118045 OR M.dest_util_id = 118045) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=93001 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 93001 AND W.type_id = 1) OR (W.util_id <> 93001 AND W.type_id = 2)) AND (M.post_util_id = 93001 OR M.dest_util_id = 93001) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=73786 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 73786 AND W.type_id = 1) OR (W.util_id <> 73786 AND W.type_id = 2)) AND (M.post_util_id = 73786 OR M.dest_util_id = 73786) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=418120 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 418120 AND W.type_id = 1) OR (W.util_id <> 418120 AND W.type_id = 2)) AND (M.post_util_id = 418120 OR M.dest_util_id = 418120) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=210018 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 210018 AND W.type_id = 1) OR (W.util_id <> 210018 AND W.type_id = 2)) AND (M.post_util_id = 210018 OR M.dest_util_id = 210018) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=201214 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 201214 AND W.type_id = 1) OR (W.util_id <> 201214 AND W.type_id = 2)) AND (M.post_util_id = 201214 OR M.dest_util_id = 201214) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (86297,75160,57389,358202,357867,207211,47846,492051,292466,37073,220352,201726,82997,196162,157277,130474,86547,83280,51483,312234,429304,218716,217565,215397,171708,119144,75329,19919,30781,78708,440420,384809,381935,297458,207773,196781,151842,153725,115057,8995,125768,121081,114606,91834,71895,70277,64383,64402,28735,15701,118045,93001,73786,418120,210018,201214)
SELECT util_id, util_photo FROM util_info WHERE util_id IN (86297,75160,57389,358202,357867,207211,47846,492051,292466,37073,220352,201726,82997,196162,157277,130474,86547,83280,51483,312234,429304,218716,217565,215397,171708,119144,75329,19919,30781,78708,440420,384809,381935,297458,207773,196781,151842,153725,115057,8995,125768,121081,114606,91834,71895,70277,64383,64402,28735,15701,118045,93001,73786,418120,210018,201214)
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
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
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (39) ORDER BY ssrubr_order ASC
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT COUNT(*) AS nbavis FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
Contactez-nous