Discuter
Description de l'annonce
Bonjour,
je cherche une enceinte en urgence. Merci.
#sono
Indiquer un code postal ou une ville
Poster une annonce
Discuter
Bonjour,
je cherche une enceinte en urgence. Merci.
#sono
Annonces similaires
Tout voirLouer une sono entre particuliers ou proposer une sono en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
50€
Pour appeler mon voisin & organiser le rendez-vous.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='379634'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='sono' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1111'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'sono' LIMIT 1
SELECT c.cate_id, c.cate_title, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='5' AND c.cate_id='208'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='95'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='196659' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 196659
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (87) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (88) ORDER BY ssrubr_order ASC
SELECT ssrubr_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 (81) ORDER BY ssrubr_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 (110) ORDER BY ssrubr_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 (227) ORDER BY ssrubr_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 (176) ORDER BY ssrubr_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 (79) ORDER BY ssrubr_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 (208) ORDER BY ssrubr_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 (228) ORDER BY ssrubr_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 (207) ORDER BY ssrubr_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 (95) ORDER BY ssrubr_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 (173) ORDER BY ssrubr_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 (83) ORDER BY ssrubr_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 (93) ORDER BY ssrubr_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 (193) ORDER BY ssrubr_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 (91) ORDER BY ssrubr_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 (232) ORDER BY ssrubr_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 (92) ORDER BY ssrubr_order ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 379634
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1111 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='379634'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='379634' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 196659 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 196659 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''
SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 196659 AND W.type_id = 1) OR (W.util_id != 196659 AND W.type_id = 2)) AND (`post_util_id` = 196659 OR `dest_util_id` = 196659) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='196659' AND note_visu IN (1,3,4)
SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '379634'
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='196659' AND wish_id<>'379634' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='95570'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.05*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.05*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.600339197041 AND ville_latitude_deg<49.499660802959 AND ville_longitude_deg>1.6472370769771 AND ville_longitude_deg<3.0194229230229 HAVING distance <= 50 ORDER BY distance ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND wish_cp IN (95570,95570,95330,95560,95570,95460,95560,95350,95560,95570,95560,95720,95270,95590,95680,95440,95720,95160,95270,95580,95580,95350,95840,95390,95720,95600,95400,95200,95320,95270,95170,95410,95850,95840,95230,95590,95720,95190,95740,95150,95550,95190,95270,95120,95130,95270,95850,95360,95880,95270,95590,93380,95270,95270,95400,95540,95210,95218,95260,95270,95270,93430,95430,95630,95270,95290,95130,95190,95250,95260,95660,95110,95140,95380,95270,95760,95500,93800,95620,95500,93240,95500,95340,95240,95470,95500,95430,95380,93440,95100,95670,95480,92390,93450,60820,95820,93200,93210,92230,95340,95370,60260,95220,95690,60230,93350,95530,95700,95380,60580,93120,93300,60530,95340,93700,93150,95870,95300,92270,78500,95380,95310,92600,95380,60270,92700,60560,95690,95690,93400,95470,92110,60460,60530,95300,92300,95470,95300,60520,93420,93500,95690,60530,78600,93600,95470,95610,78800,92250,95300,92400,95810,77990,78420,78700,60530,60540,60540,93000,60530,60128,92200,93310,60340,60460,60520,60500,92000,93140,60340,95000,77230,95520,93270,78600,95650,77990,95000,60540,93260,93230,60500,78360,78780,95810,60740,60530,93290,77230,60128,95810,78570,60540,92500,93130,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,60530,93170,60520,93320,93340,93410,78260,92800,92150,93100,93190,93390,77230,95490,95650,77290,60540,60300,60300,60110,93250,95280,95810,95810,95810,60660,78400,60110,78110,95650,78570,93110,60160,94300,77181,93470,93220,78230,93370,92170,95830,60660,60660,77230,60300,78560,95800,60660,60660,93360,77270,78300,95810,78955,95650,95650,77230,95000,92210,60300,78100,94120,92100,94160,77290,60110,78290,78380,60730,60160,60570,94170,95830,95640,78510,77181,60300,77230,95640,92380,77280,95450,95180,78430,94250,78170,92120,60180,60250,78750,77410,92240,94270,60950,60730,60730,94200,94205,92130,60570,60100,94130,60119,93460,78480,93330,94220,92430,92420,78670,78670,77230,77500,78112,60330,78740,92410,78540,95450,77230,60175,78160,77410,60300,94410,95640,78240,94360,60730,92190,92360,92310,94340,60300,77410,94110,95640,60250,92220,94800,95450,60110,77230,95450,93160,92320,60870,78620,77230,78740,92140,60660,60950,77410,60240,60300,60119,60730,94140,78240,60300,60300,95640,77177,60700,94700,78870,78150,94350,77410,60290,60550,94500,95450,78150,95450,77230,95640,95640,60290,92370,78630,77420,78590,60119,94240,94230,94231,94232,94233,94234,94235,94236,94237,94238,94239,60250,60250,60173,92260,92330,78140,92350,94400,95450,78220,94100,94210,94340,77230,60810,60330,92340,78250,78130,60810,60950,77360,60870,60570,60290,94430,78130,60149,60110,94420,60140,94000,77186,95450,60430,78000,60240,94550,77400,77230,77410,94320,95640,77185,78590,95450,77165,78250,92290,60290,60300,95750,77410,78630,60790,60870,60940,60330,94600,77200,78860,77165,78250,60250,78250,60290,78920,95450,60810,60790,60810,60940,77400,77400,77410,78410,60430,60140,60790,78330,77184,60700,60790,77165,77165,94380,60250,94260,94150,78450,78250,60250,60250,92160,60240,77400,60940,94490,94880,94880,60440,78810,77410,77400,91370,94310,94390,60290,60250,60140,78350,78580,77600,78450,60700,78210,77178,95450,77165,95450,60240,60790,60240,95450,60430,77090,77183,77340,60140,91570,60330,95450,60240,77400,78121,95750,60790,77400,77410,60240,78350,78530,94370,94380,60430,94460,77600,77600,94510,60240,77450,60810,91320,60250,78440,60440,78410,77178,78250,77410,91300,60370,60700,77600,60140,60240,60810,78810,60240,78820,60370,94290,77450,60430,94470,60240,60440,60370,60600,60700,78390,77680,91430,94190,60440,60410,95420,95450,78340,78580,78440,78410,60240,91430,60800,77144,77122,77144,77700,77600,77450,78580,95420,60810,94450,60700,78117,78280,91550,77164,60240,60600,91400,60600,91200,78440,95420,91120,94480,78126,77450,77165,77165,60140,60430,60410,60240,78850,78440,77124,60240,77700,78124,60390,60134,60600,60840,91560,60240,78440,78410,78410,78370,78580,60134,60440,78190,78180,60410,60390,60430,60700,77135,94440,60600,60800,60240,60240,95420,78124,77600,91420,78440,91380,91160,60600,91330,77450,60440,78117,60700,91160,78960,78680,60240,77450,91140,91270,77124,60930,60600,77700,60390,78640,60440,77330,91230,91190,94440,60390,78970,60800,77450,77139,95510,77139,60240,60410,60240,78114,77910,78440,91190,91400,95420,95420,77100,77124,78440,60710,60390,60800,60240,78650,77700,60510,91800,91440,78990,77124,94440,60510,77150,78470,78640,77450,60440,91260,77100,91160,95420,60510,91210,60240,60190,60000,60190,78440,77170,60190,91140,77150,60410,60430,95420,60240,60600,77910,60320,78640,60710,60190,60000,60240,60410,94520,94520,77860,78770,60680,78470,60600,60510,60240,78440,60190,77139,95510,78440,60800,91360,60240,60510,91390,91360,91600,91940,60600,95420,77700,60390,91160,91170,78580,78640,77174,77580,78770,60510,60600,91860,60240,78470,60800,60600,77860,95420,91800,91940,91190,77100,78930,78760,60126,77860,95420,78320,60240,60600,60510,78650,95510,77139,78310,60800,60620,78930,78770,60600,95510,78460,77910,60240,60320,60126,78320,60620,91940,77173,78520,91700,91480,60510,91350,60800,60240,60129,60190,60590,77470,91620,78770,77174,78490,60590,60320,60320,78770,91000,91130,78770,60390,91480,60130,91620,78520,78310,78490,60155,60620,91450,77910,78770,60190,60190,91400,77220,78200,60800,60680,60680,60390,60880,78930,77170,91470,60590,77220,95420,60590,77380,78720,78200,78711,60800,60240,60130,95420,78490,78490,77580,77580,77440,78720,95780,78520,77470,60000,60620,77139,60155,60000,91700,60130,77470,78930,91240,91700,77580,91640,78320,60620,60130,91310,60190,91310,91310,60129,78930,60610,60510,60240,78490,60190,77470,60590,78690,77580,78790,78790,91470,78460,91460,77580,77440,60240,60510,91090,91000,60390,60590,60000,60130,60130,91450,77220,60650,95710,95510,77166,60590,60190,27140,60129,60510,60390,60650,78490,60000,60510,91250,60620,95710,77220,78930,78930,77580,78490,78490,91470,78720,91220,91220,77610,78200,91070,60620,60190,91080,60190,60190,77470,60117,91310,60680,60510,77440,78840,60620,60880,60880,78790,60129,77470,60620,95780,60130,60130,78690,60240,60190,60000,77163,77127,60620,60650,91470,77166,78910,77580,78200,60510,91250,78910,78490,60620,95770,60130,77470,78790,91280,60127,60590,78270,60800,78940,78890,78200,60510) AND fami_id='5' AND cate_id='208' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='1111' AND wish_id<>'379634' AND wish_url='' ORDER BY rand() LIMIT 0,10
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='1111' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=100132 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 100132 AND W.type_id = 1) OR (W.util_id != 100132 AND W.type_id = 2)) AND (`post_util_id` = 100132 OR `dest_util_id` = 100132) 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 = 100132
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='1111' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=61204 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 61204 AND W.type_id = 1) OR (W.util_id != 61204 AND W.type_id = 2)) AND (`post_util_id` = 61204 OR `dest_util_id` = 61204) 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 = 61204
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='1111' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=106032 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 106032 AND W.type_id = 1) OR (W.util_id != 106032 AND W.type_id = 2)) AND (`post_util_id` = 106032 OR `dest_util_id` = 106032) 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 = 106032
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='1111' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=170011 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 170011 AND W.type_id = 1) OR (W.util_id != 170011 AND W.type_id = 2)) AND (`post_util_id` = 170011 OR `dest_util_id` = 170011) 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 = 170011
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='1111' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=369692 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 369692 AND W.type_id = 1) OR (W.util_id != 369692 AND W.type_id = 2)) AND (`post_util_id` = 369692 OR `dest_util_id` = 369692) 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 = 369692
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='1111' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=325063 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 325063 AND W.type_id = 1) OR (W.util_id != 325063 AND W.type_id = 2)) AND (`post_util_id` = 325063 OR `dest_util_id` = 325063) 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 = 325063
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='1111' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=219997 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 219997 AND W.type_id = 1) OR (W.util_id != 219997 AND W.type_id = 2)) AND (`post_util_id` = 219997 OR `dest_util_id` = 219997) 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 = 219997
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='1111' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=341934 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 341934 AND W.type_id = 1) OR (W.util_id != 341934 AND W.type_id = 2)) AND (`post_util_id` = 341934 OR `dest_util_id` = 341934) 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 = 341934
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='1111' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=466997 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 466997 AND W.type_id = 1) OR (W.util_id != 466997 AND W.type_id = 2)) AND (`post_util_id` = 466997 OR `dest_util_id` = 466997) 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 = 466997
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='1111' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=529114 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 529114 AND W.type_id = 1) OR (W.util_id != 529114 AND W.type_id = 2)) AND (`post_util_id` = 529114 OR `dest_util_id` = 529114) 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 = 529114
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1111
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