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='5' AND cate_title_slug='materiel-jardinage'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=88
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%pelle%' OR ssrubr_title like '%pelle%' OR ssrubr_slug like '%pelle%') AND cate_id='88' ORDER BY ssrubr_id LIMIT 0,1
SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='pelle'
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='88'AND MATCH (wish_title,wish_desc) AGAINST ('+pelle*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10)
SELECT * FROM texte WHERE cate_id=88
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='pelle' OR ssrubr_slug='pelle' OR (ssrubr_title like '%pelle%')) AND cate_id='88' 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='5' 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 (88) ORDER BY ssrubr_order ASC
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='pelle' AND cate_id='88'
SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='88' AND MATCH (wish_desc) AGAINST ('(+pelle*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10)
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='88' AND MATCH (wish_desc) AGAINST ('(+pelle*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND type_id=1 GROUP BY wish_id
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 5319 AND W.type_id = 1) OR (W.util_id != 5319 AND W.type_id = 2)) AND (`post_util_id` = 5319 OR `dest_util_id` = 5319) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=5319 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 10300 AND W.type_id = 1) OR (W.util_id != 10300 AND W.type_id = 2)) AND (`post_util_id` = 10300 OR `dest_util_id` = 10300) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=10300 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 20702 AND W.type_id = 1) OR (W.util_id != 20702 AND W.type_id = 2)) AND (`post_util_id` = 20702 OR `dest_util_id` = 20702) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=20702 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 22481 AND W.type_id = 1) OR (W.util_id != 22481 AND W.type_id = 2)) AND (`post_util_id` = 22481 OR `dest_util_id` = 22481) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=22481 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 26261 AND W.type_id = 1) OR (W.util_id != 26261 AND W.type_id = 2)) AND (`post_util_id` = 26261 OR `dest_util_id` = 26261) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=26261 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 37912 AND W.type_id = 1) OR (W.util_id != 37912 AND W.type_id = 2)) AND (`post_util_id` = 37912 OR `dest_util_id` = 37912) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=37912 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 50673 AND W.type_id = 1) OR (W.util_id != 50673 AND W.type_id = 2)) AND (`post_util_id` = 50673 OR `dest_util_id` = 50673) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=50673 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 74654 AND W.type_id = 1) OR (W.util_id != 74654 AND W.type_id = 2)) AND (`post_util_id` = 74654 OR `dest_util_id` = 74654) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=74654 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 74981 AND W.type_id = 1) OR (W.util_id != 74981 AND W.type_id = 2)) AND (`post_util_id` = 74981 OR `dest_util_id` = 74981) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=74981 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 69197 AND W.type_id = 1) OR (W.util_id != 69197 AND W.type_id = 2)) AND (`post_util_id` = 69197 OR `dest_util_id` = 69197) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=69197 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 76514 AND W.type_id = 1) OR (W.util_id != 76514 AND W.type_id = 2)) AND (`post_util_id` = 76514 OR `dest_util_id` = 76514) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=76514 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 77878 AND W.type_id = 1) OR (W.util_id != 77878 AND W.type_id = 2)) AND (`post_util_id` = 77878 OR `dest_util_id` = 77878) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=77878 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 102211 AND W.type_id = 1) OR (W.util_id != 102211 AND W.type_id = 2)) AND (`post_util_id` = 102211 OR `dest_util_id` = 102211) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=102211 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 116144 AND W.type_id = 1) OR (W.util_id != 116144 AND W.type_id = 2)) AND (`post_util_id` = 116144 OR `dest_util_id` = 116144) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=116144 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 123117 AND W.type_id = 1) OR (W.util_id != 123117 AND W.type_id = 2)) AND (`post_util_id` = 123117 OR `dest_util_id` = 123117) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=123117 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 128727 AND W.type_id = 1) OR (W.util_id != 128727 AND W.type_id = 2)) AND (`post_util_id` = 128727 OR `dest_util_id` = 128727) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=128727 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 153130 AND W.type_id = 1) OR (W.util_id != 153130 AND W.type_id = 2)) AND (`post_util_id` = 153130 OR `dest_util_id` = 153130) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=153130 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 146527 AND W.type_id = 1) OR (W.util_id != 146527 AND W.type_id = 2)) AND (`post_util_id` = 146527 OR `dest_util_id` = 146527) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=146527 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 82367 AND W.type_id = 1) OR (W.util_id != 82367 AND W.type_id = 2)) AND (`post_util_id` = 82367 OR `dest_util_id` = 82367) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=82367 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 154882 AND W.type_id = 1) OR (W.util_id != 154882 AND W.type_id = 2)) AND (`post_util_id` = 154882 OR `dest_util_id` = 154882) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=154882 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 155133 AND W.type_id = 1) OR (W.util_id != 155133 AND W.type_id = 2)) AND (`post_util_id` = 155133 OR `dest_util_id` = 155133) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=155133 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 158738 AND W.type_id = 1) OR (W.util_id != 158738 AND W.type_id = 2)) AND (`post_util_id` = 158738 OR `dest_util_id` = 158738) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=158738 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 161700 AND W.type_id = 1) OR (W.util_id != 161700 AND W.type_id = 2)) AND (`post_util_id` = 161700 OR `dest_util_id` = 161700) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=161700 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 164021 AND W.type_id = 1) OR (W.util_id != 164021 AND W.type_id = 2)) AND (`post_util_id` = 164021 OR `dest_util_id` = 164021) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=164021 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 106285 AND W.type_id = 1) OR (W.util_id != 106285 AND W.type_id = 2)) AND (`post_util_id` = 106285 OR `dest_util_id` = 106285) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=106285 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 175484 AND W.type_id = 1) OR (W.util_id != 175484 AND W.type_id = 2)) AND (`post_util_id` = 175484 OR `dest_util_id` = 175484) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=175484 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 184864 AND W.type_id = 1) OR (W.util_id != 184864 AND W.type_id = 2)) AND (`post_util_id` = 184864 OR `dest_util_id` = 184864) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=184864 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 188197 AND W.type_id = 1) OR (W.util_id != 188197 AND W.type_id = 2)) AND (`post_util_id` = 188197 OR `dest_util_id` = 188197) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=188197 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 188197 AND W.type_id = 1) OR (W.util_id != 188197 AND W.type_id = 2)) AND (`post_util_id` = 188197 OR `dest_util_id` = 188197) 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 = 196858 AND W.type_id = 1) OR (W.util_id != 196858 AND W.type_id = 2)) AND (`post_util_id` = 196858 OR `dest_util_id` = 196858) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=196858 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 122380 AND W.type_id = 1) OR (W.util_id != 122380 AND W.type_id = 2)) AND (`post_util_id` = 122380 OR `dest_util_id` = 122380) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=122380 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 209233 AND W.type_id = 1) OR (W.util_id != 209233 AND W.type_id = 2)) AND (`post_util_id` = 209233 OR `dest_util_id` = 209233) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=209233 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 209944 AND W.type_id = 1) OR (W.util_id != 209944 AND W.type_id = 2)) AND (`post_util_id` = 209944 OR `dest_util_id` = 209944) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=209944 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 78549 AND W.type_id = 1) OR (W.util_id != 78549 AND W.type_id = 2)) AND (`post_util_id` = 78549 OR `dest_util_id` = 78549) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=78549 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 216666 AND W.type_id = 1) OR (W.util_id != 216666 AND W.type_id = 2)) AND (`post_util_id` = 216666 OR `dest_util_id` = 216666) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=216666 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 219401 AND W.type_id = 1) OR (W.util_id != 219401 AND W.type_id = 2)) AND (`post_util_id` = 219401 OR `dest_util_id` = 219401) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=219401 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 226644 AND W.type_id = 1) OR (W.util_id != 226644 AND W.type_id = 2)) AND (`post_util_id` = 226644 OR `dest_util_id` = 226644) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=226644 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 229328 AND W.type_id = 1) OR (W.util_id != 229328 AND W.type_id = 2)) AND (`post_util_id` = 229328 OR `dest_util_id` = 229328) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=229328 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 229338 AND W.type_id = 1) OR (W.util_id != 229338 AND W.type_id = 2)) AND (`post_util_id` = 229338 OR `dest_util_id` = 229338) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=229338 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 182395 AND W.type_id = 1) OR (W.util_id != 182395 AND W.type_id = 2)) AND (`post_util_id` = 182395 OR `dest_util_id` = 182395) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=182395 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 232213 AND W.type_id = 1) OR (W.util_id != 232213 AND W.type_id = 2)) AND (`post_util_id` = 232213 OR `dest_util_id` = 232213) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=232213 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 240027 AND W.type_id = 1) OR (W.util_id != 240027 AND W.type_id = 2)) AND (`post_util_id` = 240027 OR `dest_util_id` = 240027) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=240027 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 254321 AND W.type_id = 1) OR (W.util_id != 254321 AND W.type_id = 2)) AND (`post_util_id` = 254321 OR `dest_util_id` = 254321) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=254321 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 255086 AND W.type_id = 1) OR (W.util_id != 255086 AND W.type_id = 2)) AND (`post_util_id` = 255086 OR `dest_util_id` = 255086) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=255086 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 255737 AND W.type_id = 1) OR (W.util_id != 255737 AND W.type_id = 2)) AND (`post_util_id` = 255737 OR `dest_util_id` = 255737) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=255737 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 257014 AND W.type_id = 1) OR (W.util_id != 257014 AND W.type_id = 2)) AND (`post_util_id` = 257014 OR `dest_util_id` = 257014) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=257014 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 160375 AND W.type_id = 1) OR (W.util_id != 160375 AND W.type_id = 2)) AND (`post_util_id` = 160375 OR `dest_util_id` = 160375) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=160375 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 267501 AND W.type_id = 1) OR (W.util_id != 267501 AND W.type_id = 2)) AND (`post_util_id` = 267501 OR `dest_util_id` = 267501) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=267501 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 277759 AND W.type_id = 1) OR (W.util_id != 277759 AND W.type_id = 2)) AND (`post_util_id` = 277759 OR `dest_util_id` = 277759) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=277759 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 229584 AND W.type_id = 1) OR (W.util_id != 229584 AND W.type_id = 2)) AND (`post_util_id` = 229584 OR `dest_util_id` = 229584) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=229584 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 289335 AND W.type_id = 1) OR (W.util_id != 289335 AND W.type_id = 2)) AND (`post_util_id` = 289335 OR `dest_util_id` = 289335) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=289335 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 293829 AND W.type_id = 1) OR (W.util_id != 293829 AND W.type_id = 2)) AND (`post_util_id` = 293829 OR `dest_util_id` = 293829) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=293829 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 293829 AND W.type_id = 1) OR (W.util_id != 293829 AND W.type_id = 2)) AND (`post_util_id` = 293829 OR `dest_util_id` = 293829) 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 = 293829 AND W.type_id = 1) OR (W.util_id != 293829 AND W.type_id = 2)) AND (`post_util_id` = 293829 OR `dest_util_id` = 293829) 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 = 298488 AND W.type_id = 1) OR (W.util_id != 298488 AND W.type_id = 2)) AND (`post_util_id` = 298488 OR `dest_util_id` = 298488) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=298488 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 302262 AND W.type_id = 1) OR (W.util_id != 302262 AND W.type_id = 2)) AND (`post_util_id` = 302262 OR `dest_util_id` = 302262) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=302262 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 137881 AND W.type_id = 1) OR (W.util_id != 137881 AND W.type_id = 2)) AND (`post_util_id` = 137881 OR `dest_util_id` = 137881) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=137881 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 228246 AND W.type_id = 1) OR (W.util_id != 228246 AND W.type_id = 2)) AND (`post_util_id` = 228246 OR `dest_util_id` = 228246) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=228246 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 312895 AND W.type_id = 1) OR (W.util_id != 312895 AND W.type_id = 2)) AND (`post_util_id` = 312895 OR `dest_util_id` = 312895) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=312895 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 335686 AND W.type_id = 1) OR (W.util_id != 335686 AND W.type_id = 2)) AND (`post_util_id` = 335686 OR `dest_util_id` = 335686) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=335686 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 335686 AND W.type_id = 1) OR (W.util_id != 335686 AND W.type_id = 2)) AND (`post_util_id` = 335686 OR `dest_util_id` = 335686) 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 = 22100 AND W.type_id = 1) OR (W.util_id != 22100 AND W.type_id = 2)) AND (`post_util_id` = 22100 OR `dest_util_id` = 22100) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=22100 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 350227 AND W.type_id = 1) OR (W.util_id != 350227 AND W.type_id = 2)) AND (`post_util_id` = 350227 OR `dest_util_id` = 350227) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=350227 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 352268 AND W.type_id = 1) OR (W.util_id != 352268 AND W.type_id = 2)) AND (`post_util_id` = 352268 OR `dest_util_id` = 352268) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=352268 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 352268 AND W.type_id = 1) OR (W.util_id != 352268 AND W.type_id = 2)) AND (`post_util_id` = 352268 OR `dest_util_id` = 352268) 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 = 352268 AND W.type_id = 1) OR (W.util_id != 352268 AND W.type_id = 2)) AND (`post_util_id` = 352268 OR `dest_util_id` = 352268) 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 = 354707 AND W.type_id = 1) OR (W.util_id != 354707 AND W.type_id = 2)) AND (`post_util_id` = 354707 OR `dest_util_id` = 354707) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=354707 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 356403 AND W.type_id = 1) OR (W.util_id != 356403 AND W.type_id = 2)) AND (`post_util_id` = 356403 OR `dest_util_id` = 356403) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=356403 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 365582 AND W.type_id = 1) OR (W.util_id != 365582 AND W.type_id = 2)) AND (`post_util_id` = 365582 OR `dest_util_id` = 365582) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=365582 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 365582 AND W.type_id = 1) OR (W.util_id != 365582 AND W.type_id = 2)) AND (`post_util_id` = 365582 OR `dest_util_id` = 365582) 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 = 366057 AND W.type_id = 1) OR (W.util_id != 366057 AND W.type_id = 2)) AND (`post_util_id` = 366057 OR `dest_util_id` = 366057) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=366057 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 368498 AND W.type_id = 1) OR (W.util_id != 368498 AND W.type_id = 2)) AND (`post_util_id` = 368498 OR `dest_util_id` = 368498) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=368498 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 368498 AND W.type_id = 1) OR (W.util_id != 368498 AND W.type_id = 2)) AND (`post_util_id` = 368498 OR `dest_util_id` = 368498) 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 = 368498 AND W.type_id = 1) OR (W.util_id != 368498 AND W.type_id = 2)) AND (`post_util_id` = 368498 OR `dest_util_id` = 368498) 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 = 221635 AND W.type_id = 1) OR (W.util_id != 221635 AND W.type_id = 2)) AND (`post_util_id` = 221635 OR `dest_util_id` = 221635) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=221635 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 374277 AND W.type_id = 1) OR (W.util_id != 374277 AND W.type_id = 2)) AND (`post_util_id` = 374277 OR `dest_util_id` = 374277) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=374277 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 268608 AND W.type_id = 1) OR (W.util_id != 268608 AND W.type_id = 2)) AND (`post_util_id` = 268608 OR `dest_util_id` = 268608) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=268608 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 385922 AND W.type_id = 1) OR (W.util_id != 385922 AND W.type_id = 2)) AND (`post_util_id` = 385922 OR `dest_util_id` = 385922) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=385922 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 388985 AND W.type_id = 1) OR (W.util_id != 388985 AND W.type_id = 2)) AND (`post_util_id` = 388985 OR `dest_util_id` = 388985) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=388985 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 292165 AND W.type_id = 1) OR (W.util_id != 292165 AND W.type_id = 2)) AND (`post_util_id` = 292165 OR `dest_util_id` = 292165) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=292165 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 391612 AND W.type_id = 1) OR (W.util_id != 391612 AND W.type_id = 2)) AND (`post_util_id` = 391612 OR `dest_util_id` = 391612) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=391612 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 399076 AND W.type_id = 1) OR (W.util_id != 399076 AND W.type_id = 2)) AND (`post_util_id` = 399076 OR `dest_util_id` = 399076) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=399076 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 400314 AND W.type_id = 1) OR (W.util_id != 400314 AND W.type_id = 2)) AND (`post_util_id` = 400314 OR `dest_util_id` = 400314) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=400314 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 82204 AND W.type_id = 1) OR (W.util_id != 82204 AND W.type_id = 2)) AND (`post_util_id` = 82204 OR `dest_util_id` = 82204) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=82204 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 392549 AND W.type_id = 1) OR (W.util_id != 392549 AND W.type_id = 2)) AND (`post_util_id` = 392549 OR `dest_util_id` = 392549) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=392549 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 430816 AND W.type_id = 1) OR (W.util_id != 430816 AND W.type_id = 2)) AND (`post_util_id` = 430816 OR `dest_util_id` = 430816) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=430816 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 440302 AND W.type_id = 1) OR (W.util_id != 440302 AND W.type_id = 2)) AND (`post_util_id` = 440302 OR `dest_util_id` = 440302) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=440302 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 442177 AND W.type_id = 1) OR (W.util_id != 442177 AND W.type_id = 2)) AND (`post_util_id` = 442177 OR `dest_util_id` = 442177) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=442177 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 291729 AND W.type_id = 1) OR (W.util_id != 291729 AND W.type_id = 2)) AND (`post_util_id` = 291729 OR `dest_util_id` = 291729) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=291729 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 443885 AND W.type_id = 1) OR (W.util_id != 443885 AND W.type_id = 2)) AND (`post_util_id` = 443885 OR `dest_util_id` = 443885) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=443885 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 451513 AND W.type_id = 1) OR (W.util_id != 451513 AND W.type_id = 2)) AND (`post_util_id` = 451513 OR `dest_util_id` = 451513) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=451513 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 451513 AND W.type_id = 1) OR (W.util_id != 451513 AND W.type_id = 2)) AND (`post_util_id` = 451513 OR `dest_util_id` = 451513) 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 = 454825 AND W.type_id = 1) OR (W.util_id != 454825 AND W.type_id = 2)) AND (`post_util_id` = 454825 OR `dest_util_id` = 454825) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=454825 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 382875 AND W.type_id = 1) OR (W.util_id != 382875 AND W.type_id = 2)) AND (`post_util_id` = 382875 OR `dest_util_id` = 382875) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=382875 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 459880 AND W.type_id = 1) OR (W.util_id != 459880 AND W.type_id = 2)) AND (`post_util_id` = 459880 OR `dest_util_id` = 459880) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=459880 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 478141 AND W.type_id = 1) OR (W.util_id != 478141 AND W.type_id = 2)) AND (`post_util_id` = 478141 OR `dest_util_id` = 478141) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=478141 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 487400 AND W.type_id = 1) OR (W.util_id != 487400 AND W.type_id = 2)) AND (`post_util_id` = 487400 OR `dest_util_id` = 487400) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=487400 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 488350 AND W.type_id = 1) OR (W.util_id != 488350 AND W.type_id = 2)) AND (`post_util_id` = 488350 OR `dest_util_id` = 488350) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=488350 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 489624 AND W.type_id = 1) OR (W.util_id != 489624 AND W.type_id = 2)) AND (`post_util_id` = 489624 OR `dest_util_id` = 489624) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=489624 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 493305 AND W.type_id = 1) OR (W.util_id != 493305 AND W.type_id = 2)) AND (`post_util_id` = 493305 OR `dest_util_id` = 493305) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=493305 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 494254 AND W.type_id = 1) OR (W.util_id != 494254 AND W.type_id = 2)) AND (`post_util_id` = 494254 OR `dest_util_id` = 494254) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=494254 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 484821 AND W.type_id = 1) OR (W.util_id != 484821 AND W.type_id = 2)) AND (`post_util_id` = 484821 OR `dest_util_id` = 484821) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=484821 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 307095 AND W.type_id = 1) OR (W.util_id != 307095 AND W.type_id = 2)) AND (`post_util_id` = 307095 OR `dest_util_id` = 307095) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=307095 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 521751 AND W.type_id = 1) OR (W.util_id != 521751 AND W.type_id = 2)) AND (`post_util_id` = 521751 OR `dest_util_id` = 521751) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=521751 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 379720 AND W.type_id = 1) OR (W.util_id != 379720 AND W.type_id = 2)) AND (`post_util_id` = 379720 OR `dest_util_id` = 379720) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=379720 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 529315 AND W.type_id = 1) OR (W.util_id != 529315 AND W.type_id = 2)) AND (`post_util_id` = 529315 OR `dest_util_id` = 529315) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=529315 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 529379 AND W.type_id = 1) OR (W.util_id != 529379 AND W.type_id = 2)) AND (`post_util_id` = 529379 OR `dest_util_id` = 529379) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=529379 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 531299 AND W.type_id = 1) OR (W.util_id != 531299 AND W.type_id = 2)) AND (`post_util_id` = 531299 OR `dest_util_id` = 531299) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=531299 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 535910 AND W.type_id = 1) OR (W.util_id != 535910 AND W.type_id = 2)) AND (`post_util_id` = 535910 OR `dest_util_id` = 535910) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=535910 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 544527 AND W.type_id = 1) OR (W.util_id != 544527 AND W.type_id = 2)) AND (`post_util_id` = 544527 OR `dest_util_id` = 544527) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=544527 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 544696 AND W.type_id = 1) OR (W.util_id != 544696 AND W.type_id = 2)) AND (`post_util_id` = 544696 OR `dest_util_id` = 544696) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=544696 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 547648 AND W.type_id = 1) OR (W.util_id != 547648 AND W.type_id = 2)) AND (`post_util_id` = 547648 OR `dest_util_id` = 547648) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=547648 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 547648 AND W.type_id = 1) OR (W.util_id != 547648 AND W.type_id = 2)) AND (`post_util_id` = 547648 OR `dest_util_id` = 547648) 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 = 547706 AND W.type_id = 1) OR (W.util_id != 547706 AND W.type_id = 2)) AND (`post_util_id` = 547706 OR `dest_util_id` = 547706) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=547706 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 545611 AND W.type_id = 1) OR (W.util_id != 545611 AND W.type_id = 2)) AND (`post_util_id` = 545611 OR `dest_util_id` = 545611) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=545611 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 545611 AND W.type_id = 1) OR (W.util_id != 545611 AND W.type_id = 2)) AND (`post_util_id` = 545611 OR `dest_util_id` = 545611) 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 = 537571 AND W.type_id = 1) OR (W.util_id != 537571 AND W.type_id = 2)) AND (`post_util_id` = 537571 OR `dest_util_id` = 537571) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=537571 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 549883 AND W.type_id = 1) OR (W.util_id != 549883 AND W.type_id = 2)) AND (`post_util_id` = 549883 OR `dest_util_id` = 549883) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=549883 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=88 AND ss.fami_id=5 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='pelle' OR ssrubr_slug like '%pelle%' OR MATCH (ssrubr_slug) AGAINST ('(+pelle)')) AND sk.ssrubr_id='12' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
SELECT * FROM actu WHERE ssrubr_id='12' 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