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='babysitting'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=39
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='94'
SELECT ville_nom FROM villes WHERE ville_cp='94600' AND ville_nom like '%choisy%le%roi%' 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 '%nounou%' OR ssrubr_title like '%nounou%' OR ssrubr_slug like '%nounou%') AND cate_id='39' ORDER BY ssrubr_id LIMIT 0,1
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='94600'
SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.586835678816 AND ville_latitude_deg<48.946564321184 AND ville_longitude_deg>2.1437867581343 AND ville_longitude_deg<2.6895532418657 HAVING distance <= 20 ORDER BY distance ASC
SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='nounou'
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='39'AND MATCH (wish_title,wish_desc) AGAINST ('+nounou*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '94600%'
SELECT * FROM texte WHERE cate_id=39
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='nounou' OR ssrubr_slug='nounou' OR (ssrubr_title like '%nounou%')) AND cate_id='39' 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 (39) ORDER BY ssrubr_order ASC
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='nounou' AND cate_id='39'
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='94600'
SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.586835678816 AND ville_latitude_deg<48.946564321184 AND ville_longitude_deg>2.1437867581343 AND ville_longitude_deg<2.6895532418657 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.317039197041 AND ville_latitude_deg<49.216360802959 AND ville_longitude_deg>1.7344560125509 AND ville_longitude_deg<3.0988839874491 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='39' AND MATCH (wish_desc) AGAINST ('(+nounou*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94600,94600,94400,94390,94310,94320,94140,94290,94700,94000,94460,94190,94550,94380,94800,94150,94480,94220,91200,94200,91560,94205,94450,94410,94236,94239,94232,94234,94233,94231,94237,94238,94230,94240,94235,94270,91550,94340,94210,94110,94100,94340,91320,92340,94160,91270,94260,94470,91230,94430,94250,91330,94380,94370,92160,94130,92120,94500,91210,92220,94300,91260,91420,91800,94880,94880,94490,92330,92260,92240,94440,94360,92320,91300,94440,94120,92290,94170,93170,92350,91370,93100,92170,91380,91160,91170,92140,75006,75013,75009,75015,75010,75001,75011,75014,75012,75016,75020,75018,75019,75116,75017,75008,75002,75007,75000,75003,75004,75005,91860,93110,91600,91390,94350,94520,94520,92130,94420,94440,94510,93330,91800,91360,91130,91000,93230,93310,93260,91450,91350,91160,93360,91360,91120,77170,93130,92360,92190,91480,77340,92100,91140,93250,93160,91480,91160,91570,91160,93500,93000,91000,91090,77150,91430,93140,91450,91700,93220,91700,93460,77380,77184,93400,91250,91700,92370,91430,77150,77420,91140,77185,93320,93340,91080,92310,92210,93120,93300,91070,92200,91620,92110,91240,77170,91250,92150,92800,78140,77680,92410,92300,91280,77127,91310,91220,91220,78350,77330,77186,93370,91310,91310,93350,91090,91400,77500,93700,93150,91620,78220,91400,92600,92400,93200,92380,93210,77173,91100,92420,92430,92250,93390,93190,77200,93450,92390,91250,77090,77183,91440,92270)
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.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='39' AND MATCH (wish_desc) AGAINST ('(+nounou*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94600,94600,94400,94390,94310,94320,94140,94290,94700,94000,94460,94190,94550,94380,94800,94150,94480,94220,91200,94200,91560,94205,94450,94410,94236,94239,94232,94234,94233,94231,94237,94238,94230,94240,94235,94270,91550,94340,94210,94110,94100,94340,91320,92340,94160,91270,94260,94470,91230,94430,94250,91330,94380,94370,92160,94130,92120,94500,91210,92220,94300,91260,91420,91800,94880,94880,94490,92330,92260,92240,94440,94360,92320,91300,94440,94120,92290,94170,93170,92350,91370,93100,92170,91380,91160,91170,92140,75006,75013,75009,75015,75010,75001,75011,75014,75012,75016,75020,75018,75019,75116,75017,75008,75002,75007,75000,75003,75004,75005,91860,93110,91600,91390,94350,94520,94520,92130,94420,94440,94510,93330,91800,91360,91130,91000,93230,93310,93260,91450,91350,91160,93360,91360,91120,77170,93130,92360,92190,91480,77340,92100,91140,93250,93160,91480,91160,91570,91160,93500,93000,91000,91090,77150,91430,93140,91450,91700,93220,91700,93460,77380,77184,93400,91250,91700,92370,91430,77150,77420,91140,77185,93320,93340,91080,92310,92210,93120,93300,91070,92200,91620,92110,91240,77170,91250,92150,92800,78140,77680,92410,92300,91280,77127,91310,91220,91220,78350,77330,77186,93370,91310,91310,93350,91090,91400,77500,93700,93150,91620,78220,91400,92600,92400,93200,92380,93210,77173,91100,92420,92430,92250,93390,93190,77200,93450,92390,91250,77090,77183,91440,92270) AND type_id=1 GROUP BY wish_id
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='94600'
SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.586835678816 AND ville_latitude_deg<48.946564321184 AND ville_longitude_deg>2.1437867581343 AND ville_longitude_deg<2.6895532418657 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.41667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.317039197041 AND ville_latitude_deg<49.216360802959 AND ville_longitude_deg>1.7344560125509 AND ville_longitude_deg<3.0988839874491 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 = 4676 AND W.type_id = 1) OR (W.util_id != 4676 AND W.type_id = 2)) AND (`post_util_id` = 4676 OR `dest_util_id` = 4676) 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=4676 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 = 5748 AND W.type_id = 1) OR (W.util_id != 5748 AND W.type_id = 2)) AND (`post_util_id` = 5748 OR `dest_util_id` = 5748) 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=5748 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 = 6534 AND W.type_id = 1) OR (W.util_id != 6534 AND W.type_id = 2)) AND (`post_util_id` = 6534 OR `dest_util_id` = 6534) 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=6534 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 = 7137 AND W.type_id = 1) OR (W.util_id != 7137 AND W.type_id = 2)) AND (`post_util_id` = 7137 OR `dest_util_id` = 7137) 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=7137 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 = 6315 AND W.type_id = 1) OR (W.util_id != 6315 AND W.type_id = 2)) AND (`post_util_id` = 6315 OR `dest_util_id` = 6315) 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=6315 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 = 6315 AND W.type_id = 1) OR (W.util_id != 6315 AND W.type_id = 2)) AND (`post_util_id` = 6315 OR `dest_util_id` = 6315) 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 = 15090 AND W.type_id = 1) OR (W.util_id != 15090 AND W.type_id = 2)) AND (`post_util_id` = 15090 OR `dest_util_id` = 15090) 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=15090 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 = 15090 AND W.type_id = 1) OR (W.util_id != 15090 AND W.type_id = 2)) AND (`post_util_id` = 15090 OR `dest_util_id` = 15090) 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 = 19919 AND W.type_id = 1) OR (W.util_id != 19919 AND W.type_id = 2)) AND (`post_util_id` = 19919 OR `dest_util_id` = 19919) 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=19919 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 = 21328 AND W.type_id = 1) OR (W.util_id != 21328 AND W.type_id = 2)) AND (`post_util_id` = 21328 OR `dest_util_id` = 21328) 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=21328 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 = 23390 AND W.type_id = 1) OR (W.util_id != 23390 AND W.type_id = 2)) AND (`post_util_id` = 23390 OR `dest_util_id` = 23390) 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=23390 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 = 47081 AND W.type_id = 1) OR (W.util_id != 47081 AND W.type_id = 2)) AND (`post_util_id` = 47081 OR `dest_util_id` = 47081) 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=47081 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 = 47748 AND W.type_id = 1) OR (W.util_id != 47748 AND W.type_id = 2)) AND (`post_util_id` = 47748 OR `dest_util_id` = 47748) 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=47748 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 = 51988 AND W.type_id = 1) OR (W.util_id != 51988 AND W.type_id = 2)) AND (`post_util_id` = 51988 OR `dest_util_id` = 51988) 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=51988 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 = 54667 AND W.type_id = 1) OR (W.util_id != 54667 AND W.type_id = 2)) AND (`post_util_id` = 54667 OR `dest_util_id` = 54667) 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=54667 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 = 55220 AND W.type_id = 1) OR (W.util_id != 55220 AND W.type_id = 2)) AND (`post_util_id` = 55220 OR `dest_util_id` = 55220) 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=55220 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 = 56936 AND W.type_id = 1) OR (W.util_id != 56936 AND W.type_id = 2)) AND (`post_util_id` = 56936 OR `dest_util_id` = 56936) 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=56936 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 = 57389 AND W.type_id = 1) OR (W.util_id != 57389 AND W.type_id = 2)) AND (`post_util_id` = 57389 OR `dest_util_id` = 57389) 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=57389 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 = 58216 AND W.type_id = 1) OR (W.util_id != 58216 AND W.type_id = 2)) AND (`post_util_id` = 58216 OR `dest_util_id` = 58216) 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=58216 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 = 60086 AND W.type_id = 1) OR (W.util_id != 60086 AND W.type_id = 2)) AND (`post_util_id` = 60086 OR `dest_util_id` = 60086) 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=60086 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 = 64791 AND W.type_id = 1) OR (W.util_id != 64791 AND W.type_id = 2)) AND (`post_util_id` = 64791 OR `dest_util_id` = 64791) 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=64791 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 = 65520 AND W.type_id = 1) OR (W.util_id != 65520 AND W.type_id = 2)) AND (`post_util_id` = 65520 OR `dest_util_id` = 65520) 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=65520 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 = 66723 AND W.type_id = 1) OR (W.util_id != 66723 AND W.type_id = 2)) AND (`post_util_id` = 66723 OR `dest_util_id` = 66723) 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=66723 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 = 69361 AND W.type_id = 1) OR (W.util_id != 69361 AND W.type_id = 2)) AND (`post_util_id` = 69361 OR `dest_util_id` = 69361) 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=69361 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 = 70277 AND W.type_id = 1) OR (W.util_id != 70277 AND W.type_id = 2)) AND (`post_util_id` = 70277 OR `dest_util_id` = 70277) 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=70277 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 = 72555 AND W.type_id = 1) OR (W.util_id != 72555 AND W.type_id = 2)) AND (`post_util_id` = 72555 OR `dest_util_id` = 72555) 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=72555 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 = 73885 AND W.type_id = 1) OR (W.util_id != 73885 AND W.type_id = 2)) AND (`post_util_id` = 73885 OR `dest_util_id` = 73885) 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=73885 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 = 75114 AND W.type_id = 1) OR (W.util_id != 75114 AND W.type_id = 2)) AND (`post_util_id` = 75114 OR `dest_util_id` = 75114) 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=75114 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 = 75192 AND W.type_id = 1) OR (W.util_id != 75192 AND W.type_id = 2)) AND (`post_util_id` = 75192 OR `dest_util_id` = 75192) 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=75192 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 = 69187 AND W.type_id = 1) OR (W.util_id != 69187 AND W.type_id = 2)) AND (`post_util_id` = 69187 OR `dest_util_id` = 69187) 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=69187 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 = 79331 AND W.type_id = 1) OR (W.util_id != 79331 AND W.type_id = 2)) AND (`post_util_id` = 79331 OR `dest_util_id` = 79331) 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=79331 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 = 82997 AND W.type_id = 1) OR (W.util_id != 82997 AND W.type_id = 2)) AND (`post_util_id` = 82997 OR `dest_util_id` = 82997) 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=82997 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 = 83418 AND W.type_id = 1) OR (W.util_id != 83418 AND W.type_id = 2)) AND (`post_util_id` = 83418 OR `dest_util_id` = 83418) 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=83418 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 = 44842 AND W.type_id = 1) OR (W.util_id != 44842 AND W.type_id = 2)) AND (`post_util_id` = 44842 OR `dest_util_id` = 44842) 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=44842 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 = 87316 AND W.type_id = 1) OR (W.util_id != 87316 AND W.type_id = 2)) AND (`post_util_id` = 87316 OR `dest_util_id` = 87316) 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=87316 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 = 87340 AND W.type_id = 1) OR (W.util_id != 87340 AND W.type_id = 2)) AND (`post_util_id` = 87340 OR `dest_util_id` = 87340) 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=87340 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 = 88266 AND W.type_id = 1) OR (W.util_id != 88266 AND W.type_id = 2)) AND (`post_util_id` = 88266 OR `dest_util_id` = 88266) 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=88266 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 = 89167 AND W.type_id = 1) OR (W.util_id != 89167 AND W.type_id = 2)) AND (`post_util_id` = 89167 OR `dest_util_id` = 89167) 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=89167 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 = 93114 AND W.type_id = 1) OR (W.util_id != 93114 AND W.type_id = 2)) AND (`post_util_id` = 93114 OR `dest_util_id` = 93114) 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=93114 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 = 95199 AND W.type_id = 1) OR (W.util_id != 95199 AND W.type_id = 2)) AND (`post_util_id` = 95199 OR `dest_util_id` = 95199) 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=95199 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 = 95723 AND W.type_id = 1) OR (W.util_id != 95723 AND W.type_id = 2)) AND (`post_util_id` = 95723 OR `dest_util_id` = 95723) 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=95723 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 = 98297 AND W.type_id = 1) OR (W.util_id != 98297 AND W.type_id = 2)) AND (`post_util_id` = 98297 OR `dest_util_id` = 98297) 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=98297 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 = 103503 AND W.type_id = 1) OR (W.util_id != 103503 AND W.type_id = 2)) AND (`post_util_id` = 103503 OR `dest_util_id` = 103503) 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=103503 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 = 108810 AND W.type_id = 1) OR (W.util_id != 108810 AND W.type_id = 2)) AND (`post_util_id` = 108810 OR `dest_util_id` = 108810) 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=108810 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 = 109579 AND W.type_id = 1) OR (W.util_id != 109579 AND W.type_id = 2)) AND (`post_util_id` = 109579 OR `dest_util_id` = 109579) 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=109579 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 = 111581 AND W.type_id = 1) OR (W.util_id != 111581 AND W.type_id = 2)) AND (`post_util_id` = 111581 OR `dest_util_id` = 111581) 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=111581 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 = 115057 AND W.type_id = 1) OR (W.util_id != 115057 AND W.type_id = 2)) AND (`post_util_id` = 115057 OR `dest_util_id` = 115057) 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=115057 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 = 113179 AND W.type_id = 1) OR (W.util_id != 113179 AND W.type_id = 2)) AND (`post_util_id` = 113179 OR `dest_util_id` = 113179) 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=113179 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 = 117969 AND W.type_id = 1) OR (W.util_id != 117969 AND W.type_id = 2)) AND (`post_util_id` = 117969 OR `dest_util_id` = 117969) 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=117969 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 = 115649 AND W.type_id = 1) OR (W.util_id != 115649 AND W.type_id = 2)) AND (`post_util_id` = 115649 OR `dest_util_id` = 115649) 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=115649 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 = 119230 AND W.type_id = 1) OR (W.util_id != 119230 AND W.type_id = 2)) AND (`post_util_id` = 119230 OR `dest_util_id` = 119230) 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=119230 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 = 120083 AND W.type_id = 1) OR (W.util_id != 120083 AND W.type_id = 2)) AND (`post_util_id` = 120083 OR `dest_util_id` = 120083) 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=120083 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 = 124383 AND W.type_id = 1) OR (W.util_id != 124383 AND W.type_id = 2)) AND (`post_util_id` = 124383 OR `dest_util_id` = 124383) 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=124383 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 = 134822 AND W.type_id = 1) OR (W.util_id != 134822 AND W.type_id = 2)) AND (`post_util_id` = 134822 OR `dest_util_id` = 134822) 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=134822 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 = 135179 AND W.type_id = 1) OR (W.util_id != 135179 AND W.type_id = 2)) AND (`post_util_id` = 135179 OR `dest_util_id` = 135179) 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=135179 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 = 137393 AND W.type_id = 1) OR (W.util_id != 137393 AND W.type_id = 2)) AND (`post_util_id` = 137393 OR `dest_util_id` = 137393) 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=137393 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 = 115057 AND W.type_id = 1) OR (W.util_id != 115057 AND W.type_id = 2)) AND (`post_util_id` = 115057 OR `dest_util_id` = 115057) 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 = 148618 AND W.type_id = 1) OR (W.util_id != 148618 AND W.type_id = 2)) AND (`post_util_id` = 148618 OR `dest_util_id` = 148618) 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=148618 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 = 152597 AND W.type_id = 1) OR (W.util_id != 152597 AND W.type_id = 2)) AND (`post_util_id` = 152597 OR `dest_util_id` = 152597) 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=152597 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 = 153162 AND W.type_id = 1) OR (W.util_id != 153162 AND W.type_id = 2)) AND (`post_util_id` = 153162 OR `dest_util_id` = 153162) 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=153162 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 = 154504 AND W.type_id = 1) OR (W.util_id != 154504 AND W.type_id = 2)) AND (`post_util_id` = 154504 OR `dest_util_id` = 154504) 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=154504 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 = 155893 AND W.type_id = 1) OR (W.util_id != 155893 AND W.type_id = 2)) AND (`post_util_id` = 155893 OR `dest_util_id` = 155893) 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=155893 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 = 151842 AND W.type_id = 1) OR (W.util_id != 151842 AND W.type_id = 2)) AND (`post_util_id` = 151842 OR `dest_util_id` = 151842) 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=151842 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 = 165427 AND W.type_id = 1) OR (W.util_id != 165427 AND W.type_id = 2)) AND (`post_util_id` = 165427 OR `dest_util_id` = 165427) 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=165427 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 = 172883 AND W.type_id = 1) OR (W.util_id != 172883 AND W.type_id = 2)) AND (`post_util_id` = 172883 OR `dest_util_id` = 172883) 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=172883 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 = 176108 AND W.type_id = 1) OR (W.util_id != 176108 AND W.type_id = 2)) AND (`post_util_id` = 176108 OR `dest_util_id` = 176108) 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=176108 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 = 177103 AND W.type_id = 1) OR (W.util_id != 177103 AND W.type_id = 2)) AND (`post_util_id` = 177103 OR `dest_util_id` = 177103) 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=177103 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 = 178173 AND W.type_id = 1) OR (W.util_id != 178173 AND W.type_id = 2)) AND (`post_util_id` = 178173 OR `dest_util_id` = 178173) 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=178173 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 = 19470 AND W.type_id = 1) OR (W.util_id != 19470 AND W.type_id = 2)) AND (`post_util_id` = 19470 OR `dest_util_id` = 19470) 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=19470 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 = 201658 AND W.type_id = 1) OR (W.util_id != 201658 AND W.type_id = 2)) AND (`post_util_id` = 201658 OR `dest_util_id` = 201658) 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=201658 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 = 203580 AND W.type_id = 1) OR (W.util_id != 203580 AND W.type_id = 2)) AND (`post_util_id` = 203580 OR `dest_util_id` = 203580) 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=203580 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 = 203950 AND W.type_id = 1) OR (W.util_id != 203950 AND W.type_id = 2)) AND (`post_util_id` = 203950 OR `dest_util_id` = 203950) 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=203950 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 = 205659 AND W.type_id = 1) OR (W.util_id != 205659 AND W.type_id = 2)) AND (`post_util_id` = 205659 OR `dest_util_id` = 205659) 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=205659 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 = 220352 AND W.type_id = 1) OR (W.util_id != 220352 AND W.type_id = 2)) AND (`post_util_id` = 220352 OR `dest_util_id` = 220352) 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=220352 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 = 72915 AND W.type_id = 1) OR (W.util_id != 72915 AND W.type_id = 2)) AND (`post_util_id` = 72915 OR `dest_util_id` = 72915) 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=72915 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 = 22345 AND W.type_id = 1) OR (W.util_id != 22345 AND W.type_id = 2)) AND (`post_util_id` = 22345 OR `dest_util_id` = 22345) 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=22345 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 = 227491 AND W.type_id = 1) OR (W.util_id != 227491 AND W.type_id = 2)) AND (`post_util_id` = 227491 OR `dest_util_id` = 227491) 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=227491 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 = 236436 AND W.type_id = 1) OR (W.util_id != 236436 AND W.type_id = 2)) AND (`post_util_id` = 236436 OR `dest_util_id` = 236436) 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=236436 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 = 229985 AND W.type_id = 1) OR (W.util_id != 229985 AND W.type_id = 2)) AND (`post_util_id` = 229985 OR `dest_util_id` = 229985) 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=229985 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 = 252483 AND W.type_id = 1) OR (W.util_id != 252483 AND W.type_id = 2)) AND (`post_util_id` = 252483 OR `dest_util_id` = 252483) 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=252483 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 = 57513 AND W.type_id = 1) OR (W.util_id != 57513 AND W.type_id = 2)) AND (`post_util_id` = 57513 OR `dest_util_id` = 57513) 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=57513 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 = 271235 AND W.type_id = 1) OR (W.util_id != 271235 AND W.type_id = 2)) AND (`post_util_id` = 271235 OR `dest_util_id` = 271235) 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=271235 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 = 262214 AND W.type_id = 1) OR (W.util_id != 262214 AND W.type_id = 2)) AND (`post_util_id` = 262214 OR `dest_util_id` = 262214) 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=262214 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 = 145504 AND W.type_id = 1) OR (W.util_id != 145504 AND W.type_id = 2)) AND (`post_util_id` = 145504 OR `dest_util_id` = 145504) 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=145504 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 = 292466 AND W.type_id = 1) OR (W.util_id != 292466 AND W.type_id = 2)) AND (`post_util_id` = 292466 OR `dest_util_id` = 292466) 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=292466 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 = 302685 AND W.type_id = 1) OR (W.util_id != 302685 AND W.type_id = 2)) AND (`post_util_id` = 302685 OR `dest_util_id` = 302685) 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=302685 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 = 160366 AND W.type_id = 1) OR (W.util_id != 160366 AND W.type_id = 2)) AND (`post_util_id` = 160366 OR `dest_util_id` = 160366) 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=160366 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 = 12754 AND W.type_id = 1) OR (W.util_id != 12754 AND W.type_id = 2)) AND (`post_util_id` = 12754 OR `dest_util_id` = 12754) 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=12754 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 = 345176 AND W.type_id = 1) OR (W.util_id != 345176 AND W.type_id = 2)) AND (`post_util_id` = 345176 OR `dest_util_id` = 345176) 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=345176 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 = 348779 AND W.type_id = 1) OR (W.util_id != 348779 AND W.type_id = 2)) AND (`post_util_id` = 348779 OR `dest_util_id` = 348779) 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=348779 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 = 355321 AND W.type_id = 1) OR (W.util_id != 355321 AND W.type_id = 2)) AND (`post_util_id` = 355321 OR `dest_util_id` = 355321) 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=355321 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 = 376487 AND W.type_id = 1) OR (W.util_id != 376487 AND W.type_id = 2)) AND (`post_util_id` = 376487 OR `dest_util_id` = 376487) 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=376487 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 = 381935 AND W.type_id = 1) OR (W.util_id != 381935 AND W.type_id = 2)) AND (`post_util_id` = 381935 OR `dest_util_id` = 381935) 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=381935 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 = 399980 AND W.type_id = 1) OR (W.util_id != 399980 AND W.type_id = 2)) AND (`post_util_id` = 399980 OR `dest_util_id` = 399980) 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=399980 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 = 83490 AND W.type_id = 1) OR (W.util_id != 83490 AND W.type_id = 2)) AND (`post_util_id` = 83490 OR `dest_util_id` = 83490) 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=83490 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 = 166971 AND W.type_id = 1) OR (W.util_id != 166971 AND W.type_id = 2)) AND (`post_util_id` = 166971 OR `dest_util_id` = 166971) 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=166971 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 = 431425 AND W.type_id = 1) OR (W.util_id != 431425 AND W.type_id = 2)) AND (`post_util_id` = 431425 OR `dest_util_id` = 431425) 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=431425 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 = 431425 AND W.type_id = 1) OR (W.util_id != 431425 AND W.type_id = 2)) AND (`post_util_id` = 431425 OR `dest_util_id` = 431425) 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 = 445368 AND W.type_id = 1) OR (W.util_id != 445368 AND W.type_id = 2)) AND (`post_util_id` = 445368 OR `dest_util_id` = 445368) 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=445368 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 = 465239 AND W.type_id = 1) OR (W.util_id != 465239 AND W.type_id = 2)) AND (`post_util_id` = 465239 OR `dest_util_id` = 465239) 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=465239 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 = 468881 AND W.type_id = 1) OR (W.util_id != 468881 AND W.type_id = 2)) AND (`post_util_id` = 468881 OR `dest_util_id` = 468881) 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=468881 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 = 356620 AND W.type_id = 1) OR (W.util_id != 356620 AND W.type_id = 2)) AND (`post_util_id` = 356620 OR `dest_util_id` = 356620) 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=356620 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 = 356620 AND W.type_id = 1) OR (W.util_id != 356620 AND W.type_id = 2)) AND (`post_util_id` = 356620 OR `dest_util_id` = 356620) 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 = 471579 AND W.type_id = 1) OR (W.util_id != 471579 AND W.type_id = 2)) AND (`post_util_id` = 471579 OR `dest_util_id` = 471579) 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=471579 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 = 480275 AND W.type_id = 1) OR (W.util_id != 480275 AND W.type_id = 2)) AND (`post_util_id` = 480275 OR `dest_util_id` = 480275) 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=480275 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 = 482243 AND W.type_id = 1) OR (W.util_id != 482243 AND W.type_id = 2)) AND (`post_util_id` = 482243 OR `dest_util_id` = 482243) 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=482243 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=39 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='nounou' OR ssrubr_slug like '%nounou%' OR MATCH (ssrubr_slug) AGAINST ('(+nounou)')) AND sk.ssrubr_id='942' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
SELECT * FROM actu WHERE ssrubr_id='942' 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