Indiquer un code postal ou une ville
Poster une annonce
Indiquer un code postal ou une ville
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wall.php
SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='services-divers'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=229
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='94'
SELECT ville_nom FROM villes WHERE ville_cp='94100' AND ville_nom like '%saint%maur%des%fosses%' ORDER BY ville_population_2012 DESC LIMIT 0,1
SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%secretariat%' OR ssrubr_title like '%secretariat%' OR ssrubr_slug like '%secretariat%') AND cate_id='229' ORDER BY ssrubr_id LIMIT 0,1
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='94100'
SELECT ville_cp, ROUND((((acos(sin((48.8*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.620135678816 AND ville_latitude_deg<48.979864321184 AND ville_longitude_deg>2.2269356388795 AND ville_longitude_deg<2.7730643611205 HAVING distance <= 20 ORDER BY distance ASC
SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='secretariat'
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='229'AND MATCH (wish_title,wish_desc) AGAINST ('+secretariat*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '94100%'
SELECT * FROM texte WHERE cate_id=229
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='secretariat' OR ssrubr_slug='secretariat' OR (ssrubr_title like '%secretariat%')) AND cate_id='229' ORDER BY ssrubr_id LIMIT 0,1
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 (229) ORDER BY ssrubr_order ASC
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='secretariat' AND cate_id='229'
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='94100'
SELECT ville_cp, ROUND((((acos(sin((48.8*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.620135678816 AND ville_latitude_deg<48.979864321184 AND ville_longitude_deg>2.2269356388795 AND ville_longitude_deg<2.7730643611205 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((48.8*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.350339197041 AND ville_latitude_deg<49.249660802959 AND ville_longitude_deg>1.8173332105093 AND ville_longitude_deg<3.1826667894907 HAVING distance <= 50 ORDER BY distance ASC
SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='229' AND MATCH (wish_desc) AGAINST ('(+secretariat*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94100,94210,94340,94100,94430,94500,94000,94340,94410,94380,94360,94130,94880,94880,94490,94380,94370,94700,94350,94420,94170,94470,94120,94460,93330,94140,94510,94220,94600,94160,93160,94300,93110,94450,93360,94400,77340,94190,94440,94205,77184,94200,93100,93460,77420,94390,94310,93250,91330,77185,94320,93220,93130,94440,93170,94290,94800,94270,91560,93230,93260,94440,77680,94480,77170,91800,93320,93340,77186,77150,93140,94550,93000,94520,94520,91230,77500,93310,91200,93370,94110,77150,77200,94150,94237,94236,94250,94240,94230,94231,94232,94233,94238,94234,94235,94239,91270,77090,77183,77330,91860,91800,75001,75000,75002,75003,75004,75005,75012,75006,75007,75116,75020,75019,75018,75017,75016,75015,75013,75011,75010,75009,75008,75014,77360,93500,77177,91550,93390,93190,92120,92340,91480,91320,91210,77181,93470,77600,94260,77135,92220,92240,93270,91480,92170,77164,93700,93150,77173,77400,93300,93120,77181,77170,91260,93410,77380,77600,77600,92160,92320,92260,92330,93350,77400,77400,93400,91420,93600,77410,91450,92140,77270,91170,77600,92130,92350,92290,77400,91300,93440,91000,91130,77166,91370,93210,93200,93290,77400,92110,91380,91160,91390,91600,91250,77600,77220,77600,92100,93420,91450,93240,91350,77166,77127,91090,91000,92360,92190,95500,92390,93450,91360,92300,77400,77400,92200,95140,77144,92600)
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- 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='229' AND MATCH (wish_desc) AGAINST ('(+secretariat*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94100,94210,94340,94100,94430,94500,94000,94340,94410,94380,94360,94130,94880,94880,94490,94380,94370,94700,94350,94420,94170,94470,94120,94460,93330,94140,94510,94220,94600,94160,93160,94300,93110,94450,93360,94400,77340,94190,94440,94205,77184,94200,93100,93460,77420,94390,94310,93250,91330,77185,94320,93220,93130,94440,93170,94290,94800,94270,91560,93230,93260,94440,77680,94480,77170,91800,93320,93340,77186,77150,93140,94550,93000,94520,94520,91230,77500,93310,91200,93370,94110,77150,77200,94150,94237,94236,94250,94240,94230,94231,94232,94233,94238,94234,94235,94239,91270,77090,77183,77330,91860,91800,75001,75000,75002,75003,75004,75005,75012,75006,75007,75116,75020,75019,75018,75017,75016,75015,75013,75011,75010,75009,75008,75014,77360,93500,77177,91550,93390,93190,92120,92340,91480,91320,91210,77181,93470,77600,94260,77135,92220,92240,93270,91480,92170,77164,93700,93150,77173,77400,93300,93120,77181,77170,91260,93410,77380,77600,77600,92160,92320,92260,92330,93350,77400,77400,93400,91420,93600,77410,91450,92140,77270,91170,77600,92130,92350,92290,77400,91300,93440,91000,91130,77166,91370,93210,93200,93290,77400,92110,91380,91160,91390,91600,91250,77600,77220,77600,92100,93420,91450,93240,91350,77166,77127,91090,91000,92360,92190,95500,92390,93450,91360,92300,77400,77400,92200,95140,77144,92600) AND type_id=1 GROUP BY wish_id
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='94100'
SELECT ville_cp, ROUND((((acos(sin((48.8*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.620135678816 AND ville_latitude_deg<48.979864321184 AND ville_longitude_deg>2.2269356388795 AND ville_longitude_deg<2.7730643611205 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((48.8*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.350339197041 AND ville_latitude_deg<49.249660802959 AND ville_longitude_deg>1.8173332105093 AND ville_longitude_deg<3.1826667894907 HAVING distance <= 50 ORDER BY distance ASC
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 37618 AND W.type_id = 1) OR (W.util_id != 37618 AND W.type_id = 2)) AND (`post_util_id` = 37618 OR `dest_util_id` = 37618) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=37618 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 39994 AND W.type_id = 1) OR (W.util_id != 39994 AND W.type_id = 2)) AND (`post_util_id` = 39994 OR `dest_util_id` = 39994) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=39994 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 39994 AND W.type_id = 1) OR (W.util_id != 39994 AND W.type_id = 2)) AND (`post_util_id` = 39994 OR `dest_util_id` = 39994) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 47918 AND W.type_id = 1) OR (W.util_id != 47918 AND W.type_id = 2)) AND (`post_util_id` = 47918 OR `dest_util_id` = 47918) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=47918 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 51050 AND W.type_id = 1) OR (W.util_id != 51050 AND W.type_id = 2)) AND (`post_util_id` = 51050 OR `dest_util_id` = 51050) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=51050 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 23960 AND W.type_id = 1) OR (W.util_id != 23960 AND W.type_id = 2)) AND (`post_util_id` = 23960 OR `dest_util_id` = 23960) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=23960 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 1568 AND W.type_id = 1) OR (W.util_id != 1568 AND W.type_id = 2)) AND (`post_util_id` = 1568 OR `dest_util_id` = 1568) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=1568 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 62087 AND W.type_id = 1) OR (W.util_id != 62087 AND W.type_id = 2)) AND (`post_util_id` = 62087 OR `dest_util_id` = 62087) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=62087 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 77353 AND W.type_id = 1) OR (W.util_id != 77353 AND W.type_id = 2)) AND (`post_util_id` = 77353 OR `dest_util_id` = 77353) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=77353 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 38727 AND W.type_id = 1) OR (W.util_id != 38727 AND W.type_id = 2)) AND (`post_util_id` = 38727 OR `dest_util_id` = 38727) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=38727 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 91339 AND W.type_id = 1) OR (W.util_id != 91339 AND W.type_id = 2)) AND (`post_util_id` = 91339 OR `dest_util_id` = 91339) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=91339 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 91934 AND W.type_id = 1) OR (W.util_id != 91934 AND W.type_id = 2)) AND (`post_util_id` = 91934 OR `dest_util_id` = 91934) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=91934 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 99578 AND W.type_id = 1) OR (W.util_id != 99578 AND W.type_id = 2)) AND (`post_util_id` = 99578 OR `dest_util_id` = 99578) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=99578 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 107628 AND W.type_id = 1) OR (W.util_id != 107628 AND W.type_id = 2)) AND (`post_util_id` = 107628 OR `dest_util_id` = 107628) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=107628 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 109863 AND W.type_id = 1) OR (W.util_id != 109863 AND W.type_id = 2)) AND (`post_util_id` = 109863 OR `dest_util_id` = 109863) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=109863 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 102544 AND W.type_id = 1) OR (W.util_id != 102544 AND W.type_id = 2)) AND (`post_util_id` = 102544 OR `dest_util_id` = 102544) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=102544 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 116890 AND W.type_id = 1) OR (W.util_id != 116890 AND W.type_id = 2)) AND (`post_util_id` = 116890 OR `dest_util_id` = 116890) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=116890 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 121201 AND W.type_id = 1) OR (W.util_id != 121201 AND W.type_id = 2)) AND (`post_util_id` = 121201 OR `dest_util_id` = 121201) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=121201 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 122800 AND W.type_id = 1) OR (W.util_id != 122800 AND W.type_id = 2)) AND (`post_util_id` = 122800 OR `dest_util_id` = 122800) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=122800 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 122800 AND W.type_id = 1) OR (W.util_id != 122800 AND W.type_id = 2)) AND (`post_util_id` = 122800 OR `dest_util_id` = 122800) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 120996 AND W.type_id = 1) OR (W.util_id != 120996 AND W.type_id = 2)) AND (`post_util_id` = 120996 OR `dest_util_id` = 120996) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=120996 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 129684 AND W.type_id = 1) OR (W.util_id != 129684 AND W.type_id = 2)) AND (`post_util_id` = 129684 OR `dest_util_id` = 129684) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=129684 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 134761 AND W.type_id = 1) OR (W.util_id != 134761 AND W.type_id = 2)) AND (`post_util_id` = 134761 OR `dest_util_id` = 134761) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=134761 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137350 AND W.type_id = 1) OR (W.util_id != 137350 AND W.type_id = 2)) AND (`post_util_id` = 137350 OR `dest_util_id` = 137350) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=137350 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 132549 AND W.type_id = 1) OR (W.util_id != 132549 AND W.type_id = 2)) AND (`post_util_id` = 132549 OR `dest_util_id` = 132549) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=132549 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 130199 AND W.type_id = 1) OR (W.util_id != 130199 AND W.type_id = 2)) AND (`post_util_id` = 130199 OR `dest_util_id` = 130199) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=130199 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 132549 AND W.type_id = 1) OR (W.util_id != 132549 AND W.type_id = 2)) AND (`post_util_id` = 132549 OR `dest_util_id` = 132549) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 119116 AND W.type_id = 1) OR (W.util_id != 119116 AND W.type_id = 2)) AND (`post_util_id` = 119116 OR `dest_util_id` = 119116) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=119116 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 140733 AND W.type_id = 1) OR (W.util_id != 140733 AND W.type_id = 2)) AND (`post_util_id` = 140733 OR `dest_util_id` = 140733) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=140733 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 132549 AND W.type_id = 1) OR (W.util_id != 132549 AND W.type_id = 2)) AND (`post_util_id` = 132549 OR `dest_util_id` = 132549) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 153754 AND W.type_id = 1) OR (W.util_id != 153754 AND W.type_id = 2)) AND (`post_util_id` = 153754 OR `dest_util_id` = 153754) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=153754 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 156236 AND W.type_id = 1) OR (W.util_id != 156236 AND W.type_id = 2)) AND (`post_util_id` = 156236 OR `dest_util_id` = 156236) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=156236 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 160563 AND W.type_id = 1) OR (W.util_id != 160563 AND W.type_id = 2)) AND (`post_util_id` = 160563 OR `dest_util_id` = 160563) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=160563 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 177728 AND W.type_id = 1) OR (W.util_id != 177728 AND W.type_id = 2)) AND (`post_util_id` = 177728 OR `dest_util_id` = 177728) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=177728 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 156089 AND W.type_id = 1) OR (W.util_id != 156089 AND W.type_id = 2)) AND (`post_util_id` = 156089 OR `dest_util_id` = 156089) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=156089 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 127039 AND W.type_id = 1) OR (W.util_id != 127039 AND W.type_id = 2)) AND (`post_util_id` = 127039 OR `dest_util_id` = 127039) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=127039 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 127039 AND W.type_id = 1) OR (W.util_id != 127039 AND W.type_id = 2)) AND (`post_util_id` = 127039 OR `dest_util_id` = 127039) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 193586 AND W.type_id = 1) OR (W.util_id != 193586 AND W.type_id = 2)) AND (`post_util_id` = 193586 OR `dest_util_id` = 193586) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=193586 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 197030 AND W.type_id = 1) OR (W.util_id != 197030 AND W.type_id = 2)) AND (`post_util_id` = 197030 OR `dest_util_id` = 197030) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=197030 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 140733 AND W.type_id = 1) OR (W.util_id != 140733 AND W.type_id = 2)) AND (`post_util_id` = 140733 OR `dest_util_id` = 140733) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 208105 AND W.type_id = 1) OR (W.util_id != 208105 AND W.type_id = 2)) AND (`post_util_id` = 208105 OR `dest_util_id` = 208105) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=208105 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 217775 AND W.type_id = 1) OR (W.util_id != 217775 AND W.type_id = 2)) AND (`post_util_id` = 217775 OR `dest_util_id` = 217775) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=217775 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 220972 AND W.type_id = 1) OR (W.util_id != 220972 AND W.type_id = 2)) AND (`post_util_id` = 220972 OR `dest_util_id` = 220972) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=220972 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 221390 AND W.type_id = 1) OR (W.util_id != 221390 AND W.type_id = 2)) AND (`post_util_id` = 221390 OR `dest_util_id` = 221390) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=221390 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 222547 AND W.type_id = 1) OR (W.util_id != 222547 AND W.type_id = 2)) AND (`post_util_id` = 222547 OR `dest_util_id` = 222547) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=222547 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 243450 AND W.type_id = 1) OR (W.util_id != 243450 AND W.type_id = 2)) AND (`post_util_id` = 243450 OR `dest_util_id` = 243450) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=243450 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 243450 AND W.type_id = 1) OR (W.util_id != 243450 AND W.type_id = 2)) AND (`post_util_id` = 243450 OR `dest_util_id` = 243450) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 104109 AND W.type_id = 1) OR (W.util_id != 104109 AND W.type_id = 2)) AND (`post_util_id` = 104109 OR `dest_util_id` = 104109) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=104109 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 114797 AND W.type_id = 1) OR (W.util_id != 114797 AND W.type_id = 2)) AND (`post_util_id` = 114797 OR `dest_util_id` = 114797) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=114797 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 114797 AND W.type_id = 1) OR (W.util_id != 114797 AND W.type_id = 2)) AND (`post_util_id` = 114797 OR `dest_util_id` = 114797) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 127743 AND W.type_id = 1) OR (W.util_id != 127743 AND W.type_id = 2)) AND (`post_util_id` = 127743 OR `dest_util_id` = 127743) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=127743 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 267154 AND W.type_id = 1) OR (W.util_id != 267154 AND W.type_id = 2)) AND (`post_util_id` = 267154 OR `dest_util_id` = 267154) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=267154 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 277299 OR `dest_util_id` = 277299) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
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)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 280301 AND W.type_id = 1) OR (W.util_id != 280301 AND W.type_id = 2)) AND (`post_util_id` = 280301 OR `dest_util_id` = 280301) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=280301 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 104857 AND W.type_id = 1) OR (W.util_id != 104857 AND W.type_id = 2)) AND (`post_util_id` = 104857 OR `dest_util_id` = 104857) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=104857 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 283023 AND W.type_id = 1) OR (W.util_id != 283023 AND W.type_id = 2)) AND (`post_util_id` = 283023 OR `dest_util_id` = 283023) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=283023 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 136590 AND W.type_id = 1) OR (W.util_id != 136590 AND W.type_id = 2)) AND (`post_util_id` = 136590 OR `dest_util_id` = 136590) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=136590 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 289337 AND W.type_id = 1) OR (W.util_id != 289337 AND W.type_id = 2)) AND (`post_util_id` = 289337 OR `dest_util_id` = 289337) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=289337 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 290060 AND W.type_id = 1) OR (W.util_id != 290060 AND W.type_id = 2)) AND (`post_util_id` = 290060 OR `dest_util_id` = 290060) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=290060 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 216278 OR `dest_util_id` = 216278) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
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)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 211637 AND W.type_id = 1) OR (W.util_id != 211637 AND W.type_id = 2)) AND (`post_util_id` = 211637 OR `dest_util_id` = 211637) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=211637 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 299014 AND W.type_id = 1) OR (W.util_id != 299014 AND W.type_id = 2)) AND (`post_util_id` = 299014 OR `dest_util_id` = 299014) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=299014 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 308283 AND W.type_id = 1) OR (W.util_id != 308283 AND W.type_id = 2)) AND (`post_util_id` = 308283 OR `dest_util_id` = 308283) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=308283 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 305638 AND W.type_id = 1) OR (W.util_id != 305638 AND W.type_id = 2)) AND (`post_util_id` = 305638 OR `dest_util_id` = 305638) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=305638 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 272982 AND W.type_id = 1) OR (W.util_id != 272982 AND W.type_id = 2)) AND (`post_util_id` = 272982 OR `dest_util_id` = 272982) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=272982 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 317512 AND W.type_id = 1) OR (W.util_id != 317512 AND W.type_id = 2)) AND (`post_util_id` = 317512 OR `dest_util_id` = 317512) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=317512 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 322834 AND W.type_id = 1) OR (W.util_id != 322834 AND W.type_id = 2)) AND (`post_util_id` = 322834 OR `dest_util_id` = 322834) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=322834 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 325195 AND W.type_id = 1) OR (W.util_id != 325195 AND W.type_id = 2)) AND (`post_util_id` = 325195 OR `dest_util_id` = 325195) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=325195 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 251000 AND W.type_id = 1) OR (W.util_id != 251000 AND W.type_id = 2)) AND (`post_util_id` = 251000 OR `dest_util_id` = 251000) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=251000 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 331305 AND W.type_id = 1) OR (W.util_id != 331305 AND W.type_id = 2)) AND (`post_util_id` = 331305 OR `dest_util_id` = 331305) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=331305 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 339683 AND W.type_id = 1) OR (W.util_id != 339683 AND W.type_id = 2)) AND (`post_util_id` = 339683 OR `dest_util_id` = 339683) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=339683 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 54659 AND W.type_id = 1) OR (W.util_id != 54659 AND W.type_id = 2)) AND (`post_util_id` = 54659 OR `dest_util_id` = 54659) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=54659 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 352882 AND W.type_id = 1) OR (W.util_id != 352882 AND W.type_id = 2)) AND (`post_util_id` = 352882 OR `dest_util_id` = 352882) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=352882 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 357101 AND W.type_id = 1) OR (W.util_id != 357101 AND W.type_id = 2)) AND (`post_util_id` = 357101 OR `dest_util_id` = 357101) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=357101 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 357720 AND W.type_id = 1) OR (W.util_id != 357720 AND W.type_id = 2)) AND (`post_util_id` = 357720 OR `dest_util_id` = 357720) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=357720 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 361614 AND W.type_id = 1) OR (W.util_id != 361614 AND W.type_id = 2)) AND (`post_util_id` = 361614 OR `dest_util_id` = 361614) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=361614 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 362588 AND W.type_id = 1) OR (W.util_id != 362588 AND W.type_id = 2)) AND (`post_util_id` = 362588 OR `dest_util_id` = 362588) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=362588 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 366185 AND W.type_id = 1) OR (W.util_id != 366185 AND W.type_id = 2)) AND (`post_util_id` = 366185 OR `dest_util_id` = 366185) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=366185 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 373194 AND W.type_id = 1) OR (W.util_id != 373194 AND W.type_id = 2)) AND (`post_util_id` = 373194 OR `dest_util_id` = 373194) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=373194 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 374064 AND W.type_id = 1) OR (W.util_id != 374064 AND W.type_id = 2)) AND (`post_util_id` = 374064 OR `dest_util_id` = 374064) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=374064 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 375841 AND W.type_id = 1) OR (W.util_id != 375841 AND W.type_id = 2)) AND (`post_util_id` = 375841 OR `dest_util_id` = 375841) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=375841 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 381705 AND W.type_id = 1) OR (W.util_id != 381705 AND W.type_id = 2)) AND (`post_util_id` = 381705 OR `dest_util_id` = 381705) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=381705 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 382806 AND W.type_id = 1) OR (W.util_id != 382806 AND W.type_id = 2)) AND (`post_util_id` = 382806 OR `dest_util_id` = 382806) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=382806 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 389252 AND W.type_id = 1) OR (W.util_id != 389252 AND W.type_id = 2)) AND (`post_util_id` = 389252 OR `dest_util_id` = 389252) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=389252 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 389252 AND W.type_id = 1) OR (W.util_id != 389252 AND W.type_id = 2)) AND (`post_util_id` = 389252 OR `dest_util_id` = 389252) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 392309 AND W.type_id = 1) OR (W.util_id != 392309 AND W.type_id = 2)) AND (`post_util_id` = 392309 OR `dest_util_id` = 392309) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=392309 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 395309 AND W.type_id = 1) OR (W.util_id != 395309 AND W.type_id = 2)) AND (`post_util_id` = 395309 OR `dest_util_id` = 395309) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=395309 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 51576 AND W.type_id = 1) OR (W.util_id != 51576 AND W.type_id = 2)) AND (`post_util_id` = 51576 OR `dest_util_id` = 51576) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=51576 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 398614 AND W.type_id = 1) OR (W.util_id != 398614 AND W.type_id = 2)) AND (`post_util_id` = 398614 OR `dest_util_id` = 398614) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=398614 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 78749 AND W.type_id = 1) OR (W.util_id != 78749 AND W.type_id = 2)) AND (`post_util_id` = 78749 OR `dest_util_id` = 78749) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=78749 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 405343 AND W.type_id = 1) OR (W.util_id != 405343 AND W.type_id = 2)) AND (`post_util_id` = 405343 OR `dest_util_id` = 405343) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=405343 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 238823 AND W.type_id = 1) OR (W.util_id != 238823 AND W.type_id = 2)) AND (`post_util_id` = 238823 OR `dest_util_id` = 238823) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=238823 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 407226 AND W.type_id = 1) OR (W.util_id != 407226 AND W.type_id = 2)) AND (`post_util_id` = 407226 OR `dest_util_id` = 407226) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=407226 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 409223 AND W.type_id = 1) OR (W.util_id != 409223 AND W.type_id = 2)) AND (`post_util_id` = 409223 OR `dest_util_id` = 409223) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=409223 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 411631 AND W.type_id = 1) OR (W.util_id != 411631 AND W.type_id = 2)) AND (`post_util_id` = 411631 OR `dest_util_id` = 411631) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=411631 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 420841 AND W.type_id = 1) OR (W.util_id != 420841 AND W.type_id = 2)) AND (`post_util_id` = 420841 OR `dest_util_id` = 420841) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=420841 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 434148 AND W.type_id = 1) OR (W.util_id != 434148 AND W.type_id = 2)) AND (`post_util_id` = 434148 OR `dest_util_id` = 434148) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=434148 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 451980 AND W.type_id = 1) OR (W.util_id != 451980 AND W.type_id = 2)) AND (`post_util_id` = 451980 OR `dest_util_id` = 451980) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=451980 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 457703 AND W.type_id = 1) OR (W.util_id != 457703 AND W.type_id = 2)) AND (`post_util_id` = 457703 OR `dest_util_id` = 457703) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=457703 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 470446 AND W.type_id = 1) OR (W.util_id != 470446 AND W.type_id = 2)) AND (`post_util_id` = 470446 OR `dest_util_id` = 470446) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=470446 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 305067 AND W.type_id = 1) OR (W.util_id != 305067 AND W.type_id = 2)) AND (`post_util_id` = 305067 OR `dest_util_id` = 305067) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=305067 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 479297 AND W.type_id = 1) OR (W.util_id != 479297 AND W.type_id = 2)) AND (`post_util_id` = 479297 OR `dest_util_id` = 479297) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=479297 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 482876 AND W.type_id = 1) OR (W.util_id != 482876 AND W.type_id = 2)) AND (`post_util_id` = 482876 OR `dest_util_id` = 482876) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=482876 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 160318 AND W.type_id = 1) OR (W.util_id != 160318 AND W.type_id = 2)) AND (`post_util_id` = 160318 OR `dest_util_id` = 160318) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=160318 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 490311 AND W.type_id = 1) OR (W.util_id != 490311 AND W.type_id = 2)) AND (`post_util_id` = 490311 OR `dest_util_id` = 490311) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=490311 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 490736 AND W.type_id = 1) OR (W.util_id != 490736 AND W.type_id = 2)) AND (`post_util_id` = 490736 OR `dest_util_id` = 490736) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=490736 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 491334 AND W.type_id = 1) OR (W.util_id != 491334 AND W.type_id = 2)) AND (`post_util_id` = 491334 OR `dest_util_id` = 491334) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=491334 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 115561 AND W.type_id = 1) OR (W.util_id != 115561 AND W.type_id = 2)) AND (`post_util_id` = 115561 OR `dest_util_id` = 115561) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=115561 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 529313 AND W.type_id = 1) OR (W.util_id != 529313 AND W.type_id = 2)) AND (`post_util_id` = 529313 OR `dest_util_id` = 529313) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=529313 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 477885 AND W.type_id = 1) OR (W.util_id != 477885 AND W.type_id = 2)) AND (`post_util_id` = 477885 OR `dest_util_id` = 477885) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=477885 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 88342 AND W.type_id = 1) OR (W.util_id != 88342 AND W.type_id = 2)) AND (`post_util_id` = 88342 OR `dest_util_id` = 88342) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=88342 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 542920 AND W.type_id = 1) OR (W.util_id != 542920 AND W.type_id = 2)) AND (`post_util_id` = 542920 OR `dest_util_id` = 542920) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=542920 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 544081 AND W.type_id = 1) OR (W.util_id != 544081 AND W.type_id = 2)) AND (`post_util_id` = 544081 OR `dest_util_id` = 544081) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=544081 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT 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 (`post_util_id` = 545634 OR `dest_util_id` = 545634) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
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)
SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND ss.cate_id=229 AND ss.fami_id=3 ORDER BY ssrubr_order LIMIT 6,100
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='secretariat' OR ssrubr_slug like '%secretariat%' OR MATCH (ssrubr_slug) AGAINST ('(+secretariat)')) AND sk.ssrubr_id='1134' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
SELECT * FROM actu WHERE ssrubr_id='1134' AND actu_niveau=0 ORDER BY actu_ordre DESC
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish
SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC
Contactez-nous