Discuter
Description de l'annonce
Bonjour, je recherche un déshumidificateur car mes murs sont à plus de 90%. Pièce de 50M2.
Merci
#deshumidificateur
Indiquer un code postal ou une ville
Poster une annonce
Discuter
Bonjour, je recherche un déshumidificateur car mes murs sont à plus de 90%. Pièce de 50M2.
Merci
#deshumidificateur
Annonces similaires
Tout voirLouer un deshumidificateur air entre particuliers ou proposer un deshumidificateur air en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
75€
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='533297'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='deshumidificateur' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='775'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'deshumidificateur' 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='87'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='381696' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 381696
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 = 533297
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=775 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='533297'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='533297' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 381696 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 381696 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 = 381696 AND W.type_id = 1) OR (W.util_id != 381696 AND W.type_id = 2)) AND (`post_util_id` = 381696 OR `dest_util_id` = 381696) 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='381696' 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 = '533297'
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='381696' AND wish_id<>'533297' 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='78430'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.11667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.417039197041 AND ville_latitude_deg<49.316360802959 AND ville_longitude_deg>1.4330937413096 AND ville_longitude_deg<2.8002462586904 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 (78430,78290,78380,78560,78160,78750,78400,78170,78870,78620,78110,78150,78230,78112,78590,78100,78150,92380,92430,92420,78360,78590,92500,78240,92000,92410,78420,78330,78000,78860,78600,92210,78240,78450,78800,92310,78210,78220,92800,92150,78300,78140,78600,92370,78450,95870,78390,92250,92100,78500,92400,78810,78955,92200,78350,78530,78630,92190,92360,92700,78340,78260,78280,78350,95530,92270,92130,78670,78670,78190,78180,92300,78117,78700,92140,92600,78370,78810,95100,78570,78121,95370,78960,92110,92170,92320,78570,95240,92350,92240,78850,78540,95110,78117,91570,78780,95220,78114,91400,78630,92230,78990,92260,92330,92220,78510,95130,78470,92290,78580,92120,91430,78480,93400,78640,95210,95218,78470,91430,91190,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,95610,91190,93800,78640,94250,95120,91370,95000,95480,95130,78920,78130,78580,92390,93450,94110,95280,95250,78320,92340,78640,95880,78760,94240,94230,94231,94232,94233,94234,94235,94236,94237,94238,94239,78124,78650,78310,78320,95230,78124,92160,78470,95000,95000,91440,78640,94270,93200,93210,78460,91400,95600,91300,95180,95320,91120,93430,78410,95490,78310,94260,78580,94800,95150,95550,78740,95390,95580,95580,78580,93120,93300,94200,94205,95360,95310,94550,95800,78720,95300,91940,91190,95170,78490,78720,78740,95680,78320,93310,78130,91940,78126,91140,91470,93500,78650,78410,93380,95410,94150,78690,78490,91160,93240,78490,78490,95650,95740,78460,78250,95160,91320,78770,93170,78770,91140,95450,78250,91400,78770,94160,95300,78410,94320,91470,95520,91940,95430,95840,78720,94220,78410,78410,94400,78250,91380,91160,78250,78690,95540,95650,95560,93350,78770,93100,91160,94140,93260,93230,78770,94300,95350,95450,78680,93440,95840,78490,78490,78490,95350,78250,91470,91640,78490,94700,95650,95330,78770,95570,91420,78490,94310,94390,78820,95400,95200,95140,91470,94600,93000,91550,78720,95430,95630,78580,78610,91160,95400,93700,93150,95650,95650,91620,94410,95440,78770,93130,78970,95500,95570,93140,95450,95560,95300,95300,95450,95450,95460,78930,94340,78440,91620,94290,95570,95560,78930,91360,91200,95760,78940,93110,78250,94120,78610,95590,94130,78490,94000,91460,91360,78890,95450,91700,94480,95500,91640,91470,78440,91640,95810,91390,91600,93250,78910,94170,78125,95450,95560,78440,91310,91310,91260,78790,78790,78910,78440,78830,78440,95720,94190,78720,91310,95720,94460,95830,95620,78610,91270,95450,95450,78930,78940,94100,94210,94340,78440,95720,94380,95830,95290,78830,91240,78910,93360,78790,91310,93320,93340,94360,78440,95500,91560,91170,78440,95810,91640,95690,91680,94500,91210,95810,95690,94430,95450,95570,91680,95720,91700,95190,93220,93330,78610,95500,78930,91230,93600,94450,78910,95450,95590,78520,78490,95270,95270,91350,95660,78440,78930,91180,78200,78711,78930,78930,93270,95450,91220,91220,91530,95810,95690,95260,78910,95450,95810,95690,91470,95190,91700,78120,78790,78910,94350,78200,95450,95640,95640,95260,94470,95850,78120,78790,93190,93390,95640,91520,91340,93420,94370,94380,95590,95270,78440,91000,91130,91330,78440,95700,93460,95510,95190,95640,93160,78730,78730,91290,95640,94490,94880,94880,78790,93370,95420,95340,78200,91290,94420,78200,91530,91650,95380,95270,78520,91800,91650,93410,78125,78550,91410,91070,95340,78200,78790,95270,95850,91650,91450,95640,77181,93470,95270,91080,95640,60230,91630,78950,94440,95510,95270,95380,78200,94440,93290,78550,91630,91530,95810,78200,78200,78910,95270,95810,77500,94510,78113,77420,95420,95450,78790,95640,95420,95420,95270,95270,78520,91090,91000,91860,95510,95750,78120,78200,95750,95340,78730,91790,91630,78113,95270,60240,95270,95820,91630,78200,78125,91450,77340,78910,95380,95380,91800,78111,94520,94520,77185,95420,91630,91090,95670,94440,77181,77184,60110,91530,91580,60530,95470,78980,77270,78550,78200,60119,91910,91730,60820,91410,95380,95780,60119,60540,60540,91480,91410,77177,77186,78550,78113,77170,91730,91810,95510,91250,78550,78710,95420,78125,60240,95420,78730,60530,91480,91250,77290,77990,78200,91580,78550,77360,78520,77990,78790,78910,60260,77200,60110,60240,78730,91540,78980,77410,60540,60240,60530,77150,78125,91280,78125,60119,91730,78790,78840,95470,78270,91710,77680,95510,77380,95420,78125,60540,78270,78125,91100,95420,91100,60240,78270,60240,78113,91770,77090,77183,91510,91510,78200,95420,60580,28410,77150,91540,91540,95780,95470,60530,60110,78125,60240,60175,91250,91540,95470,91580,77127,78113,28410,60240,91850,60173,91580,60460,60540,91410,60270,77400,77400,28560,28260,77600,60530,95420,60560,78980,77230,77410,28410,77330,77230,60530,77170,95420,77230,91760,78660,95710,78113,28230,78125,78125,60520,91410,28230,60110,77400,28560,95780,77600,77600,91610,60570,28260,95510,60128,77290,78840,60530,28410,60240,91410,78270,78980,60460,60240,77164,77135,78980,91580,77230,77173,77410,78980,91250,91830,60240,28410,91750,95710,78660,28210,77400,77400,27630,60240,77600,77400,77410,60340,28210,60240,28260,77410,91590,78270,60240,28210,78660,91870,77410,60149,60520,60340,77166,27620,78270,60570,60790,60128,95420,60500,77230,77550,28320,77230,77400,95710,77166,28130,60240,60730,91410,28410,78270,28260,28210,91580,77600,78660,60730,77176,77410,60500,28410,78270,27620,28410,91830,60240,60740,91590,91750,27640,28130,28210,77230,91590,78270,77144,28260,60110,28260,91150,60520,78980,60240,77230,91410,77600,60790,91150,60730,91150,78270,60240,28700,60240,91590,77230,28320,60240,77550,78270,95770,28700,60240,60660,77240,28260,77220,27540,77144,77700,28260,28500,60240,60240,27630,91590,28410,77176,77450,77280,78660,60240,60730,60240,78660,91410,91590,60300,60300,91590,28210,77111,77230,27620,28320,60660,60660,60240,27630,78660,28500,60790,27630,60430,77170,60570,91150,91780,91780,60790,60160,60790,27630,60660,60660,60250,78270,77310,77240,95770,95770,60240,77410,77700,60950,77450,60330,91410,28130,77550,91590,28210,28210,77230,60240,60730,78270,28210,27730,77410,77220,91410,27420,28320,28700,91750,60240,28210,28130,77240,77230,77410,77310,27120,77165,77220,60240,60240,77550) AND fami_id='5' AND cate_id='87' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='775' AND wish_id<>'533297' 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='775' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=2433 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 2433 AND W.type_id = 1) OR (W.util_id != 2433 AND W.type_id = 2)) AND (`post_util_id` = 2433 OR `dest_util_id` = 2433) 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 = 2433
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='775' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=222499 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 222499 AND W.type_id = 1) OR (W.util_id != 222499 AND W.type_id = 2)) AND (`post_util_id` = 222499 OR `dest_util_id` = 222499) 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 = 222499
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='775' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=410325 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 410325 AND W.type_id = 1) OR (W.util_id != 410325 AND W.type_id = 2)) AND (`post_util_id` = 410325 OR `dest_util_id` = 410325) 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 = 410325
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='775' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=417639 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 417639 AND W.type_id = 1) OR (W.util_id != 417639 AND W.type_id = 2)) AND (`post_util_id` = 417639 OR `dest_util_id` = 417639) 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 = 417639
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='775' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=198745 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 198745 AND W.type_id = 1) OR (W.util_id != 198745 AND W.type_id = 2)) AND (`post_util_id` = 198745 OR `dest_util_id` = 198745) 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 = 198745
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='775' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=207663 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 207663 AND W.type_id = 1) OR (W.util_id != 207663 AND W.type_id = 2)) AND (`post_util_id` = 207663 OR `dest_util_id` = 207663) 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 = 207663
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='775' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=31187 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 31187 AND W.type_id = 1) OR (W.util_id != 31187 AND W.type_id = 2)) AND (`post_util_id` = 31187 OR `dest_util_id` = 31187) 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 = 31187
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 775
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