Discuter
Description de l'annonce
Environ 600-700 m2 proche de la brèche. Terre riche
Location à l'année #porte velo
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Environ 600-700 m2 proche de la brèche. Terre riche
Location à l'année #porte velo
Annonces similaires
Tout voirLouer un porte-velo entre particuliers ou proposer un porte-velo en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
500€
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='600686'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='porte-velo' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='722'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'porte-velo' 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='227'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='60'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='469627' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 469627
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 = 600686
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=722 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='600686'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='600686' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 469627 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=469627 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 = 469627 AND W.type_id = 1) OR (W.util_id <> 469627 AND W.type_id = 2)) AND (M.post_util_id = 469627 OR M.dest_util_id = 469627) 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='469627' 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 = '600686'
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='469627' AND wish_id<>'600686' 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='60290'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.3*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.3*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.45- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.850339197041 AND ville_latitude_deg<49.749660802959 AND ville_longitude_deg>1.7604331855909 AND ville_longitude_deg<3.1395668144091 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 ('60290','60290','60290','60140','60870','60660','60140','60180','60160','60290','60940','60100','60870','60140','60940','60550','60290','60140','60160','60660','60660','60660','60140','60290','60660','60660','60870','60250','60940','60600','60250','60250','60300','60140','60700','60840','60600','60740','60340','60600','60700','60250','60250','60600','60600','60340','60250','60600','60300','60700','60460','60700','60700','60600','60500','60250','60500','60700','60250','60730','60300','60300','60460','60600','60530','60270','60600','60190','60700','60190','60190','60530','60810','60600','60370','60250','60730','60700','60300','60600','60250','60600','60600','60190','60190','60300','60530','60510','60710','60530','60600','60730','60190','60680','60370','60530','60810','60190','60190','60820','60580','60260','60130','60410','60510','60410','60510','60130','60810','60530','60300','60370','60730','95820','60530','60710','60410','60520','60730','60540','60810','95340','60540','60430','60130','60130','60190','60430','60130','60560','60930','60134','60520','60190','60510','95270','60520','60570','60810','60190','60190','60190','95270','60126','60190','60540','60540','60680','60134','60680','60540','60130','60810','95270','60300','60130','60130','95270','95270','60410','60510','60410','60130','95270','60190','60230','60126','60570','95340','95590','60570','60880','60810','60430','95260','95270','95270','60130','95270','95470','60430','95340','60300','60300','60130','60190','60110','95260','60510','60430','60410','60430','60420','60130','60128','95590','60510','60680','95270','95470','60130','60510','60510','95660','60190','60130','95850','60110','60790','95270','60320','60130','60190','60320','60128','60190','60190','60130','95670','95270','60880','60880','60800','60610','95570','60130','60510','60510','60190','60430','60420','60510','60300','60790','60110','60430','60420','95470','95290','60190','95190','60130','60480','60950','95850','95560','60800','60110','95380','95720','60790','60420','60480','60190','60190','95690','95620','60000','60320','60320','60110','95690','60800','95590','60800','60390','60190','95470','95690','60440','60480','60440','60175','60510','60420','60480','95560','60130','95190','60130','60510','60950','95720','60149','60510','60000','95560','77230','60950','60390','60130','95380','60200','60420','95810','60113','60113','95690','95760','60420','95570','95380','60790','95570','60790','60800','60129','60480','77280','60120','60490','95720','60420','60510','95570','60120','95380','60800','60330','95430','95630','60510','60129','95460','77230','95840','95810','60280','60155','60000','60000','60790','95810','95380','60200','60113','60390','95810','60480','60420','95560','95330','60162','60119','60800','60173','60420','77990','95840','60129','60440','60129','95190','95720','60480','60480','60120','60480','60800','60480','95540','60420','60120','95640','95440','60420','60390','60480','77230','95300','60330','60420','60420','60120','95350','60150','60150','60200','77230','60200','95810','60330','77230','60150','60480','60490','60000','77230','95740','60440','60240','60119','60162','60390','60000','60240','60420','95430','60490','60490','60155','60480','77990','60120','60119','95500','95500','60390','60800','60000','60440','60120','60490','95400','95700','95200','95680','60330','95300','60240','60127','95350','60420','60420','60112','60112','60490','60480','95550','95150','95390','60240','60350','60000','60420','60120','80500','95160','95810','60150','95810','60480','60480','80500','95320','60750','77230','60127','60480','60420','60650','95580','95580','60240','60240','60240','60440','60490','60480','95500','77230','60240','60800','60490','60420','95400','60150','60112','60440','95600','60240','60490','60120','95640','60800','60480','60650','60112','95640','95410','77230','80500','60350','95170','60240','60490','60480','77178','95300','60120','95250','60150','60150','60490','60650','60240','60390','60490','60490','60360','95650','80500','60120','95230','95310','77290','95130','95640','77230','60120','60120','95500','60157','60120','95140','80500','77178','77290','77230','80500','60150','60117','60150','60240','60240','60150','95830','93380','93420','60490','60490','77230','95480','95120','95300','60650','60120','95360','95640','60620','60650','60117','77230','95520','60390','60480','60480','95880','60150','60112','60153','95830','60490','80500','95130','60120','60240','60440','60860','93430','60240','80500','60310','95218','93440','95210','60120','77165','60350','60120','60350','60390','77165','60620','60240','60490','60112','80500','95220','80500','93240','93600','93290','60240','60117','60112','60170','60120','60650','95240','77410','60360','60310','60620','60390','60310','95110','80500','95650','60240','60123','60620','60117','60860','60120','95370','60120','77165','77165','60590','93800','77410','95750','95610','77165','60620','95650','95650','80500','95000','80500','60650','95640','95640','93700','93150','80250','77139','60620','93350','80500','80250','60240','60120','02600','60360','60360','80500','93270','77165','77165','60240','77410','93210','93200','60170','60170','60350','60112','60170','95100','95450','95450','60860','93450','92390','93410','80700','95530','60310','60860','60120','60120','60310','60240','95650','95000','77122','60620','92230','02600','60123','60360','95490','60112','80500','60850','60350','77270','60650','60620','60360','60141','60350','60590','80250','77139','95450','77410','60310','80250','80250','60310','93300','93120','60120','60120','80700','95640','77410','60117','80250','60350','60240','60310','80500','93190','93390','77139','60240','60360','60360','80500','78700','60170','78780','78500','60170','60590','60860','02600','60650','60620','77410','60590','02600','80500','60350','93470','77181','95280','95450','60620','60240','60170','60650','80700','60310','60310','80500','60360','95800','02600','95870','77181','80500','95750','60310','60350','60350','60112','60112','93000','93140','77910','80700','77139','95450','80250','78600','80250','93500','92270','60590','60650','93320','93340','60590','60650','95450','92600','60310','60890','80500','78570','60141','60240','92700','77410','80250','60138','60240','60620','80700','93370','93400','60690','60690','60310','60350','60350','60120','95000','60590','80500','02600','80700','60650','60400','60400','95450','77410','95450','60360','80500','92110','60170','77124','77410','77139','95420','80250','80250','60240','80500','92300','60650','80700','60360','60590','02600','60240','95180','78800','93130','93230','80250','93260','78260','80110','78570','77124','93310','93250','60850','77450','60360','60690','60240','95450','60620','60620','80500','77440','93220','77910','80700','78600','60690','80500','92250','78420','77410','60120','60650','80500','80500','95450','92400','60400','60850','02600','60310','80500','80160','60890','78740','60890','77124','60350','95420','95450','77410','60112','60170','60650','80160','77500','77440','60350','02290','60360','60310','95450','78360','60860','60400','92000','78510','78740','60350','93100','80110','92200','77177','60350','93170','93110','80250','60590','27140','80110','93360','77450','77910','60120','60240','80700','60890','60112','60400','77400','60360','80700','60360','60400','77450','60310','95450','60400','60400','80250','80700','78480','93460','60890','80700','80160','60210','60590','60310','60890','60240','60210','78955','77100','77124','77910','77400','80110','60890','75018','75013','75014','75015','75016','75017','75116','75020','75019','75003','75004','75000','75005','75001','75006','75009','75002','75008','75010','75011','75007','75012','60380','60120','02290','02600','27140','02600','95420','80500','60380','60380','95450','77145','92500','60690','60590','60650','78250','60850') AND fami_id='5' AND cate_id='227' AND type_id='1' AND ssrubr_id='722' AND wish_id<>'600686' 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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=534758 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 = 534758 AND W.type_id = 1) OR (W.util_id <> 534758 AND W.type_id = 2)) AND (M.post_util_id = 534758 OR M.dest_util_id = 534758) 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 = 534758
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=396296 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 = 396296 AND W.type_id = 1) OR (W.util_id <> 396296 AND W.type_id = 2)) AND (M.post_util_id = 396296 OR M.dest_util_id = 396296) 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 = 396296
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='722' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 396296
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=394400 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 = 394400 AND W.type_id = 1) OR (W.util_id <> 394400 AND W.type_id = 2)) AND (M.post_util_id = 394400 OR M.dest_util_id = 394400) 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 = 394400
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=382184 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 = 382184 AND W.type_id = 1) OR (W.util_id <> 382184 AND W.type_id = 2)) AND (M.post_util_id = 382184 OR M.dest_util_id = 382184) 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 = 382184
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=316270 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 = 316270 AND W.type_id = 1) OR (W.util_id <> 316270 AND W.type_id = 2)) AND (M.post_util_id = 316270 OR M.dest_util_id = 316270) 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 = 316270
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=348786 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 = 348786 AND W.type_id = 1) OR (W.util_id <> 348786 AND W.type_id = 2)) AND (M.post_util_id = 348786 OR M.dest_util_id = 348786) 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 = 348786
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=328769 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 = 328769 AND W.type_id = 1) OR (W.util_id <> 328769 AND W.type_id = 2)) AND (M.post_util_id = 328769 OR M.dest_util_id = 328769) 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 = 328769
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=274886 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 = 274886 AND W.type_id = 1) OR (W.util_id <> 274886 AND W.type_id = 2)) AND (M.post_util_id = 274886 OR M.dest_util_id = 274886) 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 = 274886
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='722' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=274916 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 = 274916 AND W.type_id = 1) OR (W.util_id <> 274916 AND W.type_id = 2)) AND (M.post_util_id = 274916 OR M.dest_util_id = 274916) 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 = 274916
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 722
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