Discuter
Description de l'annonce
Environ 2m3
A venir chercher sur place #jardin potager
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Environ 2m3
A venir chercher sur place #jardin potager
Autres annonces du voisin
Tout voirAnnonces 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é
50€
Pour appeler mon voisin & organiser le rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
SHOW TABLES LIKE 'pays'
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''
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='349870'
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='94'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='77438' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 77438
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 349870
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1173 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='349870'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='349870' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 77438 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=77438 LIMIT 1
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 77438 AND W.type_id = 1) OR (W.util_id <> 77438 AND W.type_id = 2)) AND (M.post_util_id = 77438 OR M.dest_util_id = 77438) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='77438' 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 = '349870'
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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='77438' AND wish_id<>'349870' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
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='3' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=77438 AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 77438
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='5' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 77438
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='94340'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.350339197041 AND ville_latitude_deg<49.249660802959 AND ville_longitude_deg>1.8173332105093 AND ville_longitude_deg<3.1826667894907 HAVING distance <= 50 ORDER BY distance ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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 ('94340','94210','94100','94430','94500','94000','94340','94410','94130','94380','94360','94490','94880','94880','94370','94380','94700','94350','94420','94170','94470','94120','94460','93330','94140','94510','94220','94600','94160','94300','93160','93110','93360','94450','94400','77340','94190','94440','77184','94200','94205','93460','93100','77420','94390','94310','91330','93250','77185','94320','94440','93130','93220','93170','94290','94800','94270','91560','93260','94440','93230','77680','94480','77170','91800','93340','93320','77186','77150','93140','94550','94520','94520','93000','91230','77500','93310','91200','93370','94110','77150','77200','94150','94232','94233','94235','94236','94231','94250','94230','94239','94240','94238','94237','94234','91270','77090','77183','77330','91860','75019','75009','75010','75011','75013','75014','75015','75016','75017','75020','75018','75008','75007','75006','75116','75012','91800','75001','75000','75002','75003','75004','75005','77360','93500','77177','91550','93190','93390','92120','92340','91480','91320','91210','93470','77181','77600','94260','77135','92220','92240','93270','91480','92170','77164','93150','93700','77173','77400','93120','93300','77181','91260','77170','93410','77380','77600','77600','92160','92320','92260','92330','93350','77400','77400','93400','91420','93600','77410','91450','92140','77270','91170','77600','92130','92350','92290','77400','91300','93440','91130','91000','77166','91370','93210','93200','93290','77400','92110','91380','91160','91600','91390','77600','91250','77220','92100','77600','93420','91450','93240','91350','77166','91000','91090','77127','92190','92360','95500','93450','92390','91360','92300','77400','92200','77400','95140','77144','92600','91360','91280','91160','91250','77410','91120','77220','95500','92230','77170','92800','92150','77220','93380','91700','93430','77220','92400','92210','95400','92250','77111','92270','91140','91160','77700','91570','95360','77144','77700','77550','91080','91160','93800','92370','92310','77174','91430','77290','91070','77410','77410','91700','91700','91250','91100','95500','95700','95500','92700','77390','77220','77410','92410','95880','77111','91090','95410','78140','91430','77450','91140','77700','77450','77410','92380','91240','95170','77550','95200','95400','77550','92500','91620','92420','92430','95190','95350','77700','91100','95210','95218','78220','77550','91220','91220','91310','77174','95720','77176','77700','92000','78350','77610','95100','77410','95230','77990','91310','91310','95160','77290','77410','95870','78800','91400','77610','95440','77450','77390','91620','77610','91400','91250','91830','95380','95110','77450','95380','78170','91540','91540','95350','78420','95120','77410','77230','95580','95580','77390','95720','77176','77990','77580','77450','91440','78000','77410','77390','91460','77240','91540','77230','77950','78530','78350','77860','78400','95600','77240','91310','77610','77450','77450','78150','77450','91940','95460','77230','91810','78380','78290','95380','95190','77240','95380','95130','77950','78150','77860','91190','77390','78500','91940','78117','95330','77950','78360','95720','91540','91180','95680','77390','77230','78430','77410','77230','77610','77950','91630','91710','95390','77230','78560','91290','95130','77165','91190','77610','77390','95530','91830','95380','77230','91630','77610','77310','91190','91940','95570','95190','95240','95470','95850','77310','91750','78110','77860','77580','77580','95320','78117','91290','77230','95570','77165','77165','77580','95720','77230','78600','77163','91640','77100','77390','77163','95370','77230','77165','78870','91630','77230','77350','78600','91680','78230','78160','95570','77950','95670','77124','77124','77100','77390','91610','95850','91750','78210','91630','91400','77163','77390','91520','91340','77580','95470','78750','77310','78280','77000','77000','95270','91770','77350','77390','78590','78100','78470','95560','78620','95250','95560','78114','95270','77350','77720','91630','77950','77390','91640','77100','95570','95220','78330','78112','95560','78590','77190','95150','95550','77115','95840','91750','95470','78960','95270','95270','95470','95270','77580','77230','77124','77390','91760','78470','77540','60128','77230','77165','91680','77720','77580','77515','77280','95560','77470','77000','77122','95480','77515','78180','77124','95740','91790','60330','91640','77580','91850','78460','91470','77720','91650','77115','77540','77580','91470','95270','91590','95590','77930','78390','91470','95840','77000','91730','95270','78450','78700','91650','91470','95270','91590','78860','91640','91510','77720','91510','78240','60950','95270','60128','77190','77930','77470','78300','78470','77131','60330','77720','77470','77540','77515','78190','78260','77470','77910','91650','77178','95540','77470','91590','77820','77910','77540','91470','91530','78240','91840','60560','77930','60520','77580','91890','77930','77178','77470','78570','91910','91730','78460','77580','91730','77165','77165','78340','77515','95610','77930','78955','95590','77590','77139','78450','78720','95270','95430','77720','95630','95430','91590','77131','60330','95270','78780','77910','77540','60580','91490','95270','77470','60520','77930','77120','77515','77540','60260','91580','77120','78720','60520','91590','77120','95310','91530','77630','77910','78810','78570','78320','95000','60950','95590','78830','77590','91470','95760','60330','78630','77820','91580','78720','77540','78670','78670','95290','95260','91580','77590','78370','95300','78990','91590','77720','77580','60950','78320','77120','77139','95260','91590','77720','95620','91490','77139','95000','60440','91490','91530','77630','77660','95660','60440','77720','91580','78320','91580','91820','95300','77440','95280','77720','78720','78510','78830','91590','78540','77820','91820','78810','77370','60820','91580','95340','78121','77139','91530','77120','95300','95490','78310','95820','60300','60300','77440','78480','91410','77920','60440','60270','78850','77120','78310','77370','77660','77630','95340','91880','95520','91720','60440','77370','77850','95690','95000','77440','78640','78760','77440','77640','78630','78640','60300','77120','60300','95300','78720','60440','60500','60300','60300','91490','60500','78580','95650','60230','77141','91150','77133','95180','95800','60300','78730','78730','78690','95650','95690','95650','78640','77120','77870','91720','91410','78130','60530','78690','60300','60460','95340','77260','77260','78920','77440','77440','78740','95690','77970','77440','77440','77133','77370','91410','77260','91490','77210','77169','77139','78640','78490','95810','78580','60740','95690','77370','78610','78650','60340','60530','60620','77300','78740','60340','77120','77440','60300','77370','77210','78124','95810','91150','60620','77830','60440','60530','78410','78124','78490','78490','91150','60620','95450','60300','60810','77169','78125','91870','77370','78130','60440','77510','60460','78120','77123','60300','91150','60530','95650','60620','95650','91720','91720','60810','78580','77640','95810','91410','77970','60440','78490','95450','77440','77120','78610','78650','60530','77145','78250','78730','60540','60540','77810','95450','91410','78490','78250','77260','78580','77370','60620','60810','95810','77830','77430','77830','77320','78126','60620','95830','78410','78730') AND fami_id='5' AND cate_id='88' AND type_id='1' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='1173' AND wish_id<>'349870' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC 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=546277 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 546277 AND W.type_id = 1) OR (W.util_id <> 546277 AND W.type_id = 2)) AND (M.post_util_id = 546277 OR M.dest_util_id = 546277) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 546277
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=542869 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 542869 AND W.type_id = 1) OR (W.util_id <> 542869 AND W.type_id = 2)) AND (M.post_util_id = 542869 OR M.dest_util_id = 542869) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 542869
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=464984 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 464984 AND W.type_id = 1) OR (W.util_id <> 464984 AND W.type_id = 2)) AND (M.post_util_id = 464984 OR M.dest_util_id = 464984) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 464984
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=438534 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 438534 AND W.type_id = 1) OR (W.util_id <> 438534 AND W.type_id = 2)) AND (M.post_util_id = 438534 OR M.dest_util_id = 438534) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 438534
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=343724 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 343724 AND W.type_id = 1) OR (W.util_id <> 343724 AND W.type_id = 2)) AND (M.post_util_id = 343724 OR M.dest_util_id = 343724) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 343724
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=336645 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 336645 AND W.type_id = 1) OR (W.util_id <> 336645 AND W.type_id = 2)) AND (M.post_util_id = 336645 OR M.dest_util_id = 336645) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 336645
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=297392 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 297392 AND W.type_id = 1) OR (W.util_id <> 297392 AND W.type_id = 2)) AND (M.post_util_id = 297392 OR M.dest_util_id = 297392) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 297392
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=295288 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 295288 AND W.type_id = 1) OR (W.util_id <> 295288 AND W.type_id = 2)) AND (M.post_util_id = 295288 OR M.dest_util_id = 295288) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 295288
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=291965 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 291965 AND W.type_id = 1) OR (W.util_id <> 291965 AND W.type_id = 2)) AND (M.post_util_id = 291965 OR M.dest_util_id = 291965) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 291965
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=180167 AND note_visu IN (1,3,4)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 180167 AND W.type_id = 1) OR (W.util_id <> 180167 AND W.type_id = 2)) AND (M.post_util_id = 180167 OR M.dest_util_id = 180167) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 180167
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1173
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 AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)
Contactez-nous