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