Discuter
Description de l'annonce
Recherche location de tondeuse à gazon #tondeuse
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Recherche location de tondeuse à gazon #tondeuse
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.
Réserver maintenant !
Prix estimé
20€
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='489304'
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 filtre_dpt='02'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='322490' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 322490
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 = 489304
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=5 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='489304'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='489304' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 322490 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=322490 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 = 322490 AND W.type_id = 1) OR (W.util_id <> 322490 AND W.type_id = 2)) AND (M.post_util_id = 322490 OR M.dest_util_id = 322490) 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='322490' 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 = '489304'
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='322490' AND wish_id<>'489304' 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='02590'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.8*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.8*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.15- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.350339197041 AND ville_latitude_deg<50.249660802959 AND ville_longitude_deg>2.4533386578814 AND ville_longitude_deg<3.8466613421186 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 ('02590','02590','02590','02590','02590','02590','02480','02590','02480','02590','02590','02590','02590','02480','02680','02790','02640','02490','02640','02480','02680','02680','02590','80400','02680','02480','02490','02480','80400','02760','80400','02490','02490','80400','02680','02430','02760','80200','80400','02480','02480','80200','80400','02440','80400','80240','02520','02490','02690','02440','80400','02100','80400','02480','02100','02480','80400','02300','80240','80200','02100','80400','80190','80240','02490','02440','02440','02690','02100','80400','80240','02490','60640','02300','02490','80200','80190','80200','02100','60640','02440','02100','80400','02440','80200','80190','02700','02100','80400','02440','02240','80190','02240','80190','80190','80200','02490','02420','02720','80190','60640','80240','02300','02490','80240','02100','60640','80400','80240','60640','80200','80400','80200','02420','02700','80240','02700','02720','02240','02610','80190','02300','02420','80240','02300','80400','02800','80200','80200','80190','80190','02240','02100','02100','80190','60640','80200','02420','02240','02420','80200','80190','02240','80400','02240','02420','60640','02420','02720','80190','60640','02240','80200','02420','80240','02300','60640','60640','02420','60640','02100','80200','80930','80400','80320','80190','02240','02800','80200','80320','02240','80200','80240','02420','60640','02700','80240','80240','02300','80190','02800','02110','02240','02300','02300','80320','02420','80740','80200','02300','80200','80190','80112','80240','02420','02420','02300','80320','02110','80200','02800','02110','80200','02300','02800','80190','80200','02800','60640','80700','80700','60640','80190','80200','60400','02110','60310','60310','02300','80740','02300','02110','80700','80190','02300','60400','02700','80320','80320','02240','80240','60400','80200','02240','80320','02390','80240','02420','02300','02390','80700','80200','02110','02110','02700','02240','60640','60310','02420','02800','02800','80700','60400','80320','80320','80700','80200','60310','02800','80240','02390','60400','60400','02800','80760','60400','80122','02420','80700','60400','02300','02110','02700','02300','60400','02700','02110','60310','80200','60400','80700','02800','80320','80320','02240','60400','80200','80700','80200','02230','02390','80200','80240','59297','02300','02300','02110','02120','80700','60400','02800','60310','02800','80200','02110','02240','60310','60400','02800','02270','59266','80700','02800','80200','80320','80360','60400','02300','80200','02420','80200','02120','80700','80980','60400','60400','80700','80320','80170','80360','02700','80700','59231','80360','02300','02110','02410','59231','60310','02800','59266','80700','59142','80340','80340','80700','02270','60310','80170','60400','80340','80360','60400','60400','02110','60400','60400','80170','02240','80700','02110','80340','80360','02410','02670','02110','80360','80700','02300','60400','60400','02300','59266','80170','60310','80700','02120','80340','59127','80360','62124','62124','59127','02270','02270','80360','02670','80700','02300','62124','80340','02120','60310','02270','02270','80360','02410','80170','02270','02110','02110','62124','60310','80700','60400','60400','80170','80360','60310','80340','80360','02300','59231','62124','60310','02300','02380','59127','02870','62147','80340','02120','60138','80700','02380','80131','59258','60400','02300','80340','80360','80700','60310','60310','02120','62450','02380','80700','02270','02870','02300','02270','59127','80131','62124','62450','80360','60170','80700','80360','60310','02320','60310','02110','59159','62124','02380','80700','80170','02300','80121','60310','02270','62124','80170','59238','02270','80910','02870','02380','59258','02630','80700','62450','80700','80700','59258','80340','80340','80300','02120','02120','80360','59137','60170','02380','02380','02120','02270','80170','80131','62124','59191','80170','80300','02630','02300','80360','59267','59159','02270','60310','02320','60400','59127','80500','62147','59241','80700','02110','02110','62450','02380','60310','02870','62124','80360','60170','62450','80170','02320','02320','60170','62147','59225','02870','80700','80300','02120','59191','02120','80340','02000','02120','80500','60170','80340','02120','59980','59980','60310','02870','80360','80910','80500','62147','02380','62450','02320','80340','02290','02270','02270','59191','62124','59400','02380','60490','59281','02320','80170','02120','60490','02270','02290','62124','80500','02380','59159','02290','62450','80300','80170','02000','60170','60170','80800','59980','60157','80300','02510','02000','62147','02120','60490','02290','02870','80500','80500','80300','02110','62450','59225','60490','62147','80118','62124','80800','02000','59400','60170','60350','80170','02270','60490','62450','60490','02320','59267','59400','60350','02290','02110','59360','60150','80300','02510','59400','59217','02270','62147','62450','80720','62450','59980','02120','02250','60150','02320','59400','62450','59360','62450','02000','62124','60150','60150','02320','60490','02290','02120','02120','80134','80500','02270','60490','02000','62450','59400','60150','59157','80810','02630','80500','62450','59980','02000','60490','80300','02000','80800','80300','02510','62159','59157','02000','80110','02250','02880','60490','59400','80110','02000','62860','02290','59267','02120','62450','80500','60350','80500','60490','02000','02270','80500','02000','60150','02290','59400','02510','80300','62450','59540','02320','02000','02000','80300','80300','62860','62159','80800','02270','80500','02110','59540','80300','02250','02250','60490','60490','59540','02000','59217','02250','02880','80720','80300','62860','59400','80300','02880','80500','80720','59540','02000','60490','60150','59360','59217','02000','02450','02450','60170','62450','60162','02250','80300','80300','59360','02290','80800','02290','60490','80500','02290','80800','02120','02880','02880','60350','02320','59554','02000','80110','80110','80110','59217','80110','60350','02200','80300','02120','02120','02120','80500','60150','02450','02880','62121','62121','59554','60490','02880','02880','02140','60350','02250','02250','80300','62121','60150','80300','59161','02200','59360','02000','62128','60162','02000','80500','80500','02880','60150','60150','02320','02450','80300','62860','59554','02880','80110','02000','02140','62159','02350','80500','59554','02840','02290','02880','80300','62121','02290','80300','60113','62860','02250','80800','80800','02120','60153','80113','59214','80500','59271','59161','60750','60200','60200','80500','80300','80500','62860','59161','60350','02200','80300','62121','59360','60420','62121','59360','80300','02140','80110','80800','60350','59360','59360','80800','80500','59161','62128','62128','02200','80380','02140','80110','02860','02120','80110','60350','02880','02450','02000','02000','80300','80500','60420','02840','02290','59265','59360','02290','60350','60420','02450','59265','80300','02860','62860','59268','59292','80500','60490','62121','02140','02140','59554','62182','02200','59277','02880','80500','02880','80300','62860','60350','60350','60113','60113','02000','02250','02250','59400','02880','80113','59730','60280','02200','80300','02860','02140','60420','60420','80500','59129','02880','62182','59141','02170','80300','62116','62128','80800','62860','02860','59188','02140','80110','02350','02140','80800','02170','02120','80110','80110','02250','02140','62182','59360','80380','02450','80300','02290','60190','62860','02290','62860','60420','60200','80800','02260','02840','02140','62128','59265','59222','02370','02000','80250','62121','80500','02350','62182','02200','59554','60350','60190','02860','02260','02200','02860','80110','62121','59730','60350','02370','02880','80500','62116','80110','80110','80800','02260','62116','59141','60190','80500','80300','02140','60190','62128','80560','02140','02200','59730','60420','02370','80560','59360','60200','60420','60420','02350','80110','80250','59141','02350','02250','59188','02860','59222','59730','02200','02200') 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<>'489304' 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=516896 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 = 516896 AND W.type_id = 1) OR (W.util_id <> 516896 AND W.type_id = 2)) AND (M.post_util_id = 516896 OR M.dest_util_id = 516896) 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 = 516896
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=506279 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 = 506279 AND W.type_id = 1) OR (W.util_id <> 506279 AND W.type_id = 2)) AND (M.post_util_id = 506279 OR M.dest_util_id = 506279) 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 = 506279
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=437493 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 = 437493 AND W.type_id = 1) OR (W.util_id <> 437493 AND W.type_id = 2)) AND (M.post_util_id = 437493 OR M.dest_util_id = 437493) 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 = 437493
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=435596 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 = 435596 AND W.type_id = 1) OR (W.util_id <> 435596 AND W.type_id = 2)) AND (M.post_util_id = 435596 OR M.dest_util_id = 435596) 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 = 435596
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=424357 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 = 424357 AND W.type_id = 1) OR (W.util_id <> 424357 AND W.type_id = 2)) AND (M.post_util_id = 424357 OR M.dest_util_id = 424357) 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 = 424357
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=423668 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 = 423668 AND W.type_id = 1) OR (W.util_id <> 423668 AND W.type_id = 2)) AND (M.post_util_id = 423668 OR M.dest_util_id = 423668) 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 = 423668
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=337759 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 = 337759 AND W.type_id = 1) OR (W.util_id <> 337759 AND W.type_id = 2)) AND (M.post_util_id = 337759 OR M.dest_util_id = 337759) 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 = 337759
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=368981 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 = 368981 AND W.type_id = 1) OR (W.util_id <> 368981 AND W.type_id = 2)) AND (M.post_util_id = 368981 OR M.dest_util_id = 368981) 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 = 368981
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=169190 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 = 169190 AND W.type_id = 1) OR (W.util_id <> 169190 AND W.type_id = 2)) AND (M.post_util_id = 169190 OR M.dest_util_id = 169190) 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 = 169190
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=83634 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 = 83634 AND W.type_id = 1) OR (W.util_id <> 83634 AND W.type_id = 2)) AND (M.post_util_id = 83634 OR M.dest_util_id = 83634) 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 = 83634
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 5
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