Loue tracteur tondeuse (4h)
Prix
30€
-150kgqu'à l'achat
Description
Cherche a louer un tracteur tondeuse pour 4h maxi car le mien est en reparation #tondeuse
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Haget (32730) · publié depuis 3 mois ou +
Discuter
Prix
30€
-150kgqu'à l'achat
Cherche a louer un tracteur tondeuse pour 4h maxi car le mien est en reparation #tondeuse
Autres annonces du voisin
Tout voirAnnonces similaires
Tout voirLouer une tondeuse entre particuliers ou proposer une tondeuse en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un 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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
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='624876'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='tondeuse' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='5'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'tondeuse' 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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('32' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='506804' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 506804
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 = 624876
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=5 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 506804 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='624876'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='624876' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=506804 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 = 506804 AND W.type_id = 1) OR (W.util_id <> 506804 AND W.type_id = 2)) AND (M.post_util_id = 506804 OR M.dest_util_id = 506804) 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='506804' 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 = '624876'
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='506804' AND wish_id<>'624876' 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='5' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=506804 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 = 506804
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='32730'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((43.4017*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((43.4017*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((0.199444- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>42.952039197041 AND ville_latitude_deg<43.851360802959 AND ville_longitude_deg>-0.4194573384047 AND ville_longitude_deg<0.8183453384047 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 ('32730','32730','32730','32730','32730','65140','65140','65140','32170','32730','65140','65140','65140','65140','32230','65140','65140','32170','65220','32170','65140','65140','32230','32230','65220','65140','32230','65140','65140','65140','32170','65140','65140','65220','32230','65140','65140','65500','65350','32170','65350','65140','65140','65140','32230','32170','32170','65500','65220','65350','65140','32170','32230','65700','65140','65220','65350','65350','65350','65350','65700','65500','32170','65500','65500','65500','32170','65220','65350','65350','65500','32170','65800','65350','32170','65390','32230','65350','65220','65500','32170','32170','65220','32170','65350','65350','65390','32300','65220','65220','65700','65390','32230','65460','65220','65500','65800','32230','65350','32230','32300','65350','65700','65350','65460','65500','65220','65350','65350','65350','32320','65700','32300','65350','65500','65220','32170','65500','65220','65320','32230','65350','32230','65220','65350','65190','65700','32230','32300','32230','65320','64460','64460','32300','65350','65350','65220','64460','64460','32300','65700','32300','65700','32320','32170','65220','65700','32230','65800','65350','32230','65220','65350','64460','65490','65220','65350','64460','65190','32230','65320','65320','32300','65600','32300','32230','32300','65700','65700','65220','65600','32300','64460','65190','64460','32320','65190','65350','65190','65220','65700','65000','65190','32300','65330','32160','65320','64460','64460','64350','32300','32300','65700','32300','65320','65190','32300','32230','32160','64460','65230','65190','65190','65330','65190','65700','65700','65690','65190','64350','32320','64350','65700','65230','65500','65230','64350','32300','65690','65330','32160','65500','32300','65430','64350','32300','32230','64350','65230','65230','64350','32300','65310','32300','65330','65190','65190','64350','65690','65190','65420','64350','32300','65310','64460','32160','65360','65230','32320','65230','32300','65310','64350','32160','65360','65230','32320','65330','32300','32140','64350','32230','65320','65700','65360','64350','65190','64350','65190','64160','32140','64530','64460','65230','64350','65190','65330','32190','65360','65190','65190','65230','65290','64350','65330','64460','32160','65360','65360','65380','65190','32290','32140','65330','32300','64420','32300','65230','32160','65700','64350','65360','32300','64350','32160','32300','65330','64160','65190','65190','32160','65190','32350','32300','64350','32300','32300','65230','65290','32350','32310','65230','64160','65190','65670','65320','65360','65330','64350','32140','64350','65360','64420','65330','64160','65380','32290','65670','65700','64160','65320','32140','64420','65230','65200','32290','32190','65190','65380','65230','64350','65130','65130','32140','64160','32320','64330','65130','64350','32400','64350','32140','32290','65380','65670','65200','64350','65130','32320','64160','65670','32140','32400','32160','32350','65190','32290','65300','64330','32140','65380','65380','65200','65300','65200','65300','64330','32260','65200','65670','32400','32140','32190','65230','65200','64350','65300','64160','64160','64160','64420','65130','65230','64160','65230','64160','64330','65300','32550','32140','32400','65380','65380','64530','65230','65230','65300','32350','32190','65200','65200','64420','64330','65200','32550','65380','65100','32140','64330','65230','64530','65670','65200','32400','65130','64420','32260','65230','31350','64330','65200','65130','32140','32400','64420','65100','32290','65130','32260','65300','32400','32260','64330','64350','65130','64160','65100','65130','64160','64330','32190','64420','32400','32140','65200','64420','64530','32290','65100','31350','65300','65670','65200','65200','65130','65130','32190','32260','32260','65130','65100','64160','65200','32140','32260','65380','64330','32290','64330','32190','65130','31580','64420','64160','32110','32290','31580','32140','65130','32190','65100','32140','64420','64160','64420','65100','65300','32550','65200','65100','31580','64160','32550','65100','32400','31580','32400','31350','65200','64530','65130','64330','65100','65100','64330','31350','65200','65130','32190','32260','32350','64160','65100','65130','64160','64160','65130','65100','31580','31350','32260','64160','65100','65100','32260','65250','64330','32420','65150','32400','32190','32400','65250','65130','64320','64160','32400','32550','64160','32110','32420','64450','64800','32420','32420','65100','32400','32450','65200','65200','32420','32260','65130','64420','31350','64330','64160','32400','64800','65100','31580','65100','64160','65100','32110','32190','64330','31350','64320','65200','32110','65130','65130','65100','65250','40390','65150','32290','32550','31210','32350','64330','31580','64330','64160','64160','32400','32400','64800','64800','64800','65200','64330','64450','31350','65100','32110','64160','31580','31580','32810','31350','64510','32110','64450','65200','65710','65200','32110','65250','64320','32400','32190','32190','32400','32810','32000','65130','65130','31350','65130','64330','32420','65150','32420','65100','65250','32450','31350','32550','32370','32360','65100','65130','32400','65100','31350','65270','65150','65100','65250','32550','65100','65270','31350','32360','32190','64450','32720','40800','32810','65100','64800','65130','32190','31210','65100','65710','64510','32190','31210','65100','65100','64450','64450','64320','64510','65150','65100','65100','65150','32400','32420','65100','65250','64800','64800','64800','64320','64510','65150','31350','64800','31210','31350','32110','32110','65250','64240','32370','32360','32450','32110','64800','32800','64510','32190','64450','32800','64121','32400','65150','64510','40800','65100','64121','31350','32400','64450','65150','32110','64800','64330','65150','65250','32400','32450','64800','32190','64510','65100','31350','64450','64800','64800','32550','32110','64110','64110','65100','31350','65250','31210','32720','31350','32810','32410','64800','32360','31230','64450','65150','40390','64800','64450','32190','65400','64320','32110','31350','32360','31350','31230','64450','40800','32450','64410','40320','65150','65660','64110','65150','64450','64230','31800','40320','31210','64000','31230','64450','31230','32360','32420','65400','31800','31350','32110','32450','32720','32370','65400','64110','32370','32810','32810','65400','32360','64410','31210','32450','32370','32720','31800','64800','65150','31800','31210','64230','64110','31210','64410','31210','65150','32460','64410','32310','40320','31210','65400','31350','32420','65400','65150','65660','31510','40320','32810','65400','65400','65400','64410','31800','64140','31210','31230','32810','65400','64410','32220','64140','32410','31230','31800','64230','65400','32450','32330','40320') 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='5' AND wish_id<>'624876' 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='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 = 506804
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 ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=502162 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 = 502162 AND W.type_id = 1) OR (W.util_id <> 502162 AND W.type_id = 2)) AND (M.post_util_id = 502162 OR M.dest_util_id = 502162) 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 = 502162
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 ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=447675 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 = 447675 AND W.type_id = 1) OR (W.util_id <> 447675 AND W.type_id = 2)) AND (M.post_util_id = 447675 OR M.dest_util_id = 447675) 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 = 447675
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 ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=424332 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 = 424332 AND W.type_id = 1) OR (W.util_id <> 424332 AND W.type_id = 2)) AND (M.post_util_id = 424332 OR M.dest_util_id = 424332) 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 = 424332
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 ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=417369 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 = 417369 AND W.type_id = 1) OR (W.util_id <> 417369 AND W.type_id = 2)) AND (M.post_util_id = 417369 OR M.dest_util_id = 417369) 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 = 417369
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 ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=407168 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 = 407168 AND W.type_id = 1) OR (W.util_id <> 407168 AND W.type_id = 2)) AND (M.post_util_id = 407168 OR M.dest_util_id = 407168) 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 = 407168
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 ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=180685 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 = 180685 AND W.type_id = 1) OR (W.util_id <> 180685 AND W.type_id = 2)) AND (M.post_util_id = 180685 OR M.dest_util_id = 180685) 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 = 180685
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 ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=165752 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 = 165752 AND W.type_id = 1) OR (W.util_id <> 165752 AND W.type_id = 2)) AND (M.post_util_id = 165752 OR M.dest_util_id = 165752) 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 = 165752
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 ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=164885 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 = 164885 AND W.type_id = 1) OR (W.util_id <> 164885 AND W.type_id = 2)) AND (M.post_util_id = 164885 OR M.dest_util_id = 164885) 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 = 164885
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 ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=154670 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 = 154670 AND W.type_id = 1) OR (W.util_id <> 154670 AND W.type_id = 2)) AND (M.post_util_id = 154670 OR M.dest_util_id = 154670) 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 = 154670
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