-500kg
qu'à l'achat
Description de l'annonce
Besoin pour 2 jours sur saint Maurice aux riche hommes
#Tracteur tondeuse
Voir les annonces autour de moi Géolocaliser
Poster une annonce
Saint-Maurice-aux-Riches-Hommes (89190) · publié depuis 3 mois ou +
-500kg
qu'à l'achat
Besoin pour 2 jours sur saint Maurice aux riche hommes
#Tracteur tondeuse
Louer un tracteur tondeuse entre particuliers ou proposer un tracteur tondeuse en location.
Poster une annonce
-500kg
qu'à l'achat
Envoyer 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, filtre_villes, dpt_url 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='349595'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='tracteur-tondeuse' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='8'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'tracteur-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('89' 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='155328' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 155328
SELECT util_cp FROM utilisateur WHERE util_id=155328 LIMIT 1
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 = 349595
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=8 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 155328 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='349595'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='349595' 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=155328 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=155328 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 = 155328 AND W.type_id = 1) OR (W.util_id <> 155328 AND W.type_id = 2)) AND (M.post_util_id = 155328 OR M.dest_util_id = 155328) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
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 = '349595'
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='155328' AND wish_id<>'349595' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (w.wish_area IS NULL OR w.wish_area='' OR w.wish_area='FR')
SELECT ssrubr_slug, ssrubr_title, 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='946' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 155328
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='89190'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.2833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.2833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.55- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.833639197041 AND ville_latitude_deg<48.732960802959 AND ville_longitude_deg>2.8742665791112 AND ville_longitude_deg<4.2257334208888 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_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('89190','10290','89190','89190','89190','10290','89190','10160','10160','89190','89190','89190','89260','10290','10290','10290','10160','89190','89190','10290','10190','89260','10160','89190','89320','89260','89260','89320','10350','10290','89190','10290','10400','10160','10290','10190','10400','10160','89760','89100','10290','10400','10400','10160','89760','10190','89760','89100','10400','89320','89320','89760','10290','89320','10190','89320','89140','89100','89100','89260','10350','10400','77480','10100','10100','10350','10160','10190','89140','89100','10100','10400','10400','10400','77480','10350','89100','10400','89320','89770','77480','77480','10190','89140','89100','89320','10190','89100','89100','10400','89140','10100','89140','10400','77480','10160','10400','89100','89140','89140','77114','89100','10190','89100','10190','89140','10190','89140','77114','10350','10160','89140','89500','10100','77480','89500','77480','89100','89770','89100','89510','10350','10400','77480','89100','10160','10190','89510','89140','10510','10400','10190','77171','10100','89140','89210','10400','89510','10100','29590','89140','10300','10100','77114','89570','10350','77480','77480','77480','89100','89210','10170','10400','10190','10400','89210','89140','10100','77171','89140','89500','89100','89210','89500','77114','89400','10400','10280','10190','29780','10400','77118','89100','77157','89500','10130','10400','89210','29830','77480','10300','51260','10130','10440','10510','89150','77134','89570','89500','51260','77650','10130','77171','89340','89570','10400','10400','89140','77650','89500','89400','89210','10130','10120','89150','77160','10510','10600','77520','89500','10170','10600','10170','29190','89500','29830','51260','89570','89330','77118','89210','89150','10320','89370','77650','29400','89140','10280','77520','77520','10130','77160','77520','77650','51260','10130','10370','51260','51260','89600','89330','10170','89300','10130','10600','10180','77118','10600','10320','10320','89720','51260','51260','89570','89300','10280','77160','10170','89500','10170','77520','89150','89150','89300','89400','89400','89300','51260','77650','77171','77130','10440','10320','10420','89140','77160','10120','10130','10170','10130','77126','89340','10600','10120','10600','77130','10170','89570','77126','89150','77650','10320','10600','77520','89340','10120','89410','10300','89400','89400','89600','10600','51260','89150','51260','51260','89250','89400','89600','89150','10150','77520','10130','51260','89330','77650','89300','77130','77520','10130','89150','89400','10320','10430','51260','10320','10320','77520','77560','77560','77160','89600','51260','77650','10130','51120','89400','77520','89150','89250','77126','89360','10170','10320','10130','77160','89330','10700','10130','89300','89300','10000','10320','10150','77940','77130','89116','51260','77940','10320','10800','51120','10320','51260','10170','10170','77160','51120','10130','89330','89150','77560','89360','89150','29990','10800','10320','10320','10800','89250','51310','51120','10150','10800','10450','89410','89400','51260','89360','10800','89113','89330','89150','77520','10800','77160','89710','89116','89113','10320','89690','10380','77940','77560','51120','10410','77560','77940','77148','77520','51260','51120','10130','10800','77130','77370','77160','89230','51310','89250','77130','89400','10800','89250','10150','10380','77160','89116','10170','51310','89550','77154','77940','89710','10800','89230','10150','77560','89360','89230','77940','51120','10800','10150','89360','89116','10800','51260','10800','10210','89710','10380','77156','10210','77148','10800','89380','77370','10170','10410','77710','10390','89113','10210','10150','89113','10800','89150','89144','51260','77160','45210','77151','45320','77370','77154','89116','89110','10170','77130','51260','77940','77560','10130','89144','51120','77710','10130','89250','45320','77370','51310','51310','89360','10150','77710','51310','77130','77560','77320','10410','10410','10150','89113','51120','77560','77940','10270','89144','77370','10700','51120','89110','45320','89230','10700','10210','10260','10210','45320','10380','51230','77130','10150','77320','51120','89110','77710','51120','45210','10700','10260','77130','89470','10270','10130','89800','10700','77710','77130','77370','10210','51230','10220','89110','89800','89800','10210','89360','89110','89230','77830','77370','89700','89120','10390','77370','51230','10700','45210','10150','77130','89120','10270','51120','10700','10210','10220','51120','89360') 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='8' AND wish_id<>'349595' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, ssrubr_title, 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='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=436813 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 = 436813 AND W.type_id = 1) OR (W.util_id <> 436813 AND W.type_id = 2)) AND (M.post_util_id = 436813 OR M.dest_util_id = 436813) 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 = 436813
SELECT ssrubr_slug, ssrubr_title, 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='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=334029 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 = 334029 AND W.type_id = 1) OR (W.util_id <> 334029 AND W.type_id = 2)) AND (M.post_util_id = 334029 OR M.dest_util_id = 334029) 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 = 334029
SELECT ssrubr_slug, ssrubr_title, 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='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=83647 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 = 83647 AND W.type_id = 1) OR (W.util_id <> 83647 AND W.type_id = 2)) AND (M.post_util_id = 83647 OR M.dest_util_id = 83647) 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 = 83647
SELECT ssrubr_slug, ssrubr_title, 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='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=248095 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 = 248095 AND W.type_id = 1) OR (W.util_id <> 248095 AND W.type_id = 2)) AND (M.post_util_id = 248095 OR M.dest_util_id = 248095) 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 = 248095
SELECT ssrubr_slug, ssrubr_title, 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='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=242304 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 = 242304 AND W.type_id = 1) OR (W.util_id <> 242304 AND W.type_id = 2)) AND (M.post_util_id = 242304 OR M.dest_util_id = 242304) 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 = 242304
SELECT ssrubr_slug, ssrubr_title, 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='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=240924 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 = 240924 AND W.type_id = 1) OR (W.util_id <> 240924 AND W.type_id = 2)) AND (M.post_util_id = 240924 OR M.dest_util_id = 240924) 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 = 240924
SELECT ssrubr_slug, ssrubr_title, 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='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=234486 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 = 234486 AND W.type_id = 1) OR (W.util_id <> 234486 AND W.type_id = 2)) AND (M.post_util_id = 234486 OR M.dest_util_id = 234486) 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 = 234486
SELECT ssrubr_slug, ssrubr_title, 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='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=197388 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 = 197388 AND W.type_id = 1) OR (W.util_id <> 197388 AND W.type_id = 2)) AND (M.post_util_id = 197388 OR M.dest_util_id = 197388) 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 = 197388
SELECT ssrubr_slug, ssrubr_title, 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='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=175915 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 = 175915 AND W.type_id = 1) OR (W.util_id <> 175915 AND W.type_id = 2)) AND (M.post_util_id = 175915 OR M.dest_util_id = 175915) 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 = 175915
SELECT ssrubr_slug, ssrubr_title, 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='8' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=173184 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 = 173184 AND W.type_id = 1) OR (W.util_id <> 173184 AND W.type_id = 2)) AND (M.post_util_id = 173184 OR M.dest_util_id = 173184) 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 = 173184
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 WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
Contactez-nous