Location tondeuse
Prix
30€/jour
Description
Particulier cherche location tondeuse à gazon tractée pour qq jours, ( la mienne est en réparation) #tondeuse
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Prix
30€/jour
Particulier cherche location tondeuse à gazon tractée pour qq jours, ( la mienne est en réparation) #tondeuse
-150kg
qu'à l'achat
2x moins cher qu'en magasin
Annonces 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='485351'
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('59' 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='81701' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 81701
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 = 485351
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=5 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 81701 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='485351'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='485351' 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=81701 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 = 81701 AND W.type_id = 1) OR (W.util_id <> 81701 AND W.type_id = 2)) AND (M.post_util_id = 81701 OR M.dest_util_id = 81701) 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='81701' 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 = '485351'
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='81701' AND wish_id<>'485351' 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='59830'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.5667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.5667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.25- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.117039197041 AND ville_latitude_deg<51.016360802959 AND ville_longitude_deg>2.5420656150206 AND ville_longitude_deg<3.9579343849794 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 ('59830','59830','59780','59830','59830','59830','59780','07502','59830','07610','59152','59242','07522','59830','59152','59152','07611','07504','07522','59273','59152','59310','59262','07618','07522','59242','07506','07522','59310','59780','07501','59242','59273','07500','07620','59510','07520','59710','59390','59310','59810','07503','59510','59310','59310','07624','07620','07500','07500','59260','59710','07621','59310','59690','07620','59390','59310','07730','59790','07520','07620','59390','59235','59226','07623','59390','59710','59310','07521','59710','07730','07641','07620','59175','59115','07620','07743','07536','59370','59155','07540','07642','07548','59170','59290','07730','07743','59310','07730','59310','59551','07640','59175','59139','59246','59230','07542','07740','59230','07622','59870','59000','59800','59160','59350','59777','07540','59158','59150','07904','59491','59493','59650','59655','59551','59226','59113','07730','59870','07643','59110','59100','59239','59178','59158','07640','07531','07730','59700','59148','07730','59178','59139','59158','07740','07543','07712','07742','59239','59420','07530','59120','59133','59283','59263','59870','59520','59870','59130','59350','59261','59230','59158','07538','59320','07640','59200','59910','59178','08587','59870','59230','59194','07540','07711','62820','59147','07532','59283','07760','59870','59118','59178','59320','59147','07700','08587','59320','59133','07604','62790','59230','07533','59194','07700','59162','59147','08510','07760','59286','59870','59146','07540','08587','59112','07534','59840','59199','07604','07608','59320','59167','59320','62141','07604','07604','59211','59251','07760','59960','07760','07760','07534','59950','62590','59237','59199','59223','59250','59126','59160','62220','08510','08554','59490','59490','59320','59119','59179','59112','59182','59171','59840','59171','59320','59320','08583','59840','07906','59128','07910','62970','08510','07604','59136','08511','59272','59171','59134','62119','07910','07601','59450','59320','59185','59176','59890','59176','07911','07602','59135','08582','59184','59182','59287','08552','59553','59553','59970','08930','07904','59287','07600','59166','62950','07910','07760','07910','07910','07901','59500','08930','59135','62710','59187','07911','59580','59134','59165','62880','07750','07911','07910','59215','59590','07750','59117','59255','07603','59134','59494','59221','08551','08560','08510','07750','07750','62640','59169','59124','59163','07910','62410','59192','07971','59552','08580','59134','59274','08930','07971','59496','59195','59280','59220','62138','59560','59553','59494','07900','07900','07780','07780','59116','59580','62740','59970','59236','59930','07911','62110','09690','59278','62440','59552','59195','07750','08550','08940','59890','62880','62880','07910','59134','07904','07971','59169','59410','07911','07912','59249','59220','07971','59860','08501','59156','59280','07912','59169','59220','59560','07903','08500','62490','59174','08553','62880','59480','62112','07784','59249','08940','59496','07784','59234','62410','59169','62420','59970','07972','59172','08581','07321','07903','62138','59234','07320','08501','07972','07783','59172','09690','59151','59293','09690','09690','07911','59163','59121','62490','59880','62117','62840','07903','62410','08560','62221','62218','07972','08570','59193','59169','59282','59163','08560','62320','62320','62112','59121','08573','08581','59300','59252','07812','59252','07782','59234','07781','09600','08520','62490','62430','59111','62410','59480','08570','62320','59264','62490','59770','08530','07973','62138','59125','59151','08572','08540','07812','07321','59300','59154','62680','62490','59224','59282','59850','62840','62300','62840','62320','59243','07812','62138','59151','08957','08980','59252','62138','59247','59111','08890','07973','08880','59300','59151','59111','09690','62580','59265','08570','59233','08570','59111','07350','62580','07812','07970','08880','59151','62490','08902','07812','59990','08531','07322','08880','07812','62210','07911','08980','62300','62840','08791','09790','62860','62149','62490','59224','62580','59990','08980','09681','08531','59247','07350','59295','59295','08952','62840','59247','09700','62580','07380','62750','08953','08860','07802','07322','07890','59265','59990','07950','62149','62118','08950','59920','07801','59990','07950','59990','62136','59181','62490','07387','08792','62860','59296','07890','62118','59269','62149','09790','62580','59259','59269','09790','08710','59554','59198','59265','59141','62580','59990','07951','59227','62149','07950','07380','09790','59141','07803','62860','62860','07334','08902','62980','62136','62156','59213','07350','62580','62118','59990','07800','09680','62860','08790','62860','08710','07804','62800','59144','08950','62580','07950','08710','62860','08902','08956','62156','59213','59940','62580','62149','62860','09790','08890','62860','07387','07332','59269','08870','07332','08980','62160','62980','07890','62136','62156','59554','59400','59268','62118','07804','59265','59141','62143','07382','07334','09680','07880','59265','09700','08770','62118','09700','07387','07950','62118','07810','59253','62156','62113','62113','07350','08800','08951','59227','59227','59144','08870','59940','08793','09700','62580','08780','09771','09688','07370','62580','09700','09790','07387','07811','09660','07800','59188','62136','08980','62660','62670','07387','62160','09700','62156','59213','59213','59144','09680','62860','59188','08900','59161','59161','62153','59530','59270','59530','07387','59161','07387','07370','08870','08900','09700','08800','08900','62156','07862','62400','59554','07333','07300','07861','62400','08958','59554','59277','59144','62860','62118','07822','09870','62156','09772','62223','59144','07941','62580','59129','62113','62182','07370','07387','09770','09770','08720','59554','62114','59940','62290','07331','59294','09700','09700','62160','07330','09700','62223','07942','07870','59554','59213','59213','07940','62182','59161','62860','09700','08760','62153','62223','59270','59530','07050','07822','09660','08800','62223','09667','59570','08720','09660','09667','07863','59188','09667','07387','07301','08720','62223','09870','62860','08970','08840','59270','62400','08954','62128','59730','08900','09700','59570','07387','62144','62128','59530','08840','59144','08908','59660','59292','08920','62131','62131','09750','07860','62182','62530','59270','09700','07390','62128','59530','07340','59400','62172','09660','09660','62131','59267','59400','07387','09700','62232','07940','62223','59570','59400','07370','62232','62232','07050','08920','09660','62223','59570','59217','62350','62232','09660','07866','59530','62223','62217','59530','07822','59730','07340','07943','62128','09661','62530','59270','08850','09750','62000','07823','07390','62620','62860','08720','59730','08800','59570','62144','08920','62920','59232','59530','62128','59530','62182','09630','07050','59214','08904','07340','59730','62530','09500','07864','62232','59400','07340','07830','59400','09630','62196','59144','59270','09636','62620','59299','62860','62350','08906','62860','09800','59267','62217','07050','09870','09660','62144','59570','07870','59270','62217','59144','09750','59217','07830','09500','62128','59218','59218','59530','07012','07012','59400','59217','09630','07011','08740','62128','62199','59730','07870','07080','59218','09800','08830','62217','62217','07866','09890','62161','62161','59159','62860','62147','59570','62147','07830','59530','59530','07861','09800','09630','09570','59281','62920','08840','59570','59400','09572','62128','62350','08700','07830','62920','62620','62940','08904','62690','09500','08851','09630','08920','62350','59400','59217','09620','09630','62122','09630','09800','62128','62128','59218','08970','07870','59570','59271','62144','62620','62217','59157','62150','07050','07870','62690','08830','07080','07080','59157','09630','62000','08640','07080','62690','08700','59400','59730','09630','09620','59190','09570','62128','59270','09500','59540','09890','07830','62350','07830','07033','62690','08740','62161','59540') 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<>'485351' 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 ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=502245 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 = 502245 AND W.type_id = 1) OR (W.util_id <> 502245 AND W.type_id = 2)) AND (M.post_util_id = 502245 OR M.dest_util_id = 502245) 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 = 502245
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=219546 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 = 219546 AND W.type_id = 1) OR (W.util_id <> 219546 AND W.type_id = 2)) AND (M.post_util_id = 219546 OR M.dest_util_id = 219546) 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 = 219546
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=442520 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 = 442520 AND W.type_id = 1) OR (W.util_id <> 442520 AND W.type_id = 2)) AND (M.post_util_id = 442520 OR M.dest_util_id = 442520) 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 = 442520
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=433593 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 = 433593 AND W.type_id = 1) OR (W.util_id <> 433593 AND W.type_id = 2)) AND (M.post_util_id = 433593 OR M.dest_util_id = 433593) 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 = 433593
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=431562 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 = 431562 AND W.type_id = 1) OR (W.util_id <> 431562 AND W.type_id = 2)) AND (M.post_util_id = 431562 OR M.dest_util_id = 431562) 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 = 431562
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=416597 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 = 416597 AND W.type_id = 1) OR (W.util_id <> 416597 AND W.type_id = 2)) AND (M.post_util_id = 416597 OR M.dest_util_id = 416597) 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 = 416597
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=145079 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 = 145079 AND W.type_id = 1) OR (W.util_id <> 145079 AND W.type_id = 2)) AND (M.post_util_id = 145079 OR M.dest_util_id = 145079) 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 = 145079
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=335381 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 = 335381 AND W.type_id = 1) OR (W.util_id <> 335381 AND W.type_id = 2)) AND (M.post_util_id = 335381 OR M.dest_util_id = 335381) 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 = 335381
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=278744 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 = 278744 AND W.type_id = 1) OR (W.util_id <> 278744 AND W.type_id = 2)) AND (M.post_util_id = 278744 OR M.dest_util_id = 278744) 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 = 278744
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=251012 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 = 251012 AND W.type_id = 1) OR (W.util_id <> 251012 AND W.type_id = 2)) AND (M.post_util_id = 251012 OR M.dest_util_id = 251012) 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 = 251012
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