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