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='services-divers'
SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=229
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='95'
SELECT ville_nom FROM villes WHERE ville_cp='95590' AND ville_nom like '%nointel%' ORDER BY ville_population_2012 DESC LIMIT 0,1
SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%aide%aux%courses%' OR ssrubr_title like '%aide%aux%courses%' OR ssrubr_slug like '%aide%aux%courses%') AND cate_id='229' ORDER BY ssrubr_id LIMIT 0,1
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='95590'
SELECT ville_cp, ROUND((((acos(sin((49.1333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.1333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.953435678816 AND ville_latitude_deg<49.313164321184 AND ville_longitude_deg>2.0251043400158 AND ville_longitude_deg<2.5748956599842 HAVING distance <= 20 ORDER BY distance ASC
SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='course; aide aux courses'
SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='229'AND MATCH (wish_title,wish_desc) AGAINST ('+course; aide aux courses*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '95590%'
SELECT * FROM texte WHERE cate_id=229
SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='course; aide aux courses' OR ssrubr_slug='course;-aide-aux-courses' OR (ssrubr_title like '%course; aide aux courses%')) AND cate_id='229' ORDER BY ssrubr_id LIMIT 0,1
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='3' AND cate_cate_id IS NULL ORDER BY cate_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (229) ORDER BY ssrubr_order ASC
SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='aide-aux-courses' AND cate_id='229'
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='95590'
SELECT ville_cp, ROUND((((acos(sin((49.1333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.1333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.953435678816 AND ville_latitude_deg<49.313164321184 AND ville_longitude_deg>2.0251043400158 AND ville_longitude_deg<2.5748956599842 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((49.1333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.1333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.683639197041 AND ville_latitude_deg<49.582960802959 AND ville_longitude_deg>1.6127549238713 AND ville_longitude_deg<2.9872450761287 HAVING distance <= 50 ORDER BY distance ASC
SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='229' AND MATCH (wish_desc) AGAINST ('(+course; +aide +aux +courses*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (95590,95590,95260,95590,95260,95270,95340,95660,95270,95340,95820,95270,95270,95290,60820,60230,60530,95560,95590,95620,95340,95570,95560,60530,95560,95270,60530,95760,95270,95690,95270,95840,60460,95430,95630,95570,60530,60530,95570,95560,60540,60540,95690,60260,95270,95840,95570,60270,95270,95720,95540,60540,60460,95690,95740,95690,60530,95330,95270,95270,60530,60340,60540,95720,95460,95430,95850,95850,60580,60340,60540,95150,95550,95270,95300,95680,95190,95390,95810,60110,95320,95350,95470,95720,60500,60740,95190,95440,95810,95580,95580,60660,95600,95250,95300,95160,60110,60500,95380,95810,95670,95350,95130,60660,60730,60660,60560,95200,95400,60660,60660,60570,60160,95720,95480,95310,95300,60110,60730,95230,60730,60250,95170,95120,60520,95810,95410,95810,60570,95300,95130,95220,60160,95190,95810,95650,60730,95810,95240,60520,95380,60300,60300,95520,95210,95218,95880,95470,60250,95370,95400,95360,95110,60730,95640,60180,93380,95500,60300,60175,95380,60110,95610,60119,93430,60660,60100,95500,95500)
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((49.1333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.1333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='229' AND MATCH (wish_desc) AGAINST ('(+course; +aide +aux +courses*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (95590,95590,95260,95590,95260,95270,95340,95660,95270,95340,95820,95270,95270,95290,60820,60230,60530,95560,95590,95620,95340,95570,95560,60530,95560,95270,60530,95760,95270,95690,95270,95840,60460,95430,95630,95570,60530,60530,95570,95560,60540,60540,95690,60260,95270,95840,95570,60270,95270,95720,95540,60540,60460,95690,95740,95690,60530,95330,95270,95270,60530,60340,60540,95720,95460,95430,95850,95850,60580,60340,60540,95150,95550,95270,95300,95680,95190,95390,95810,60110,95320,95350,95470,95720,60500,60740,95190,95440,95810,95580,95580,60660,95600,95250,95300,95160,60110,60500,95380,95810,95670,95350,95130,60660,60730,60660,60560,95200,95400,60660,60660,60570,60160,95720,95480,95310,95300,60110,60730,95230,60730,60250,95170,95120,60520,95810,95410,95810,60570,95300,95130,95220,60160,95190,95810,95650,60730,95810,95240,60520,95380,60300,60300,95520,95210,95218,95880,95470,60250,95370,95400,95360,95110,60730,95640,60180,93380,95500,60300,60175,95380,60110,95610,60119,93430,60660,60100,95500,95500) AND type_id=1 GROUP BY wish_id
SELECT ville_cp, ville_latitude_deg, ville_longitude_deg FROM villes v WHERE ville_cp='95590'
SELECT ville_cp, ROUND((((acos(sin((49.1333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.1333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.953435678816 AND ville_latitude_deg<49.313164321184 AND ville_longitude_deg>2.0251043400158 AND ville_longitude_deg<2.5748956599842 HAVING distance <= 20 ORDER BY distance ASC
SELECT ville_cp, ROUND((((acos(sin((49.1333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.1333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.683639197041 AND ville_latitude_deg<49.582960802959 AND ville_longitude_deg>1.6127549238713 AND ville_longitude_deg<2.9872450761287 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 = 50019 AND W.type_id = 1) OR (W.util_id != 50019 AND W.type_id = 2)) AND (`post_util_id` = 50019 OR `dest_util_id` = 50019) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=50019 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 73786 AND W.type_id = 1) OR (W.util_id != 73786 AND W.type_id = 2)) AND (`post_util_id` = 73786 OR `dest_util_id` = 73786) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=73786 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 84204 AND W.type_id = 1) OR (W.util_id != 84204 AND W.type_id = 2)) AND (`post_util_id` = 84204 OR `dest_util_id` = 84204) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=84204 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 64540 AND W.type_id = 1) OR (W.util_id != 64540 AND W.type_id = 2)) AND (`post_util_id` = 64540 OR `dest_util_id` = 64540) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=64540 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 99204 AND W.type_id = 1) OR (W.util_id != 99204 AND W.type_id = 2)) AND (`post_util_id` = 99204 OR `dest_util_id` = 99204) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=99204 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 105028 AND W.type_id = 1) OR (W.util_id != 105028 AND W.type_id = 2)) AND (`post_util_id` = 105028 OR `dest_util_id` = 105028) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=105028 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 106342 AND W.type_id = 1) OR (W.util_id != 106342 AND W.type_id = 2)) AND (`post_util_id` = 106342 OR `dest_util_id` = 106342) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=106342 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 107171 AND W.type_id = 1) OR (W.util_id != 107171 AND W.type_id = 2)) AND (`post_util_id` = 107171 OR `dest_util_id` = 107171) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=107171 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 107950 AND W.type_id = 1) OR (W.util_id != 107950 AND W.type_id = 2)) AND (`post_util_id` = 107950 OR `dest_util_id` = 107950) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=107950 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 112150 AND W.type_id = 1) OR (W.util_id != 112150 AND W.type_id = 2)) AND (`post_util_id` = 112150 OR `dest_util_id` = 112150) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=112150 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 119643 AND W.type_id = 1) OR (W.util_id != 119643 AND W.type_id = 2)) AND (`post_util_id` = 119643 OR `dest_util_id` = 119643) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=119643 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 120445 AND W.type_id = 1) OR (W.util_id != 120445 AND W.type_id = 2)) AND (`post_util_id` = 120445 OR `dest_util_id` = 120445) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=120445 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 123058 AND W.type_id = 1) OR (W.util_id != 123058 AND W.type_id = 2)) AND (`post_util_id` = 123058 OR `dest_util_id` = 123058) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=123058 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 125306 AND W.type_id = 1) OR (W.util_id != 125306 AND W.type_id = 2)) AND (`post_util_id` = 125306 OR `dest_util_id` = 125306) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=125306 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 127842 AND W.type_id = 1) OR (W.util_id != 127842 AND W.type_id = 2)) AND (`post_util_id` = 127842 OR `dest_util_id` = 127842) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=127842 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 104588 AND W.type_id = 1) OR (W.util_id != 104588 AND W.type_id = 2)) AND (`post_util_id` = 104588 OR `dest_util_id` = 104588) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=104588 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 43020 AND W.type_id = 1) OR (W.util_id != 43020 AND W.type_id = 2)) AND (`post_util_id` = 43020 OR `dest_util_id` = 43020) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=43020 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 86564 AND W.type_id = 1) OR (W.util_id != 86564 AND W.type_id = 2)) AND (`post_util_id` = 86564 OR `dest_util_id` = 86564) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=86564 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 139017 AND W.type_id = 1) OR (W.util_id != 139017 AND W.type_id = 2)) AND (`post_util_id` = 139017 OR `dest_util_id` = 139017) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=139017 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 107163 AND W.type_id = 1) OR (W.util_id != 107163 AND W.type_id = 2)) AND (`post_util_id` = 107163 OR `dest_util_id` = 107163) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=107163 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 140711 AND W.type_id = 1) OR (W.util_id != 140711 AND W.type_id = 2)) AND (`post_util_id` = 140711 OR `dest_util_id` = 140711) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=140711 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 141057 AND W.type_id = 1) OR (W.util_id != 141057 AND W.type_id = 2)) AND (`post_util_id` = 141057 OR `dest_util_id` = 141057) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=141057 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 141769 AND W.type_id = 1) OR (W.util_id != 141769 AND W.type_id = 2)) AND (`post_util_id` = 141769 OR `dest_util_id` = 141769) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=141769 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 145408 AND W.type_id = 1) OR (W.util_id != 145408 AND W.type_id = 2)) AND (`post_util_id` = 145408 OR `dest_util_id` = 145408) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=145408 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 147792 AND W.type_id = 1) OR (W.util_id != 147792 AND W.type_id = 2)) AND (`post_util_id` = 147792 OR `dest_util_id` = 147792) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=147792 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 147792 AND W.type_id = 1) OR (W.util_id != 147792 AND W.type_id = 2)) AND (`post_util_id` = 147792 OR `dest_util_id` = 147792) 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 = 147792 AND W.type_id = 1) OR (W.util_id != 147792 AND W.type_id = 2)) AND (`post_util_id` = 147792 OR `dest_util_id` = 147792) 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 = 65684 AND W.type_id = 1) OR (W.util_id != 65684 AND W.type_id = 2)) AND (`post_util_id` = 65684 OR `dest_util_id` = 65684) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=65684 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 165668 AND W.type_id = 1) OR (W.util_id != 165668 AND W.type_id = 2)) AND (`post_util_id` = 165668 OR `dest_util_id` = 165668) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=165668 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 168894 AND W.type_id = 1) OR (W.util_id != 168894 AND W.type_id = 2)) AND (`post_util_id` = 168894 OR `dest_util_id` = 168894) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=168894 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 168728 AND W.type_id = 1) OR (W.util_id != 168728 AND W.type_id = 2)) AND (`post_util_id` = 168728 OR `dest_util_id` = 168728) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=168728 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 168728 AND W.type_id = 1) OR (W.util_id != 168728 AND W.type_id = 2)) AND (`post_util_id` = 168728 OR `dest_util_id` = 168728) 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 = 175844 AND W.type_id = 1) OR (W.util_id != 175844 AND W.type_id = 2)) AND (`post_util_id` = 175844 OR `dest_util_id` = 175844) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=175844 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 179170 AND W.type_id = 1) OR (W.util_id != 179170 AND W.type_id = 2)) AND (`post_util_id` = 179170 OR `dest_util_id` = 179170) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=179170 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 193097 AND W.type_id = 1) OR (W.util_id != 193097 AND W.type_id = 2)) AND (`post_util_id` = 193097 OR `dest_util_id` = 193097) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=193097 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 196645 AND W.type_id = 1) OR (W.util_id != 196645 AND W.type_id = 2)) AND (`post_util_id` = 196645 OR `dest_util_id` = 196645) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=196645 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 201393 AND W.type_id = 1) OR (W.util_id != 201393 AND W.type_id = 2)) AND (`post_util_id` = 201393 OR `dest_util_id` = 201393) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=201393 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 205660 AND W.type_id = 1) OR (W.util_id != 205660 AND W.type_id = 2)) AND (`post_util_id` = 205660 OR `dest_util_id` = 205660) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=205660 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 210978 AND W.type_id = 1) OR (W.util_id != 210978 AND W.type_id = 2)) AND (`post_util_id` = 210978 OR `dest_util_id` = 210978) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=210978 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 215267 AND W.type_id = 1) OR (W.util_id != 215267 AND W.type_id = 2)) AND (`post_util_id` = 215267 OR `dest_util_id` = 215267) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=215267 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 220393 AND W.type_id = 1) OR (W.util_id != 220393 AND W.type_id = 2)) AND (`post_util_id` = 220393 OR `dest_util_id` = 220393) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=220393 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 220486 AND W.type_id = 1) OR (W.util_id != 220486 AND W.type_id = 2)) AND (`post_util_id` = 220486 OR `dest_util_id` = 220486) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=220486 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 220486 AND W.type_id = 1) OR (W.util_id != 220486 AND W.type_id = 2)) AND (`post_util_id` = 220486 OR `dest_util_id` = 220486) 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 = 225737 AND W.type_id = 1) OR (W.util_id != 225737 AND W.type_id = 2)) AND (`post_util_id` = 225737 OR `dest_util_id` = 225737) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=225737 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 227505 AND W.type_id = 1) OR (W.util_id != 227505 AND W.type_id = 2)) AND (`post_util_id` = 227505 OR `dest_util_id` = 227505) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=227505 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 229307 AND W.type_id = 1) OR (W.util_id != 229307 AND W.type_id = 2)) AND (`post_util_id` = 229307 OR `dest_util_id` = 229307) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=229307 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 229307 AND W.type_id = 1) OR (W.util_id != 229307 AND W.type_id = 2)) AND (`post_util_id` = 229307 OR `dest_util_id` = 229307) 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 = 134449 AND W.type_id = 1) OR (W.util_id != 134449 AND W.type_id = 2)) AND (`post_util_id` = 134449 OR `dest_util_id` = 134449) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=134449 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 237507 AND W.type_id = 1) OR (W.util_id != 237507 AND W.type_id = 2)) AND (`post_util_id` = 237507 OR `dest_util_id` = 237507) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=237507 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 250089 AND W.type_id = 1) OR (W.util_id != 250089 AND W.type_id = 2)) AND (`post_util_id` = 250089 OR `dest_util_id` = 250089) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=250089 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 259014 AND W.type_id = 1) OR (W.util_id != 259014 AND W.type_id = 2)) AND (`post_util_id` = 259014 OR `dest_util_id` = 259014) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=259014 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 111149 AND W.type_id = 1) OR (W.util_id != 111149 AND W.type_id = 2)) AND (`post_util_id` = 111149 OR `dest_util_id` = 111149) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=111149 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 254335 AND W.type_id = 1) OR (W.util_id != 254335 AND W.type_id = 2)) AND (`post_util_id` = 254335 OR `dest_util_id` = 254335) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=254335 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 134967 AND W.type_id = 1) OR (W.util_id != 134967 AND W.type_id = 2)) AND (`post_util_id` = 134967 OR `dest_util_id` = 134967) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=134967 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 278749 AND W.type_id = 1) OR (W.util_id != 278749 AND W.type_id = 2)) AND (`post_util_id` = 278749 OR `dest_util_id` = 278749) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=278749 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 279667 AND W.type_id = 1) OR (W.util_id != 279667 AND W.type_id = 2)) AND (`post_util_id` = 279667 OR `dest_util_id` = 279667) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=279667 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 182254 AND W.type_id = 1) OR (W.util_id != 182254 AND W.type_id = 2)) AND (`post_util_id` = 182254 OR `dest_util_id` = 182254) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=182254 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 182254 AND W.type_id = 1) OR (W.util_id != 182254 AND W.type_id = 2)) AND (`post_util_id` = 182254 OR `dest_util_id` = 182254) 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 = 182254 AND W.type_id = 1) OR (W.util_id != 182254 AND W.type_id = 2)) AND (`post_util_id` = 182254 OR `dest_util_id` = 182254) 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 = 306343 AND W.type_id = 1) OR (W.util_id != 306343 AND W.type_id = 2)) AND (`post_util_id` = 306343 OR `dest_util_id` = 306343) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=306343 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 310996 AND W.type_id = 1) OR (W.util_id != 310996 AND W.type_id = 2)) AND (`post_util_id` = 310996 OR `dest_util_id` = 310996) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=310996 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 311384 AND W.type_id = 1) OR (W.util_id != 311384 AND W.type_id = 2)) AND (`post_util_id` = 311384 OR `dest_util_id` = 311384) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=311384 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 316543 AND W.type_id = 1) OR (W.util_id != 316543 AND W.type_id = 2)) AND (`post_util_id` = 316543 OR `dest_util_id` = 316543) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=316543 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 357867 AND W.type_id = 1) OR (W.util_id != 357867 AND W.type_id = 2)) AND (`post_util_id` = 357867 OR `dest_util_id` = 357867) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=357867 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 361402 AND W.type_id = 1) OR (W.util_id != 361402 AND W.type_id = 2)) AND (`post_util_id` = 361402 OR `dest_util_id` = 361402) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=361402 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 366931 AND W.type_id = 1) OR (W.util_id != 366931 AND W.type_id = 2)) AND (`post_util_id` = 366931 OR `dest_util_id` = 366931) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=366931 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 385048 AND W.type_id = 1) OR (W.util_id != 385048 AND W.type_id = 2)) AND (`post_util_id` = 385048 OR `dest_util_id` = 385048) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=385048 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 385048 AND W.type_id = 1) OR (W.util_id != 385048 AND W.type_id = 2)) AND (`post_util_id` = 385048 OR `dest_util_id` = 385048) 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 = 402391 AND W.type_id = 1) OR (W.util_id != 402391 AND W.type_id = 2)) AND (`post_util_id` = 402391 OR `dest_util_id` = 402391) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=402391 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 27176 AND W.type_id = 1) OR (W.util_id != 27176 AND W.type_id = 2)) AND (`post_util_id` = 27176 OR `dest_util_id` = 27176) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=27176 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 402482 AND W.type_id = 1) OR (W.util_id != 402482 AND W.type_id = 2)) AND (`post_util_id` = 402482 OR `dest_util_id` = 402482) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=402482 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 434276 AND W.type_id = 1) OR (W.util_id != 434276 AND W.type_id = 2)) AND (`post_util_id` = 434276 OR `dest_util_id` = 434276) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=434276 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 1594 AND W.type_id = 1) OR (W.util_id != 1594 AND W.type_id = 2)) AND (`post_util_id` = 1594 OR `dest_util_id` = 1594) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=1594 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476718 AND W.type_id = 1) OR (W.util_id != 476718 AND W.type_id = 2)) AND (`post_util_id` = 476718 OR `dest_util_id` = 476718) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=476718 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 478105 AND W.type_id = 1) OR (W.util_id != 478105 AND W.type_id = 2)) AND (`post_util_id` = 478105 OR `dest_util_id` = 478105) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=478105 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 479817 AND W.type_id = 1) OR (W.util_id != 479817 AND W.type_id = 2)) AND (`post_util_id` = 479817 OR `dest_util_id` = 479817) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=479817 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 490721 AND W.type_id = 1) OR (W.util_id != 490721 AND W.type_id = 2)) AND (`post_util_id` = 490721 OR `dest_util_id` = 490721) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=490721 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 526354 AND W.type_id = 1) OR (W.util_id != 526354 AND W.type_id = 2)) AND (`post_util_id` = 526354 OR `dest_util_id` = 526354) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=526354 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 212669 AND W.type_id = 1) OR (W.util_id != 212669 AND W.type_id = 2)) AND (`post_util_id` = 212669 OR `dest_util_id` = 212669) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=212669 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='958' 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 = 175844 AND W.type_id = 1) OR (W.util_id != 175844 AND W.type_id = 2)) AND (`post_util_id` = 175844 OR `dest_util_id` = 175844) 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 = 175844
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='958' 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 = 402391 AND W.type_id = 1) OR (W.util_id != 402391 AND W.type_id = 2)) AND (`post_util_id` = 402391 OR `dest_util_id` = 402391) 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 = 402391
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='958' 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 = 43020 AND W.type_id = 1) OR (W.util_id != 43020 AND W.type_id = 2)) AND (`post_util_id` = 43020 OR `dest_util_id` = 43020) 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 = 43020
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='958' 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 = 1594 AND W.type_id = 1) OR (W.util_id != 1594 AND W.type_id = 2)) AND (`post_util_id` = 1594 OR `dest_util_id` = 1594) 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 = 1594
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='958' 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 = 141769 AND W.type_id = 1) OR (W.util_id != 141769 AND W.type_id = 2)) AND (`post_util_id` = 141769 OR `dest_util_id` = 141769) 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 = 141769
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='1092' 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 = 478105 AND W.type_id = 1) OR (W.util_id != 478105 AND W.type_id = 2)) AND (`post_util_id` = 478105 OR `dest_util_id` = 478105) 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 = 478105
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='958' 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 = 84204 AND W.type_id = 1) OR (W.util_id != 84204 AND W.type_id = 2)) AND (`post_util_id` = 84204 OR `dest_util_id` = 84204) 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 = 84204
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='958' 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 = 490721 AND W.type_id = 1) OR (W.util_id != 490721 AND W.type_id = 2)) AND (`post_util_id` = 490721 OR `dest_util_id` = 490721) 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 = 490721
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='958' 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 = 127842 AND W.type_id = 1) OR (W.util_id != 127842 AND W.type_id = 2)) AND (`post_util_id` = 127842 OR `dest_util_id` = 127842) 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 = 127842
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='1020' 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 = 476718 AND W.type_id = 1) OR (W.util_id != 476718 AND W.type_id = 2)) AND (`post_util_id` = 476718 OR `dest_util_id` = 476718) 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 = 476718
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='958' 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 = 105028 AND W.type_id = 1) OR (W.util_id != 105028 AND W.type_id = 2)) AND (`post_util_id` = 105028 OR `dest_util_id` = 105028) 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 = 105028
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='958' 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 = 120445 AND W.type_id = 1) OR (W.util_id != 120445 AND W.type_id = 2)) AND (`post_util_id` = 120445 OR `dest_util_id` = 120445) 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 = 120445
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='958' 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 = 526354 AND W.type_id = 1) OR (W.util_id != 526354 AND W.type_id = 2)) AND (`post_util_id` = 526354 OR `dest_util_id` = 526354) 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 = 526354
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='958' 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 = 65684 AND W.type_id = 1) OR (W.util_id != 65684 AND W.type_id = 2)) AND (`post_util_id` = 65684 OR `dest_util_id` = 65684) 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 = 65684
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='958' 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 = 107950 AND W.type_id = 1) OR (W.util_id != 107950 AND W.type_id = 2)) AND (`post_util_id` = 107950 OR `dest_util_id` = 107950) 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 = 107950
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='958' 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 = 279667 AND W.type_id = 1) OR (W.util_id != 279667 AND W.type_id = 2)) AND (`post_util_id` = 279667 OR `dest_util_id` = 279667) 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 = 279667
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='958' 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 = 385048 AND W.type_id = 1) OR (W.util_id != 385048 AND W.type_id = 2)) AND (`post_util_id` = 385048 OR `dest_util_id` = 385048) 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 = 385048
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='958' 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 = 385048 AND W.type_id = 1) OR (W.util_id != 385048 AND W.type_id = 2)) AND (`post_util_id` = 385048 OR `dest_util_id` = 385048) 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 = 385048
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='958' 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 = 259014 AND W.type_id = 1) OR (W.util_id != 259014 AND W.type_id = 2)) AND (`post_util_id` = 259014 OR `dest_util_id` = 259014) 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 = 259014
SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND ss.cate_id=229 AND ss.fami_id=3 ORDER BY ssrubr_order LIMIT 6,100
SELECT ss.fami_id, fami_url, ss.cate_id, cate_title_slug, keywords_title FROM `ssrubr_keywords` sk, ssrubr ss, category c, family f WHERE sk.ssrubr_id=ss.ssrubr_id AND ss.cate_id=c.cate_id AND c.fami_id=f.fami_id AND (ssrubr_slug='course; aide aux courses' OR ssrubr_slug like '%course; aide aux courses%' OR MATCH (ssrubr_slug) AGAINST ('(+course; +aide +aux +courses)')) AND sk.ssrubr_id='958' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10
SELECT * FROM actu WHERE ssrubr_id='958' 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