Indiquer un code postal ou une ville
Poster une annonce
Indiquer un code postal ou une ville
Proposer mon aide
Louer du matériel ou proposer un service
Faire appel à mes voisins
Besoin d'un objet ou d'un service ?
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wall.php
SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='babysitting'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=39
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='59'
SELECT ville_nom FROM villes WHERE ville_cp='59370' AND ville_nom like '%mons%en%baroeul%' ORDER BY ville_population_2012 DESC LIMIT 0,1
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59370'
SELECT ville_cp, ROUND((((acos(sin((50.642*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.642*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.10778- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.462135678816 AND ville_latitude_deg<50.821864321184 AND ville_longitude_deg>2.8241551882322 AND ville_longitude_deg<3.3914048117678 HAVING distance <= 20 ORDER BY distance ASC
SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug, ssrubr_mail FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND c.cate_title_slug='babysitting' AND ss.fami_id=3 ORDER BY ssrubr_order
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='39' AND wish_visu IN (1,6,10) AND wish_cp like '59370%'
SELECT * FROM texte WHERE cate_id=39
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='3' AND cate_cate_id IS NULL ORDER BY cate_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (39) ORDER BY ssrubr_order ASC
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='59370'
SELECT ville_cp, ROUND((((acos(sin((50.642*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.642*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.10778- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.462135678816 AND ville_latitude_deg<50.821864321184 AND ville_longitude_deg>2.8241551882322 AND ville_longitude_deg<3.3914048117678 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((50.642*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.642*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.10778- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.192339197041 AND ville_latitude_deg<51.091660802959 AND ville_longitude_deg>2.3987118562302 AND ville_longitude_deg<3.8168481437698 HAVING distance <= 50 ORDER BY distance ASC
SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='39' AND wish_visu IN (1,6,10) AND wish_cp IN (59370,59370,59260,59110,59350,59160,59000,59800,59777,59700,59170,59290,59790,59520,59350,59655,59491,59493,59650,59130,59510,59118,59910,59810,59510,59420,59120,59155,59100,59139,59262,59152,59152,59840,59390,59152,59390,59390,59830,59200,59175,59237,59780,59320,59152,59139,59320,59390,59175,59273,59320,59160,59320,59150,59223,59126,59250,59840,59273,59320,59115,59780,59840,59320,59890,59263,59830,59113,59780,59211,59830,59710,59710,59960,59320,59320,59242,59830,59147,59830,59320,59710,59166,59830,59134,59147,59242,59117,59551,59242,59236,59116,59147,59890,59830,59560,59133,59930,59710,59280,59136,59551,59560,59134,59239,59251,59133,59280,59272,59134,59112,59112,59184,59235,59246,59239,59261,59310,59310,59193,59249,62820,59310,59134,62840,59185,59310,59274,59249)
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((50.642*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.642*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.10778- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='39' AND wish_visu IN (1,6,10) AND wish_cp IN (59370,59370,59260,59110,59350,59160,59000,59800,59777,59700,59170,59290,59790,59520,59350,59655,59491,59493,59650,59130,59510,59118,59910,59810,59510,59420,59120,59155,59100,59139,59262,59152,59152,59840,59390,59152,59390,59390,59830,59200,59175,59237,59780,59320,59152,59139,59320,59390,59175,59273,59320,59160,59320,59150,59223,59126,59250,59840,59273,59320,59115,59780,59840,59320,59890,59263,59830,59113,59780,59211,59830,59710,59710,59960,59320,59320,59242,59830,59147,59830,59320,59710,59166,59830,59134,59147,59242,59117,59551,59242,59236,59116,59147,59890,59830,59560,59133,59930,59710,59280,59136,59551,59560,59134,59239,59251,59133,59280,59272,59134,59112,59112,59184,59235,59246,59239,59261,59310,59310,59193,59249,62820,59310,59134,62840,59185,59310,59274,59249) AND type_id=1 GROUP BY wish_id
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='59370'
SELECT ville_cp, ROUND((((acos(sin((50.642*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.642*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.10778- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.462135678816 AND ville_latitude_deg<50.821864321184 AND ville_longitude_deg>2.8241551882322 AND ville_longitude_deg<3.3914048117678 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((50.642*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.642*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.10778- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.192339197041 AND ville_latitude_deg<51.091660802959 AND ville_longitude_deg>2.3987118562302 AND ville_longitude_deg<3.8168481437698 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 = 13929 AND W.type_id = 1) OR (W.util_id != 13929 AND W.type_id = 2)) AND (`post_util_id` = 13929 OR `dest_util_id` = 13929) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=13929 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 37775 AND W.type_id = 1) OR (W.util_id != 37775 AND W.type_id = 2)) AND (`post_util_id` = 37775 OR `dest_util_id` = 37775) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=37775 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 42998 AND W.type_id = 1) OR (W.util_id != 42998 AND W.type_id = 2)) AND (`post_util_id` = 42998 OR `dest_util_id` = 42998) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=42998 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 51871 AND W.type_id = 1) OR (W.util_id != 51871 AND W.type_id = 2)) AND (`post_util_id` = 51871 OR `dest_util_id` = 51871) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=51871 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 60932 AND W.type_id = 1) OR (W.util_id != 60932 AND W.type_id = 2)) AND (`post_util_id` = 60932 OR `dest_util_id` = 60932) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=60932 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 71361 AND W.type_id = 1) OR (W.util_id != 71361 AND W.type_id = 2)) AND (`post_util_id` = 71361 OR `dest_util_id` = 71361) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=71361 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 62907 AND W.type_id = 1) OR (W.util_id != 62907 AND W.type_id = 2)) AND (`post_util_id` = 62907 OR `dest_util_id` = 62907) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=62907 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 78206 AND W.type_id = 1) OR (W.util_id != 78206 AND W.type_id = 2)) AND (`post_util_id` = 78206 OR `dest_util_id` = 78206) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=78206 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 86395 AND W.type_id = 1) OR (W.util_id != 86395 AND W.type_id = 2)) AND (`post_util_id` = 86395 OR `dest_util_id` = 86395) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=86395 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 89380 AND W.type_id = 1) OR (W.util_id != 89380 AND W.type_id = 2)) AND (`post_util_id` = 89380 OR `dest_util_id` = 89380) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=89380 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 102339 AND W.type_id = 1) OR (W.util_id != 102339 AND W.type_id = 2)) AND (`post_util_id` = 102339 OR `dest_util_id` = 102339) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=102339 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 124465 AND W.type_id = 1) OR (W.util_id != 124465 AND W.type_id = 2)) AND (`post_util_id` = 124465 OR `dest_util_id` = 124465) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=124465 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 127019 AND W.type_id = 1) OR (W.util_id != 127019 AND W.type_id = 2)) AND (`post_util_id` = 127019 OR `dest_util_id` = 127019) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=127019 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 127624 AND W.type_id = 1) OR (W.util_id != 127624 AND W.type_id = 2)) AND (`post_util_id` = 127624 OR `dest_util_id` = 127624) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=127624 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 135274 AND W.type_id = 1) OR (W.util_id != 135274 AND W.type_id = 2)) AND (`post_util_id` = 135274 OR `dest_util_id` = 135274) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=135274 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 138500 AND W.type_id = 1) OR (W.util_id != 138500 AND W.type_id = 2)) AND (`post_util_id` = 138500 OR `dest_util_id` = 138500) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=138500 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 139999 AND W.type_id = 1) OR (W.util_id != 139999 AND W.type_id = 2)) AND (`post_util_id` = 139999 OR `dest_util_id` = 139999) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=139999 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 146333 AND W.type_id = 1) OR (W.util_id != 146333 AND W.type_id = 2)) AND (`post_util_id` = 146333 OR `dest_util_id` = 146333) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=146333 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 146333 AND W.type_id = 1) OR (W.util_id != 146333 AND W.type_id = 2)) AND (`post_util_id` = 146333 OR `dest_util_id` = 146333) 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 = 155776 AND W.type_id = 1) OR (W.util_id != 155776 AND W.type_id = 2)) AND (`post_util_id` = 155776 OR `dest_util_id` = 155776) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=155776 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 171044 AND W.type_id = 1) OR (W.util_id != 171044 AND W.type_id = 2)) AND (`post_util_id` = 171044 OR `dest_util_id` = 171044) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=171044 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 175268 AND W.type_id = 1) OR (W.util_id != 175268 AND W.type_id = 2)) AND (`post_util_id` = 175268 OR `dest_util_id` = 175268) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=175268 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 175371 AND W.type_id = 1) OR (W.util_id != 175371 AND W.type_id = 2)) AND (`post_util_id` = 175371 OR `dest_util_id` = 175371) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=175371 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 175504 AND W.type_id = 1) OR (W.util_id != 175504 AND W.type_id = 2)) AND (`post_util_id` = 175504 OR `dest_util_id` = 175504) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=175504 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 190748 AND W.type_id = 1) OR (W.util_id != 190748 AND W.type_id = 2)) AND (`post_util_id` = 190748 OR `dest_util_id` = 190748) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=190748 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 191961 AND W.type_id = 1) OR (W.util_id != 191961 AND W.type_id = 2)) AND (`post_util_id` = 191961 OR `dest_util_id` = 191961) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=191961 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 194633 AND W.type_id = 1) OR (W.util_id != 194633 AND W.type_id = 2)) AND (`post_util_id` = 194633 OR `dest_util_id` = 194633) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=194633 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 194652 AND W.type_id = 1) OR (W.util_id != 194652 AND W.type_id = 2)) AND (`post_util_id` = 194652 OR `dest_util_id` = 194652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=194652 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 208880 AND W.type_id = 1) OR (W.util_id != 208880 AND W.type_id = 2)) AND (`post_util_id` = 208880 OR `dest_util_id` = 208880) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=208880 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 208880 AND W.type_id = 1) OR (W.util_id != 208880 AND W.type_id = 2)) AND (`post_util_id` = 208880 OR `dest_util_id` = 208880) 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 = 181315 AND W.type_id = 1) OR (W.util_id != 181315 AND W.type_id = 2)) AND (`post_util_id` = 181315 OR `dest_util_id` = 181315) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=181315 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 227243 AND W.type_id = 1) OR (W.util_id != 227243 AND W.type_id = 2)) AND (`post_util_id` = 227243 OR `dest_util_id` = 227243) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=227243 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 265404 AND W.type_id = 1) OR (W.util_id != 265404 AND W.type_id = 2)) AND (`post_util_id` = 265404 OR `dest_util_id` = 265404) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=265404 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 257043 AND W.type_id = 1) OR (W.util_id != 257043 AND W.type_id = 2)) AND (`post_util_id` = 257043 OR `dest_util_id` = 257043) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=257043 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 278732 AND W.type_id = 1) OR (W.util_id != 278732 AND W.type_id = 2)) AND (`post_util_id` = 278732 OR `dest_util_id` = 278732) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=278732 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 287562 AND W.type_id = 1) OR (W.util_id != 287562 AND W.type_id = 2)) AND (`post_util_id` = 287562 OR `dest_util_id` = 287562) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=287562 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 317384 AND W.type_id = 1) OR (W.util_id != 317384 AND W.type_id = 2)) AND (`post_util_id` = 317384 OR `dest_util_id` = 317384) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=317384 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 319059 AND W.type_id = 1) OR (W.util_id != 319059 AND W.type_id = 2)) AND (`post_util_id` = 319059 OR `dest_util_id` = 319059) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=319059 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 319308 AND W.type_id = 1) OR (W.util_id != 319308 AND W.type_id = 2)) AND (`post_util_id` = 319308 OR `dest_util_id` = 319308) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=319308 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 320302 AND W.type_id = 1) OR (W.util_id != 320302 AND W.type_id = 2)) AND (`post_util_id` = 320302 OR `dest_util_id` = 320302) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=320302 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 18114 AND W.type_id = 1) OR (W.util_id != 18114 AND W.type_id = 2)) AND (`post_util_id` = 18114 OR `dest_util_id` = 18114) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=18114 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 336056 AND W.type_id = 1) OR (W.util_id != 336056 AND W.type_id = 2)) AND (`post_util_id` = 336056 OR `dest_util_id` = 336056) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=336056 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 337330 AND W.type_id = 1) OR (W.util_id != 337330 AND W.type_id = 2)) AND (`post_util_id` = 337330 OR `dest_util_id` = 337330) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=337330 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 341679 AND W.type_id = 1) OR (W.util_id != 341679 AND W.type_id = 2)) AND (`post_util_id` = 341679 OR `dest_util_id` = 341679) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=341679 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 341978 AND W.type_id = 1) OR (W.util_id != 341978 AND W.type_id = 2)) AND (`post_util_id` = 341978 OR `dest_util_id` = 341978) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=341978 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 345255 AND W.type_id = 1) OR (W.util_id != 345255 AND W.type_id = 2)) AND (`post_util_id` = 345255 OR `dest_util_id` = 345255) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=345255 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 354750 AND W.type_id = 1) OR (W.util_id != 354750 AND W.type_id = 2)) AND (`post_util_id` = 354750 OR `dest_util_id` = 354750) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=354750 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 354750 AND W.type_id = 1) OR (W.util_id != 354750 AND W.type_id = 2)) AND (`post_util_id` = 354750 OR `dest_util_id` = 354750) 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 = 355834 AND W.type_id = 1) OR (W.util_id != 355834 AND W.type_id = 2)) AND (`post_util_id` = 355834 OR `dest_util_id` = 355834) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=355834 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 316265 AND W.type_id = 1) OR (W.util_id != 316265 AND W.type_id = 2)) AND (`post_util_id` = 316265 OR `dest_util_id` = 316265) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=316265 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 224606 AND W.type_id = 1) OR (W.util_id != 224606 AND W.type_id = 2)) AND (`post_util_id` = 224606 OR `dest_util_id` = 224606) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=224606 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 384471 AND W.type_id = 1) OR (W.util_id != 384471 AND W.type_id = 2)) AND (`post_util_id` = 384471 OR `dest_util_id` = 384471) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=384471 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 385579 AND W.type_id = 1) OR (W.util_id != 385579 AND W.type_id = 2)) AND (`post_util_id` = 385579 OR `dest_util_id` = 385579) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=385579 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 391012 AND W.type_id = 1) OR (W.util_id != 391012 AND W.type_id = 2)) AND (`post_util_id` = 391012 OR `dest_util_id` = 391012) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=391012 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 404516 AND W.type_id = 1) OR (W.util_id != 404516 AND W.type_id = 2)) AND (`post_util_id` = 404516 OR `dest_util_id` = 404516) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=404516 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 369470 AND W.type_id = 1) OR (W.util_id != 369470 AND W.type_id = 2)) AND (`post_util_id` = 369470 OR `dest_util_id` = 369470) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=369470 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 415284 AND W.type_id = 1) OR (W.util_id != 415284 AND W.type_id = 2)) AND (`post_util_id` = 415284 OR `dest_util_id` = 415284) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=415284 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 417660 AND W.type_id = 1) OR (W.util_id != 417660 AND W.type_id = 2)) AND (`post_util_id` = 417660 OR `dest_util_id` = 417660) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=417660 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 413732 AND W.type_id = 1) OR (W.util_id != 413732 AND W.type_id = 2)) AND (`post_util_id` = 413732 OR `dest_util_id` = 413732) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=413732 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 413732 AND W.type_id = 1) OR (W.util_id != 413732 AND W.type_id = 2)) AND (`post_util_id` = 413732 OR `dest_util_id` = 413732) 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 = 425610 AND W.type_id = 1) OR (W.util_id != 425610 AND W.type_id = 2)) AND (`post_util_id` = 425610 OR `dest_util_id` = 425610) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=425610 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 290190 AND W.type_id = 1) OR (W.util_id != 290190 AND W.type_id = 2)) AND (`post_util_id` = 290190 OR `dest_util_id` = 290190) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=290190 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 434620 AND W.type_id = 1) OR (W.util_id != 434620 AND W.type_id = 2)) AND (`post_util_id` = 434620 OR `dest_util_id` = 434620) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=434620 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 439409 AND W.type_id = 1) OR (W.util_id != 439409 AND W.type_id = 2)) AND (`post_util_id` = 439409 OR `dest_util_id` = 439409) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=439409 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 439409 AND W.type_id = 1) OR (W.util_id != 439409 AND W.type_id = 2)) AND (`post_util_id` = 439409 OR `dest_util_id` = 439409) 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 = 455455 AND W.type_id = 1) OR (W.util_id != 455455 AND W.type_id = 2)) AND (`post_util_id` = 455455 OR `dest_util_id` = 455455) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=455455 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 471535 AND W.type_id = 1) OR (W.util_id != 471535 AND W.type_id = 2)) AND (`post_util_id` = 471535 OR `dest_util_id` = 471535) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=471535 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 306699 AND W.type_id = 1) OR (W.util_id != 306699 AND W.type_id = 2)) AND (`post_util_id` = 306699 OR `dest_util_id` = 306699) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=306699 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 477398 AND W.type_id = 1) OR (W.util_id != 477398 AND W.type_id = 2)) AND (`post_util_id` = 477398 OR `dest_util_id` = 477398) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=477398 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 477606 AND W.type_id = 1) OR (W.util_id != 477606 AND W.type_id = 2)) AND (`post_util_id` = 477606 OR `dest_util_id` = 477606) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=477606 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 486810 AND W.type_id = 1) OR (W.util_id != 486810 AND W.type_id = 2)) AND (`post_util_id` = 486810 OR `dest_util_id` = 486810) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=486810 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 521019 AND W.type_id = 1) OR (W.util_id != 521019 AND W.type_id = 2)) AND (`post_util_id` = 521019 OR `dest_util_id` = 521019) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=521019 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 527167 AND W.type_id = 1) OR (W.util_id != 527167 AND W.type_id = 2)) AND (`post_util_id` = 527167 OR `dest_util_id` = 527167) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=527167 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 486196 AND W.type_id = 1) OR (W.util_id != 486196 AND W.type_id = 2)) AND (`post_util_id` = 486196 OR `dest_util_id` = 486196) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=486196 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 486196 AND W.type_id = 1) OR (W.util_id != 486196 AND W.type_id = 2)) AND (`post_util_id` = 486196 OR `dest_util_id` = 486196) 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 = 537549 AND W.type_id = 1) OR (W.util_id != 537549 AND W.type_id = 2)) AND (`post_util_id` = 537549 OR `dest_util_id` = 537549) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=537549 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 18114 AND W.type_id = 1) OR (W.util_id != 18114 AND W.type_id = 2)) AND (`post_util_id` = 18114 OR `dest_util_id` = 18114) 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 = 549402 AND W.type_id = 1) OR (W.util_id != 549402 AND W.type_id = 2)) AND (`post_util_id` = 549402 OR `dest_util_id` = 549402) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=549402 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='1008' 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 = 317384 AND W.type_id = 1) OR (W.util_id != 317384 AND W.type_id = 2)) AND (`post_util_id` = 317384 OR `dest_util_id` = 317384) 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 = 317384
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='939' 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 = 486810 AND W.type_id = 1) OR (W.util_id != 486810 AND W.type_id = 2)) AND (`post_util_id` = 486810 OR `dest_util_id` = 486810) 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 = 486810
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='939' 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 = 171044 AND W.type_id = 1) OR (W.util_id != 171044 AND W.type_id = 2)) AND (`post_util_id` = 171044 OR `dest_util_id` = 171044) 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 = 171044
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='1008' 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 = 278732 AND W.type_id = 1) OR (W.util_id != 278732 AND W.type_id = 2)) AND (`post_util_id` = 278732 OR `dest_util_id` = 278732) 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 = 278732
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='939' 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 = 537549 AND W.type_id = 1) OR (W.util_id != 537549 AND W.type_id = 2)) AND (`post_util_id` = 537549 OR `dest_util_id` = 537549) 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 = 537549
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='942' 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 = 341978 AND W.type_id = 1) OR (W.util_id != 341978 AND W.type_id = 2)) AND (`post_util_id` = 341978 OR `dest_util_id` = 341978) 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 = 341978
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='1031' 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 = 306699 AND W.type_id = 1) OR (W.util_id != 306699 AND W.type_id = 2)) AND (`post_util_id` = 306699 OR `dest_util_id` = 306699) 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 = 306699
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='1031' 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 = 413732 AND W.type_id = 1) OR (W.util_id != 413732 AND W.type_id = 2)) AND (`post_util_id` = 413732 OR `dest_util_id` = 413732) 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 = 413732
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='1031' 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 = 413732 AND W.type_id = 1) OR (W.util_id != 413732 AND W.type_id = 2)) AND (`post_util_id` = 413732 OR `dest_util_id` = 413732) 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 = 413732
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='1008' 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 = 320302 AND W.type_id = 1) OR (W.util_id != 320302 AND W.type_id = 2)) AND (`post_util_id` = 320302 OR `dest_util_id` = 320302) 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 = 320302
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='1031' 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 = 355834 AND W.type_id = 1) OR (W.util_id != 355834 AND W.type_id = 2)) AND (`post_util_id` = 355834 OR `dest_util_id` = 355834) 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 = 355834
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='1031' 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 = 341679 AND W.type_id = 1) OR (W.util_id != 341679 AND W.type_id = 2)) AND (`post_util_id` = 341679 OR `dest_util_id` = 341679) 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 = 341679
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='939' 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 = 227243 AND W.type_id = 1) OR (W.util_id != 227243 AND W.type_id = 2)) AND (`post_util_id` = 227243 OR `dest_util_id` = 227243) 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 = 227243
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='1031' 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 = 190748 AND W.type_id = 1) OR (W.util_id != 190748 AND W.type_id = 2)) AND (`post_util_id` = 190748 OR `dest_util_id` = 190748) 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 = 190748
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='1008' 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 = 191961 AND W.type_id = 1) OR (W.util_id != 191961 AND W.type_id = 2)) AND (`post_util_id` = 191961 OR `dest_util_id` = 191961) 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 = 191961
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='1031' 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 = 316265 AND W.type_id = 1) OR (W.util_id != 316265 AND W.type_id = 2)) AND (`post_util_id` = 316265 OR `dest_util_id` = 316265) 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 = 316265
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='1008' 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 = 319059 AND W.type_id = 1) OR (W.util_id != 319059 AND W.type_id = 2)) AND (`post_util_id` = 319059 OR `dest_util_id` = 319059) 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 = 319059
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='1031' 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 = 86395 AND W.type_id = 1) OR (W.util_id != 86395 AND W.type_id = 2)) AND (`post_util_id` = 86395 OR `dest_util_id` = 86395) 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 = 86395
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='1031' 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 = 415284 AND W.type_id = 1) OR (W.util_id != 415284 AND W.type_id = 2)) AND (`post_util_id` = 415284 OR `dest_util_id` = 415284) 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 = 415284
SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND ss.cate_id=39 AND ss.fami_id=3 ORDER BY ssrubr_order LIMIT 6,100
SELECT ss.fami_id, fami_url, ss.cate_id, cate_title_slug, keywords_title FROM `ssrubr_keywords` sk, ssrubr ss, category c, family f WHERE sk.ssrubr_id=ss.ssrubr_id AND ss.cate_id=c.cate_id AND c.fami_id=f.fami_id AND (ssrubr_slug='' OR ssrubr_slug like '%%' OR MATCH (ssrubr_slug) AGAINST ('(+)')) AND sk.ssrubr_id='' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
SELECT * FROM actu WHERE ssrubr_id='' 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