Discuter
Description de l'annonce
Bonjour, je recherche un motoculteur ou motobineuse pour une durée de 2 jours sur Maiche. #motoculteur
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Bonjour, je recherche un motoculteur ou motobineuse pour une durée de 2 jours sur Maiche. #motoculteur
Annonces similaires
Tout voirLouer un motoculteur entre particuliers ou proposer un motoculteur 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='419584'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='motoculteur' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='3'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'motoculteur' 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='25'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='242074' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 242074
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 = 419584
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=3 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='419584'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='419584' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 242074 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=242074 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 = 242074 AND W.type_id = 1) OR (W.util_id <> 242074 AND W.type_id = 2)) AND (M.post_util_id = 242074 OR M.dest_util_id = 242074) 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='242074' 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 = '419584'
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='242074' AND wish_id<>'419584' 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='25120'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.2667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.2667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.78333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>46.817039197041 AND ville_latitude_deg<47.716360802959 AND ville_longitude_deg>6.1206800692086 AND ville_longitude_deg<7.4459799307914 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 ('25120','25120','25120','25120','25190','25120','25380','25190','25190','25470','25140','25140','25380','25190','25140','25120','25470','25380','25190','25210','25190','25190','25190','25190','25380','25450','25210','25380','25470','25470','25380','25380','25190','25190','25190','25190','25470','25380','25190','25210','25190','25190','25380','25470','25190','25380','25470','25380','25190','25470','25430','25470','25210','25150','25140','25470','25380','25380','25190','25310','25190','25310','02336','25150','25150','25150','02354','02340','25190','25210','25210','25470','25310','02914','25430','25210','25210','25430','25210','25150','25150','02338','25430','02912','25430','25210','25310','02353','25210','25430','25210','02333','25250','02338','25310','25430','25150','02345','02912','25150','25210','25470','02345','25210','25310','02300','02325','25510','25150','25310','02300','25210','02908','02333','02350','25310','25500','02610','25510','25700','25250','25250','02616','25190','02301','02303','02304','02907','02360','25150','25390','25430','25430','02345','02616','25390','02363','02887','25310','02615','02610','25500','25350','25500','02322','02610','25190','25340','25430','25390','02615','25230','25340','25310','02906','25390','25260','02916','02362','02416','25390','25430','25260','02722','25510','25420','02723','25250','25420','02054','25420','25700','02610','25530','25260','25260','02613','02612','25340','02886','25250','25230','02362','02052','02904','25500','02058','25260','02714','02400','02400','02608','02889','25230','25340','25130','25250','90100','25530','25390','25390','25420','25430','25400','25550','25400','25250','90500','02314','25340','25510','02905','25250','25250','02052','02053','25340','02915','25510','25390','02054','25340','25530','25250','25360','02903','25530','25510','02056','02720','25500','25250','02364','25230','02057','02208','02607','25420','02718','25630','25340','02714','25550','90500','25340','90100','90100','25550','25400','25510','02400','02885','25400','02608','25360','02046','25250','25113','25460','02902','25250','02063','25110','25340','25250','02888','02518','02065','25260','25110','25530','02922','02043','02900','02900','02900','02720','25530','25250','02073','25490','25200','02206','25550','02063','02523','25600','25600','25690','25110','25550','02606','02316','25490','02063','25500','90100','02718','02067','25110','25110','25690','02713','02873','25250','90100','02884','25500','02063','02414','02950','02923','25250','25110','25750','25490','25530','25340','02207','02882','02882','25340','25110','02042','25530','25250','02925','25550','02712','02717','25200','02405','02926','25550','25200','25550','25600','02950','02517','02037','25360','25530','25600','25690','25530','02072','02717','25110','90100','02715','02883','02019','02088','02001','02002','02010','25750','25490','02855','25530','25250','02710','02034','25340','25570','02605','02932','90120','02525','02087','02715','25690','02037','02534','02942','25360','70400','02515','02316','02318','25360','25530','02035','25550','02732','02924','25530','25110','02068','25250','25750','25750','25600','25340','02520','02516','02075','02036','02952','25110','02716','25110','02019','70400','25650','03238','25530','02863','02732','02000','02075','02933','02074','25250','02514','25690','25110','02014','90120','70110','70110','70400','90100','25250','90100','02732','70400','70400','90700','02933','02406','02149','90100','90100','02513','90100','02604','70400','25360','02012','02149','02856','25750','02013','70110','25340','90400','02943','25110','90600','70110','03235','02074','02946','25340','25790','25580','02534','02954','02732','02953','25800','90140','02017','02149','03233','70400','02512','25360','25110','02532','70400','70400','90140','25360','70400','70400','90400','02854','70400','02532','02406','70110','25110','90400','02733','25800','02103','90140','02748','70400','90400','70110','90100','25110','02857','02505','25110','70400','90400','25340','90370','02406','02748','03234','02935','25680','02105','02944','25680','02533','25580','02015','02735','70400','90140','03236','25680','25680','25360','02953','25800','25110','02735','02947','90800','70400','90100','90800','90800','02535','25110','70400','25650','70110','70400','90400','02502','68480','25680','02603','25110','25680','25680','02016','90400','25110','90400','90100','90100','25360','25680','90140','02572','02500','02501','02576','02563','25680','25680','02575','02560','90100','02735','25640','25650','02853','02023','02864','02572','02803','01588','02022','03232','02807','25650','02500','02500','90400','70110','25110','25680','68480','02575','01589','02503','25520','02575','25580','70110','70110','03237','68480','02536','70110','90140','25580','25680','70400','90800','68480','25110','02124','02802','70400','90850','02564','70400','90400','70110','02504','90340','68480','25650','03272','25640','01568','02406','25680','02736','02562','02735','02108','02027','02537','25360','03274','25360','90100','25650','02742','25360','02555','90130','25640','70400','90100','68480','25680','02577','25580','25680','02577','01789','25580','25580','70400','03274','90850','03225','25680','70200','02024','90340','25640','25640','01544','03226','02807','02852','25580','03272','70110','68580','25640','70110','25580','90100','25680','02025','02565','90000','02113','70110','02558','01587','01786','03274','01545','01787','25820','02552','25640','25680','25360','90160','70200','90130','70110','01567','25650','25640','70110','01787','70400','90340','01585','70110','25640','02027','68210','02112','90130','02538','02127','01586','01428','25640','02542','01585','68580','25640','25640','70110','68580','68480','02553','68480','25680','68580','68580','25360','70400','90300','01788','25520','02843','01787','25640','02557','70400','03283','25620','03273','01428','03252','25680','25680','02800','02800','02800','70110','25650','02842','01475','70200','68210','68210','02123','01587','70400','68580','03282','25300','01584','02556','02806','25640','25640','02740','01585','70110','25580','70230','70230','68480','02556','02738','70230','90160','01475','03285','70230','02114','03284','90150','90150','70230','25520','70110','68580','68210','02812','70110','02028','68580','70200','90160','01566','25960','25520','02830','70230','01566','25580','01565','68210','70200','02813','03286','70400','03210','03283','03294','02554','03280','25640','25580','25640','70230','70230','68480','03292','70110','25620','68210','90300','70200','70200','03216','70230','68210','68580','03280','70200','02543','03270','68210','90300','25580','70200','70200','90150','01543','25360','01470','90300','02762','02830','90350','03250','03293','25580','03263','90380','02126','01595','68210','68480','01423','01565','01426','03280','25640','90150','90150','68480','70200','03271','01453','68210','70200','90150','02822','02540','02540','70200','68210','70110','70400','01580','25300','03294','03207','01475','01542','90150','25640','01473','02116','03215','02115','90300','68480','03208','02814','25620','25920','02744','25580','68640','70110','25930','03216','25640','25520','01796','25640','25640','02743','25580','25620','68210','25520','01595','01797','03266','02805','70200','90150','90150','03257','03264','01423','01426','03036','03207','03206','25220','01425','70230','68480','01541','03215','03215','68480','25220','70200','03268','68210','70230','25220','70230','01541','70190','03262','01423','01794','25640','25640','01423','70200','68210','90300','01563','25840','01564','90150','01583','25300','02832','90300','90150','02823','01427','02544','70230','70200','01474','68560','68210','68210','01580','01795','25111','70190','01470','02745','01473','03206','70200','90150','01541','70190','03267','25620','03214','01424','03206','01785','68480','25330','25220','70000','68640','03257','25620','01421','03295','01562','03253','03035','70250','68480','01793','68210','25640','70110','68118','68560','70230','25840','01483','01453','70110','70290','02824','70200','90170','25300','25640','01468','01470','01421','68560','01580','90110','03298','70230','70200','68480','68210','25620','90150') 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='3' AND wish_id<>'419584' 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='3' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=501420 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 = 501420 AND W.type_id = 1) OR (W.util_id <> 501420 AND W.type_id = 2)) AND (M.post_util_id = 501420 OR M.dest_util_id = 501420) 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 = 501420
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=498915 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 = 498915 AND W.type_id = 1) OR (W.util_id <> 498915 AND W.type_id = 2)) AND (M.post_util_id = 498915 OR M.dest_util_id = 498915) 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 = 498915
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=441534 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 = 441534 AND W.type_id = 1) OR (W.util_id <> 441534 AND W.type_id = 2)) AND (M.post_util_id = 441534 OR M.dest_util_id = 441534) 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 = 441534
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=410394 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 = 410394 AND W.type_id = 1) OR (W.util_id <> 410394 AND W.type_id = 2)) AND (M.post_util_id = 410394 OR M.dest_util_id = 410394) 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 = 410394
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=341210 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 = 341210 AND W.type_id = 1) OR (W.util_id <> 341210 AND W.type_id = 2)) AND (M.post_util_id = 341210 OR M.dest_util_id = 341210) 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 = 341210
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=331480 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 = 331480 AND W.type_id = 1) OR (W.util_id <> 331480 AND W.type_id = 2)) AND (M.post_util_id = 331480 OR M.dest_util_id = 331480) 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 = 331480
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=279160 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 = 279160 AND W.type_id = 1) OR (W.util_id <> 279160 AND W.type_id = 2)) AND (M.post_util_id = 279160 OR M.dest_util_id = 279160) 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 = 279160
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=241124 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 = 241124 AND W.type_id = 1) OR (W.util_id <> 241124 AND W.type_id = 2)) AND (M.post_util_id = 241124 OR M.dest_util_id = 241124) 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 = 241124
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=229994 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 = 229994 AND W.type_id = 1) OR (W.util_id <> 229994 AND W.type_id = 2)) AND (M.post_util_id = 229994 OR M.dest_util_id = 229994) 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 = 229994
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=160839 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 = 160839 AND W.type_id = 1) OR (W.util_id <> 160839 AND W.type_id = 2)) AND (M.post_util_id = 160839 OR M.dest_util_id = 160839) 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 = 160839
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 3
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