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='garde-d-animaux'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=45
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('92' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT ville_nom FROM villes WHERE ville_cp='92190' AND ville_nom like '%meudon%' 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='92190'
SELECT ville_cp, ROUND((((acos(sin((48.8083*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8083*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.24167- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.628435678816 AND ville_latitude_deg<48.988164321184 AND ville_longitude_deg>1.9685604432363 AND ville_longitude_deg<2.5147795567637 HAVING distance <= 20 ORDER BY distance ASC
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='45' AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp like '92190%'
SELECT * FROM texte WHERE cate_id=45
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='92190'
SELECT ville_cp, ROUND((((acos(sin((48.8083*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8083*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.24167- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.358639197041 AND ville_latitude_deg<49.257960802959 AND ville_longitude_deg>1.5588902204271 AND ville_longitude_deg<2.9244497795729 HAVING distance <= 50 ORDER BY distance ASC
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='45' AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('92190','92360','92190','92140','92130','92100','92320','92310','92370','92350','92410','92260','92330','92210','78140','92240','92220','92290','92170','78220','92120','92420','92430','92380','92150','92800','92340','91370','91570','94250','94110','78350','94231','94238','94239','94237','94236','94235','94232','94233','94230','94234','94240','92160','78000','78170','94260','92200','91430','78150','91430','92500','91300','94550','78350','78530','94270','94800','75012','75008','75011','75010','75009','75013','75014','75015','75016','75017','75018','75019','75116','75020','75004','75000','75006','75002','75007','75001','75005','75003','78150','92400','91400','91120','92250','94150','78380','78290','94200','94205','92000','92300','78400','91320','92110','78430','78117','94320','92600','94400','91140','92700','91160','92270','93400','78560','78800','78870','91380','91160','91400','78420','78210','94140','94220','91190','94160','91440','78160','94310','94390','78117','78590','94600','78280','91190','78110','91550','78360','91420','91140','95870','91160','78330','94700','93310','78750','78590','78620','93170','78230','92230','94300','91940','78112','78114','94290','93500','78100','92390','93450','91200','93100','78960','95100','94410','93120','93300','78180','91190','91940','91160','93210','93200','78500','93260','93230','78470','94480','93800','94340','78390','78600','91360','91940','78450','94000','78470','78860','78600','91360','91260','94190','91270','91620','95110','91390','91600','91620','94460','95210','95218','94130','78190','91700','95530','93430','91400','94120','94380','93000','78240','91560','95880','93130','78470','78460','93110','91640','93240','91170','93350','91210','94210','94100','94340','78340','95360','93140','78240','91230','91460','94170','78450','95130','95120','91310','91310','94450','91310','95240','78300','91470','93380','95230','95370','91240') 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.8083*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8083*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.24167- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='45' AND wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('92190','92360','92190','92140','92130','92100','92320','92310','92370','92350','92410','92260','92330','92210','78140','92240','92220','92290','92170','78220','92120','92420','92430','92380','92150','92800','92340','91370','91570','94250','94110','78350','94231','94238','94239','94237','94236','94235','94232','94233','94230','94234','94240','92160','78000','78170','94260','92200','91430','78150','91430','92500','91300','94550','78350','78530','94270','94800','75012','75008','75011','75010','75009','75013','75014','75015','75016','75017','75018','75019','75116','75020','75004','75000','75006','75002','75007','75001','75005','75003','78150','92400','91400','91120','92250','94150','78380','78290','94200','94205','92000','92300','78400','91320','92110','78430','78117','94320','92600','94400','91140','92700','91160','92270','93400','78560','78800','78870','91380','91160','91400','78420','78210','94140','94220','91190','94160','91440','78160','94310','94390','78117','78590','94600','78280','91190','78110','91550','78360','91420','91140','95870','91160','78330','94700','93310','78750','78590','78620','93170','78230','92230','94300','91940','78112','78114','94290','93500','78100','92390','93450','91200','93100','78960','95100','94410','93120','93300','78180','91190','91940','91160','93210','93200','78500','93260','93230','78470','94480','93800','94340','78390','78600','91360','91940','78450','94000','78470','78860','78600','91360','91260','94190','91270','91620','95110','91390','91600','91620','94460','95210','95218','94130','78190','91700','95530','93430','91400','94120','94380','93000','78240','91560','95880','93130','78470','78460','93110','91640','93240','91170','93350','91210','94210','94100','94340','78340','95360','93140','78240','91230','91460','94170','78450','95130','95120','91310','91310','94450','91310','95240','78300','91470','93380','95230','95370','91240') 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 (312025,187420,197535,95306,42152,300691,195070,150159,137002,128107,118884,525415,479705,399837,127578,123661,64748,111898,395291,375205,310251,129405,195841,177401,168897,166986,86829,63415,445765,153655,137787,125616,5320,152749,176817,218691,94315,165607,278496,270188,187053,141791,128625,107957,87003,355941,272279,96147,546204,91937,28929)
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 (1210,1016,951,950,952,1070)
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=312025 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 = 312025 AND W.type_id = 1) OR (W.util_id <> 312025 AND W.type_id = 2)) AND (M.post_util_id = 312025 OR M.dest_util_id = 312025) 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=187420 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 = 187420 AND W.type_id = 1) OR (W.util_id <> 187420 AND W.type_id = 2)) AND (M.post_util_id = 187420 OR M.dest_util_id = 187420) 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=197535 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 = 197535 AND W.type_id = 1) OR (W.util_id <> 197535 AND W.type_id = 2)) AND (M.post_util_id = 197535 OR M.dest_util_id = 197535) 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=95306 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 = 95306 AND W.type_id = 1) OR (W.util_id <> 95306 AND W.type_id = 2)) AND (M.post_util_id = 95306 OR M.dest_util_id = 95306) 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=42152 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 = 42152 AND W.type_id = 1) OR (W.util_id <> 42152 AND W.type_id = 2)) AND (M.post_util_id = 42152 OR M.dest_util_id = 42152) 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=300691 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 = 300691 AND W.type_id = 1) OR (W.util_id <> 300691 AND W.type_id = 2)) AND (M.post_util_id = 300691 OR M.dest_util_id = 300691) 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=195070 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 = 195070 AND W.type_id = 1) OR (W.util_id <> 195070 AND W.type_id = 2)) AND (M.post_util_id = 195070 OR M.dest_util_id = 195070) 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=150159 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 = 150159 AND W.type_id = 1) OR (W.util_id <> 150159 AND W.type_id = 2)) AND (M.post_util_id = 150159 OR M.dest_util_id = 150159) 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=137002 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 = 137002 AND W.type_id = 1) OR (W.util_id <> 137002 AND W.type_id = 2)) AND (M.post_util_id = 137002 OR M.dest_util_id = 137002) 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=128107 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 = 128107 AND W.type_id = 1) OR (W.util_id <> 128107 AND W.type_id = 2)) AND (M.post_util_id = 128107 OR M.dest_util_id = 128107) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=118884 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 = 118884 AND W.type_id = 1) OR (W.util_id <> 118884 AND W.type_id = 2)) AND (M.post_util_id = 118884 OR M.dest_util_id = 118884) 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=525415 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 = 525415 AND W.type_id = 1) OR (W.util_id <> 525415 AND W.type_id = 2)) AND (M.post_util_id = 525415 OR M.dest_util_id = 525415) 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=479705 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 = 479705 AND W.type_id = 1) OR (W.util_id <> 479705 AND W.type_id = 2)) AND (M.post_util_id = 479705 OR M.dest_util_id = 479705) 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=399837 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 = 399837 AND W.type_id = 1) OR (W.util_id <> 399837 AND W.type_id = 2)) AND (M.post_util_id = 399837 OR M.dest_util_id = 399837) 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=127578 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 = 127578 AND W.type_id = 1) OR (W.util_id <> 127578 AND W.type_id = 2)) AND (M.post_util_id = 127578 OR M.dest_util_id = 127578) 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=123661 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 = 123661 AND W.type_id = 1) OR (W.util_id <> 123661 AND W.type_id = 2)) AND (M.post_util_id = 123661 OR M.dest_util_id = 123661) 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=64748 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 = 64748 AND W.type_id = 1) OR (W.util_id <> 64748 AND W.type_id = 2)) AND (M.post_util_id = 64748 OR M.dest_util_id = 64748) 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=111898 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 = 111898 AND W.type_id = 1) OR (W.util_id <> 111898 AND W.type_id = 2)) AND (M.post_util_id = 111898 OR M.dest_util_id = 111898) 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=395291 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 = 395291 AND W.type_id = 1) OR (W.util_id <> 395291 AND W.type_id = 2)) AND (M.post_util_id = 395291 OR M.dest_util_id = 395291) 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=375205 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 = 375205 AND W.type_id = 1) OR (W.util_id <> 375205 AND W.type_id = 2)) AND (M.post_util_id = 375205 OR M.dest_util_id = 375205) 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=310251 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 = 310251 AND W.type_id = 1) OR (W.util_id <> 310251 AND W.type_id = 2)) AND (M.post_util_id = 310251 OR M.dest_util_id = 310251) 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=129405 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 = 129405 AND W.type_id = 1) OR (W.util_id <> 129405 AND W.type_id = 2)) AND (M.post_util_id = 129405 OR M.dest_util_id = 129405) 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=195841 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 = 195841 AND W.type_id = 1) OR (W.util_id <> 195841 AND W.type_id = 2)) AND (M.post_util_id = 195841 OR M.dest_util_id = 195841) 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=177401 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 = 177401 AND W.type_id = 1) OR (W.util_id <> 177401 AND W.type_id = 2)) AND (M.post_util_id = 177401 OR M.dest_util_id = 177401) 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=168897 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 = 168897 AND W.type_id = 1) OR (W.util_id <> 168897 AND W.type_id = 2)) AND (M.post_util_id = 168897 OR M.dest_util_id = 168897) 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=166986 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 = 166986 AND W.type_id = 1) OR (W.util_id <> 166986 AND W.type_id = 2)) AND (M.post_util_id = 166986 OR M.dest_util_id = 166986) 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=86829 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 = 86829 AND W.type_id = 1) OR (W.util_id <> 86829 AND W.type_id = 2)) AND (M.post_util_id = 86829 OR M.dest_util_id = 86829) 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=63415 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 = 63415 AND W.type_id = 1) OR (W.util_id <> 63415 AND W.type_id = 2)) AND (M.post_util_id = 63415 OR M.dest_util_id = 63415) 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=445765 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 = 445765 AND W.type_id = 1) OR (W.util_id <> 445765 AND W.type_id = 2)) AND (M.post_util_id = 445765 OR M.dest_util_id = 445765) 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=153655 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 = 153655 AND W.type_id = 1) OR (W.util_id <> 153655 AND W.type_id = 2)) AND (M.post_util_id = 153655 OR M.dest_util_id = 153655) 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=137787 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 = 137787 AND W.type_id = 1) OR (W.util_id <> 137787 AND W.type_id = 2)) AND (M.post_util_id = 137787 OR M.dest_util_id = 137787) 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=125616 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 = 125616 AND W.type_id = 1) OR (W.util_id <> 125616 AND W.type_id = 2)) AND (M.post_util_id = 125616 OR M.dest_util_id = 125616) 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=5320 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 = 5320 AND W.type_id = 1) OR (W.util_id <> 5320 AND W.type_id = 2)) AND (M.post_util_id = 5320 OR M.dest_util_id = 5320) 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=152749 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 = 152749 AND W.type_id = 1) OR (W.util_id <> 152749 AND W.type_id = 2)) AND (M.post_util_id = 152749 OR M.dest_util_id = 152749) 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=176817 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 = 176817 AND W.type_id = 1) OR (W.util_id <> 176817 AND W.type_id = 2)) AND (M.post_util_id = 176817 OR M.dest_util_id = 176817) 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=218691 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 = 218691 AND W.type_id = 1) OR (W.util_id <> 218691 AND W.type_id = 2)) AND (M.post_util_id = 218691 OR M.dest_util_id = 218691) 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=94315 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 = 94315 AND W.type_id = 1) OR (W.util_id <> 94315 AND W.type_id = 2)) AND (M.post_util_id = 94315 OR M.dest_util_id = 94315) 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=165607 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 = 165607 AND W.type_id = 1) OR (W.util_id <> 165607 AND W.type_id = 2)) AND (M.post_util_id = 165607 OR M.dest_util_id = 165607) 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=278496 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 = 278496 AND W.type_id = 1) OR (W.util_id <> 278496 AND W.type_id = 2)) AND (M.post_util_id = 278496 OR M.dest_util_id = 278496) 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=270188 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 = 270188 AND W.type_id = 1) OR (W.util_id <> 270188 AND W.type_id = 2)) AND (M.post_util_id = 270188 OR M.dest_util_id = 270188) 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=187053 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 = 187053 AND W.type_id = 1) OR (W.util_id <> 187053 AND W.type_id = 2)) AND (M.post_util_id = 187053 OR M.dest_util_id = 187053) 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=141791 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 = 141791 AND W.type_id = 1) OR (W.util_id <> 141791 AND W.type_id = 2)) AND (M.post_util_id = 141791 OR M.dest_util_id = 141791) 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=128625 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 = 128625 AND W.type_id = 1) OR (W.util_id <> 128625 AND W.type_id = 2)) AND (M.post_util_id = 128625 OR M.dest_util_id = 128625) 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=107957 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 = 107957 AND W.type_id = 1) OR (W.util_id <> 107957 AND W.type_id = 2)) AND (M.post_util_id = 107957 OR M.dest_util_id = 107957) 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=87003 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 = 87003 AND W.type_id = 1) OR (W.util_id <> 87003 AND W.type_id = 2)) AND (M.post_util_id = 87003 OR M.dest_util_id = 87003) 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=355941 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 = 355941 AND W.type_id = 1) OR (W.util_id <> 355941 AND W.type_id = 2)) AND (M.post_util_id = 355941 OR M.dest_util_id = 355941) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=272279 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 = 272279 AND W.type_id = 1) OR (W.util_id <> 272279 AND W.type_id = 2)) AND (M.post_util_id = 272279 OR M.dest_util_id = 272279) 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=96147 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 = 96147 AND W.type_id = 1) OR (W.util_id <> 96147 AND W.type_id = 2)) AND (M.post_util_id = 96147 OR M.dest_util_id = 96147) 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=546204 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 = 546204 AND W.type_id = 1) OR (W.util_id <> 546204 AND W.type_id = 2)) AND (M.post_util_id = 546204 OR M.dest_util_id = 546204) 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=91937 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 = 91937 AND W.type_id = 1) OR (W.util_id <> 91937 AND W.type_id = 2)) AND (M.post_util_id = 91937 OR M.dest_util_id = 91937) 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=28929 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 = 28929 AND W.type_id = 1) OR (W.util_id <> 28929 AND W.type_id = 2)) AND (M.post_util_id = 28929 OR M.dest_util_id = 28929) 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 (312025,187420,197535,95306,42152,300691,195070,150159,137002,128107,118884,525415,479705,399837,127578,123661,64748,111898,395291,375205,310251,129405,195841,177401,168897,166986,86829,63415,445765,153655,137787,125616,5320,152749,176817,218691,94315,165607,278496,270188,187053,141791,128625,107957,87003,355941,272279,96147,546204,91937,28929)
SELECT util_id, util_photo FROM util_info WHERE util_id IN (312025,187420,197535,95306,42152,300691,195070,150159,137002,128107,118884,525415,479705,399837,127578,123661,64748,111898,395291,375205,310251,129405,195841,177401,168897,166986,86829,63415,445765,153655,137787,125616,5320,152749,176817,218691,94315,165607,278496,270188,187053,141791,128625,107957,87003,355941,272279,96147,546204,91937,28929)
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 (45) 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