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='menage-repassage'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=47
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='33'
SELECT ville_nom FROM villes WHERE ville_cp='33310' AND ville_nom like '%lormont%' 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 '%repassage%' OR ssrubr_title like '%repassage%' OR ssrubr_slug like '%repassage%') AND cate_id='47' ORDER BY ssrubr_id LIMIT 0,1
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='33310'
SELECT ville_cp, ROUND((((acos(sin((44.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.533333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.686835678816 AND ville_latitude_deg<45.046564321184 AND ville_longitude_deg>-0.78711024870411 AND ville_longitude_deg<-0.27955575129589 HAVING distance <= 20 ORDER BY distance ASC
SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='repassage'
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='47'AND MATCH (wish_title,wish_desc) AGAINST ('+repassage*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '33310%'
SELECT * FROM texte WHERE cate_id=47
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='repassage' OR ssrubr_slug='repassage' OR (ssrubr_title like '%repassage%')) AND cate_id='47' 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 (47) ORDER BY ssrubr_order ASC
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='repassage' AND cate_id='47'
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='33310'
SELECT ville_cp, ROUND((((acos(sin((44.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.533333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.686835678816 AND ville_latitude_deg<45.046564321184 AND ville_longitude_deg>-0.78711024870411 AND ville_longitude_deg<-0.27955575129589 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((44.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.533333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.417039197041 AND ville_latitude_deg<45.316360802959 AND ville_longitude_deg>-1.1677815926603 AND ville_longitude_deg<0.10111559266029 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='47' AND MATCH (wish_desc) AGAINST ('(+repassage*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (33310,33310,33150,33370,33560,33270,33530,33100,33072,33800,33200,33000,33300,33370,33370,33270,33114,33110,33560,33520,33360,33130,33440,33400,33370,33370,33700,33440,33450,33320,33450,33290,33600,33290,33360,33750,33370,33320,33370,33140,33360,33360,33440,33185,33450,33360,33370,33240,33170,33140,33240,33670,33360,33290,33750,33290,33450,33670,33880,33610,33670,33240,33240,33850,33160,33880,33810,33750,33650,33640,33750,33670,33240,33870,33240,33670,33240,33460,33880,33750,33240,33240,33240,33460,33650,33126,33126,33670,33710,33127,33640,33460,33550,33610,33240,33550,33240,33710,33160,33240,33240,33640,33240,33550,33500,33750)
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((44.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.533333- 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='47' AND MATCH (wish_desc) AGAINST ('(+repassage*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (33310,33310,33150,33370,33560,33270,33530,33100,33072,33800,33200,33000,33300,33370,33370,33270,33114,33110,33560,33520,33360,33130,33440,33400,33370,33370,33700,33440,33450,33320,33450,33290,33600,33290,33360,33750,33370,33320,33370,33140,33360,33360,33440,33185,33450,33360,33370,33240,33170,33140,33240,33670,33360,33290,33750,33290,33450,33670,33880,33610,33670,33240,33240,33850,33160,33880,33810,33750,33650,33640,33750,33670,33240,33870,33240,33670,33240,33460,33880,33750,33240,33240,33240,33460,33650,33126,33126,33670,33710,33127,33640,33460,33550,33610,33240,33550,33240,33710,33160,33240,33240,33640,33240,33550,33500,33750) AND type_id=1 GROUP BY wish_id
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='33310'
SELECT ville_cp, ROUND((((acos(sin((44.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.533333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.686835678816 AND ville_latitude_deg<45.046564321184 AND ville_longitude_deg>-0.78711024870411 AND ville_longitude_deg<-0.27955575129589 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((44.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.533333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.417039197041 AND ville_latitude_deg<45.316360802959 AND ville_longitude_deg>-1.1677815926603 AND ville_longitude_deg<0.10111559266029 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 = 27250 AND W.type_id = 1) OR (W.util_id != 27250 AND W.type_id = 2)) AND (`post_util_id` = 27250 OR `dest_util_id` = 27250) 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=27250 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 = 35002 AND W.type_id = 1) OR (W.util_id != 35002 AND W.type_id = 2)) AND (`post_util_id` = 35002 OR `dest_util_id` = 35002) 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=35002 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 = 35984 AND W.type_id = 1) OR (W.util_id != 35984 AND W.type_id = 2)) AND (`post_util_id` = 35984 OR `dest_util_id` = 35984) 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=35984 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 = 39423 AND W.type_id = 1) OR (W.util_id != 39423 AND W.type_id = 2)) AND (`post_util_id` = 39423 OR `dest_util_id` = 39423) 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=39423 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 = 44166 AND W.type_id = 1) OR (W.util_id != 44166 AND W.type_id = 2)) AND (`post_util_id` = 44166 OR `dest_util_id` = 44166) 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=44166 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 = 20523 AND W.type_id = 1) OR (W.util_id != 20523 AND W.type_id = 2)) AND (`post_util_id` = 20523 OR `dest_util_id` = 20523) 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=20523 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 = 46227 AND W.type_id = 1) OR (W.util_id != 46227 AND W.type_id = 2)) AND (`post_util_id` = 46227 OR `dest_util_id` = 46227) 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=46227 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 = 49870 AND W.type_id = 1) OR (W.util_id != 49870 AND W.type_id = 2)) AND (`post_util_id` = 49870 OR `dest_util_id` = 49870) 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=49870 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 = 56792 AND W.type_id = 1) OR (W.util_id != 56792 AND W.type_id = 2)) AND (`post_util_id` = 56792 OR `dest_util_id` = 56792) 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=56792 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 = 57117 AND W.type_id = 1) OR (W.util_id != 57117 AND W.type_id = 2)) AND (`post_util_id` = 57117 OR `dest_util_id` = 57117) 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=57117 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 = 57201 AND W.type_id = 1) OR (W.util_id != 57201 AND W.type_id = 2)) AND (`post_util_id` = 57201 OR `dest_util_id` = 57201) 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=57201 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 = 61837 AND W.type_id = 1) OR (W.util_id != 61837 AND W.type_id = 2)) AND (`post_util_id` = 61837 OR `dest_util_id` = 61837) 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=61837 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 = 61837 AND W.type_id = 1) OR (W.util_id != 61837 AND W.type_id = 2)) AND (`post_util_id` = 61837 OR `dest_util_id` = 61837) 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 = 61837 AND W.type_id = 1) OR (W.util_id != 61837 AND W.type_id = 2)) AND (`post_util_id` = 61837 OR `dest_util_id` = 61837) 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 = 60037 AND W.type_id = 1) OR (W.util_id != 60037 AND W.type_id = 2)) AND (`post_util_id` = 60037 OR `dest_util_id` = 60037) 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=60037 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 = 79219 AND W.type_id = 1) OR (W.util_id != 79219 AND W.type_id = 2)) AND (`post_util_id` = 79219 OR `dest_util_id` = 79219) 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=79219 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 = 97085 AND W.type_id = 1) OR (W.util_id != 97085 AND W.type_id = 2)) AND (`post_util_id` = 97085 OR `dest_util_id` = 97085) 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=97085 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 = 103148 AND W.type_id = 1) OR (W.util_id != 103148 AND W.type_id = 2)) AND (`post_util_id` = 103148 OR `dest_util_id` = 103148) 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=103148 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 = 109255 AND W.type_id = 1) OR (W.util_id != 109255 AND W.type_id = 2)) AND (`post_util_id` = 109255 OR `dest_util_id` = 109255) 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=109255 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 = 110218 AND W.type_id = 1) OR (W.util_id != 110218 AND W.type_id = 2)) AND (`post_util_id` = 110218 OR `dest_util_id` = 110218) 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=110218 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 = 111129 AND W.type_id = 1) OR (W.util_id != 111129 AND W.type_id = 2)) AND (`post_util_id` = 111129 OR `dest_util_id` = 111129) 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=111129 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 = 113208 AND W.type_id = 1) OR (W.util_id != 113208 AND W.type_id = 2)) AND (`post_util_id` = 113208 OR `dest_util_id` = 113208) 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=113208 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 = 117330 AND W.type_id = 1) OR (W.util_id != 117330 AND W.type_id = 2)) AND (`post_util_id` = 117330 OR `dest_util_id` = 117330) 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=117330 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 = 123483 AND W.type_id = 1) OR (W.util_id != 123483 AND W.type_id = 2)) AND (`post_util_id` = 123483 OR `dest_util_id` = 123483) 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=123483 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 = 123483 AND W.type_id = 1) OR (W.util_id != 123483 AND W.type_id = 2)) AND (`post_util_id` = 123483 OR `dest_util_id` = 123483) 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 = 127199 AND W.type_id = 1) OR (W.util_id != 127199 AND W.type_id = 2)) AND (`post_util_id` = 127199 OR `dest_util_id` = 127199) 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=127199 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 = 134748 AND W.type_id = 1) OR (W.util_id != 134748 AND W.type_id = 2)) AND (`post_util_id` = 134748 OR `dest_util_id` = 134748) 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=134748 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 = 136200 AND W.type_id = 1) OR (W.util_id != 136200 AND W.type_id = 2)) AND (`post_util_id` = 136200 OR `dest_util_id` = 136200) 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=136200 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 = 136944 AND W.type_id = 1) OR (W.util_id != 136944 AND W.type_id = 2)) AND (`post_util_id` = 136944 OR `dest_util_id` = 136944) 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=136944 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 = 164955 AND W.type_id = 1) OR (W.util_id != 164955 AND W.type_id = 2)) AND (`post_util_id` = 164955 OR `dest_util_id` = 164955) 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=164955 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 = 94282 AND W.type_id = 1) OR (W.util_id != 94282 AND W.type_id = 2)) AND (`post_util_id` = 94282 OR `dest_util_id` = 94282) 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=94282 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 = 176027 AND W.type_id = 1) OR (W.util_id != 176027 AND W.type_id = 2)) AND (`post_util_id` = 176027 OR `dest_util_id` = 176027) 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=176027 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 = 190680 AND W.type_id = 1) OR (W.util_id != 190680 AND W.type_id = 2)) AND (`post_util_id` = 190680 OR `dest_util_id` = 190680) 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=190680 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 = 68812 AND W.type_id = 1) OR (W.util_id != 68812 AND W.type_id = 2)) AND (`post_util_id` = 68812 OR `dest_util_id` = 68812) 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=68812 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 = 102809 AND W.type_id = 1) OR (W.util_id != 102809 AND W.type_id = 2)) AND (`post_util_id` = 102809 OR `dest_util_id` = 102809) 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=102809 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 = 116603 AND W.type_id = 1) OR (W.util_id != 116603 AND W.type_id = 2)) AND (`post_util_id` = 116603 OR `dest_util_id` = 116603) 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=116603 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 = 208393 AND W.type_id = 1) OR (W.util_id != 208393 AND W.type_id = 2)) AND (`post_util_id` = 208393 OR `dest_util_id` = 208393) 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=208393 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 = 212625 AND W.type_id = 1) OR (W.util_id != 212625 AND W.type_id = 2)) AND (`post_util_id` = 212625 OR `dest_util_id` = 212625) 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=212625 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 = 213054 AND W.type_id = 1) OR (W.util_id != 213054 AND W.type_id = 2)) AND (`post_util_id` = 213054 OR `dest_util_id` = 213054) 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=213054 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 = 223553 AND W.type_id = 1) OR (W.util_id != 223553 AND W.type_id = 2)) AND (`post_util_id` = 223553 OR `dest_util_id` = 223553) 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=223553 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 = 228625 AND W.type_id = 1) OR (W.util_id != 228625 AND W.type_id = 2)) AND (`post_util_id` = 228625 OR `dest_util_id` = 228625) 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=228625 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 = 216165 AND W.type_id = 1) OR (W.util_id != 216165 AND W.type_id = 2)) AND (`post_util_id` = 216165 OR `dest_util_id` = 216165) 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=216165 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 = 176495 AND W.type_id = 1) OR (W.util_id != 176495 AND W.type_id = 2)) AND (`post_util_id` = 176495 OR `dest_util_id` = 176495) 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=176495 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 = 237918 AND W.type_id = 1) OR (W.util_id != 237918 AND W.type_id = 2)) AND (`post_util_id` = 237918 OR `dest_util_id` = 237918) 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=237918 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 = 239133 AND W.type_id = 1) OR (W.util_id != 239133 AND W.type_id = 2)) AND (`post_util_id` = 239133 OR `dest_util_id` = 239133) 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=239133 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 = 239133 AND W.type_id = 1) OR (W.util_id != 239133 AND W.type_id = 2)) AND (`post_util_id` = 239133 OR `dest_util_id` = 239133) 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 = 254207 AND W.type_id = 1) OR (W.util_id != 254207 AND W.type_id = 2)) AND (`post_util_id` = 254207 OR `dest_util_id` = 254207) 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=254207 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 = 206803 AND W.type_id = 1) OR (W.util_id != 206803 AND W.type_id = 2)) AND (`post_util_id` = 206803 OR `dest_util_id` = 206803) 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=206803 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 = 283921 AND W.type_id = 1) OR (W.util_id != 283921 AND W.type_id = 2)) AND (`post_util_id` = 283921 OR `dest_util_id` = 283921) 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=283921 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 = 316867 AND W.type_id = 1) OR (W.util_id != 316867 AND W.type_id = 2)) AND (`post_util_id` = 316867 OR `dest_util_id` = 316867) 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=316867 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 = 323293 AND W.type_id = 1) OR (W.util_id != 323293 AND W.type_id = 2)) AND (`post_util_id` = 323293 OR `dest_util_id` = 323293) 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=323293 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 = 324441 AND W.type_id = 1) OR (W.util_id != 324441 AND W.type_id = 2)) AND (`post_util_id` = 324441 OR `dest_util_id` = 324441) 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=324441 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 = 339405 AND W.type_id = 1) OR (W.util_id != 339405 AND W.type_id = 2)) AND (`post_util_id` = 339405 OR `dest_util_id` = 339405) 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=339405 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 = 372334 AND W.type_id = 1) OR (W.util_id != 372334 AND W.type_id = 2)) AND (`post_util_id` = 372334 OR `dest_util_id` = 372334) 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=372334 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 = 372623 AND W.type_id = 1) OR (W.util_id != 372623 AND W.type_id = 2)) AND (`post_util_id` = 372623 OR `dest_util_id` = 372623) 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=372623 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 = 376525 AND W.type_id = 1) OR (W.util_id != 376525 AND W.type_id = 2)) AND (`post_util_id` = 376525 OR `dest_util_id` = 376525) 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=376525 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 = 378733 AND W.type_id = 1) OR (W.util_id != 378733 AND W.type_id = 2)) AND (`post_util_id` = 378733 OR `dest_util_id` = 378733) 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=378733 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 = 389641 AND W.type_id = 1) OR (W.util_id != 389641 AND W.type_id = 2)) AND (`post_util_id` = 389641 OR `dest_util_id` = 389641) 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=389641 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 = 208409 AND W.type_id = 1) OR (W.util_id != 208409 AND W.type_id = 2)) AND (`post_util_id` = 208409 OR `dest_util_id` = 208409) 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=208409 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 = 378679 AND W.type_id = 1) OR (W.util_id != 378679 AND W.type_id = 2)) AND (`post_util_id` = 378679 OR `dest_util_id` = 378679) 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=378679 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 = 415344 AND W.type_id = 1) OR (W.util_id != 415344 AND W.type_id = 2)) AND (`post_util_id` = 415344 OR `dest_util_id` = 415344) 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=415344 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 = 426137 AND W.type_id = 1) OR (W.util_id != 426137 AND W.type_id = 2)) AND (`post_util_id` = 426137 OR `dest_util_id` = 426137) 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=426137 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 = 429024 AND W.type_id = 1) OR (W.util_id != 429024 AND W.type_id = 2)) AND (`post_util_id` = 429024 OR `dest_util_id` = 429024) 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=429024 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 = 437326 AND W.type_id = 1) OR (W.util_id != 437326 AND W.type_id = 2)) AND (`post_util_id` = 437326 OR `dest_util_id` = 437326) 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=437326 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 = 437326 AND W.type_id = 1) OR (W.util_id != 437326 AND W.type_id = 2)) AND (`post_util_id` = 437326 OR `dest_util_id` = 437326) 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 = 446848 AND W.type_id = 1) OR (W.util_id != 446848 AND W.type_id = 2)) AND (`post_util_id` = 446848 OR `dest_util_id` = 446848) 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=446848 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 = 459770 AND W.type_id = 1) OR (W.util_id != 459770 AND W.type_id = 2)) AND (`post_util_id` = 459770 OR `dest_util_id` = 459770) 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=459770 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 = 472545 AND W.type_id = 1) OR (W.util_id != 472545 AND W.type_id = 2)) AND (`post_util_id` = 472545 OR `dest_util_id` = 472545) 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=472545 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 = 478428 AND W.type_id = 1) OR (W.util_id != 478428 AND W.type_id = 2)) AND (`post_util_id` = 478428 OR `dest_util_id` = 478428) 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=478428 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 = 402003 AND W.type_id = 1) OR (W.util_id != 402003 AND W.type_id = 2)) AND (`post_util_id` = 402003 OR `dest_util_id` = 402003) 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=402003 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 = 59321 AND W.type_id = 1) OR (W.util_id != 59321 AND W.type_id = 2)) AND (`post_util_id` = 59321 OR `dest_util_id` = 59321) 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=59321 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 = 549279 AND W.type_id = 1) OR (W.util_id != 549279 AND W.type_id = 2)) AND (`post_util_id` = 549279 OR `dest_util_id` = 549279) 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=549279 AND note_visu IN (1,3,4)
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='937' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 113208 AND W.type_id = 1) OR (W.util_id != 113208 AND W.type_id = 2)) AND (`post_util_id` = 113208 OR `dest_util_id` = 113208) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 113208
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1080' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 20523 AND W.type_id = 1) OR (W.util_id != 20523 AND W.type_id = 2)) AND (`post_util_id` = 20523 OR `dest_util_id` = 20523) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 20523
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1080' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 116603 AND W.type_id = 1) OR (W.util_id != 116603 AND W.type_id = 2)) AND (`post_util_id` = 116603 OR `dest_util_id` = 116603) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 116603
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='938' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 27250 AND W.type_id = 1) OR (W.util_id != 27250 AND W.type_id = 2)) AND (`post_util_id` = 27250 OR `dest_util_id` = 27250) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 27250
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1080' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 136200 AND W.type_id = 1) OR (W.util_id != 136200 AND W.type_id = 2)) AND (`post_util_id` = 136200 OR `dest_util_id` = 136200) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 136200
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='937' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 60037 AND W.type_id = 1) OR (W.util_id != 60037 AND W.type_id = 2)) AND (`post_util_id` = 60037 OR `dest_util_id` = 60037) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 60037
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='938' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 472545 AND W.type_id = 1) OR (W.util_id != 472545 AND W.type_id = 2)) AND (`post_util_id` = 472545 OR `dest_util_id` = 472545) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 472545
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='938' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 254207 AND W.type_id = 1) OR (W.util_id != 254207 AND W.type_id = 2)) AND (`post_util_id` = 254207 OR `dest_util_id` = 254207) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 254207
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='937' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 176495 AND W.type_id = 1) OR (W.util_id != 176495 AND W.type_id = 2)) AND (`post_util_id` = 176495 OR `dest_util_id` = 176495) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 176495
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='938' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 46227 AND W.type_id = 1) OR (W.util_id != 46227 AND W.type_id = 2)) AND (`post_util_id` = 46227 OR `dest_util_id` = 46227) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 46227
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1080' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 57201 AND W.type_id = 1) OR (W.util_id != 57201 AND W.type_id = 2)) AND (`post_util_id` = 57201 OR `dest_util_id` = 57201) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 57201
SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1080' LIMIT 0,1
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 102809 AND W.type_id = 1) OR (W.util_id != 102809 AND W.type_id = 2)) AND (`post_util_id` = 102809 OR `dest_util_id` = 102809) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 102809
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=47 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='repassage' OR ssrubr_slug like '%repassage%' OR MATCH (ssrubr_slug) AGAINST ('(+repassage)')) AND sk.ssrubr_id='938' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
SELECT * FROM actu WHERE ssrubr_id='938' 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