Réserver
Description de l'annonce
MD ou Mr
Je voudrais vous louer
Pour la journée
Cordialement merci #debroussailleuse
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Réserver
MD ou Mr
Je voudrais vous louer
Pour la journée
Cordialement merci #debroussailleuse
Autres annonces du voisin
Tout voirAnnonces similaires
Tout voirLouer une debroussailleuse entre particuliers ou proposer une debroussailleuse en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
35€
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='571402'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='debroussailleuse' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='2'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'debroussailleuse' 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='76'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='431093' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 431093
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 = 571402
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=2 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='571402'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='571402' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 431093 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=431093 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 = 431093 AND W.type_id = 1) OR (W.util_id <> 431093 AND W.type_id = 2)) AND (M.post_util_id = 431093 OR M.dest_util_id = 431093) 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='431093' 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 = '571402'
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='431093' AND wish_id<>'571402' 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='601' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=431093 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 = 431093
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='76160'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.4833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.4833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.21667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.033639197041 AND ville_latitude_deg<49.932960802959 AND ville_longitude_deg>0.52452528509643 AND ville_longitude_deg<1.9088147149036 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 ('76160','76160','76160','76160','76116','76160','76750','76230','76116','76160','76160','76116','76230','76160','76160','76230','76116','76750','76160','76690','76420','76520','76750','76690','76240','76160','76240','76750','76116','76116','76520','76750','76520','76690','76116','76116','76130','76520','76690','27910','76770','76710','76240','76750','76116','76750','76690','76100','76000','76520','76690','76300','76920','27910','76690','76960','76750','76750','76710','27380','27910','76520','76690','76690','27910','76690','76780','76780','76750','76750','27910','76750','76250','76150','76780','76520','76770','76380','76680','76690','76800','76710','76770','27910','76140','76150','76150','27380','76690','76520','76520','76680','76120','76750','76750','76520','76780','76380','76690','76750','27380','76750','76780','76710','76690','76360','76850','76690','76780','76850','76680','76520','27380','27360','27610','76690','76650','27380','76570','27380','76840','76750','76680','27380','76480','76780','76840','27590','27460','27460','76410','76850','76350','76690','76680','27380','27460','76380','76680','76780','27850','76750','76410','76850','76890','27380','27480','76570','76570','27480','27790','76850','76850','27740','27340','76480','76360','76840','27590','27340','76850','76410','76680','76680','76480','76113','27440','76440','14450','27440','76530','76890','76780','76220','76780','27480','27440','76890','76890','27340','76890','76440','76570','27690','76850','76360','76780','76113','27100','76680','27440','76850','27430','76410','76440','76480','27340','27100','76440','76570','76530','27440','76780','76680','76570','76680','76890','27700','76480','76680','76480','76680','76890','27440','27700','76850','76480','76440','27700','76360','27480','27430','76680','76410','27340','76890','27480','76570','76890','76113','76530','76440','76570','76890','76530','76780','76270','76760','27440','76320','27430','27100','27430','27430','27430','76720','27310','76780','76480','76760','27150','76500','76440','76890','76530','76220','76480','76190','76270','76320','27720','27480','76480','76500','76570','76500','76890','27700','27150','27150','76720','27480','76760','27700','27430','27430','27400','76680','76480','76760','27310','76720','76440','27310','76440','76890','27150','76890','27700','76680','27150','27310','76220','76580','76720','76940','76190','76760','76440','76890','76890','76440','27370','27700','27400','76480','27670','76190','27700','27370','76440','76270','27400','76680','76590','27370','27670','27430','27150','76590','27370','76190','76220','76760','27310','27150','76440','76890','76760','27370','27370','76190','76440','76190','27150','27480','27420','76590','76270','27400','76970','76220','76270','76190','76190','27400','27350','27400','27520','76270','76270','27400','27400','76270','76590','27370','76440','27150','27310','27400','76590','27370','27150','27670','27370','27700','27700','27150','27940','76440','76970','76890','27940','27700','76890','76760','76220','27370','76440','76440','76270','27700','76270','27310','76940','27370','76940','76220','27400','76220','76190','27150','76220','76490','27370','76270','76760','27420','27370','27400','27520','27520','76950','27150','27600','76870','76590','76590','76270','76220','27350','27370','76660','27310','27400','76590','76870','76440','76190','76970','27150','76660','27520','76760','27370','76560','76190','76730','27110','76730','76890','76590','27400','27700','76220','76760','27150','27940','76940','76220','76730','27400','76970','76590','76440','76490','76560','27370','27370','27310','27150','27420','27600','76190','76590','27110','27600','76660','27600','76730','27370','27510','27150','27350','27150','76590','27600','76730','76190','27110','76560','76440','27310','27860','76220','76220','50310','76490','27350','27520','76270','76220','76440','27370','76590','76730','76220','27150','27400','76590','76730','76590','76190','27110','76510','76190','76220','76270','60850','27400','76190','76590','76510','27110','27310','27520','76730','76270','76560','76490','27520','27150','27370','76560','27700','27420','27940','27400','27600','60380','76660','27940','27110','76560','76270','27150','76390','27350','27520','76270','27510','27370','27110','76590','76590','60220','76560','76940','27420','76730','76270','76660','76220','27110','76660','27290','60380','27290','50680','76730','76270','76730','76190','27490','76560','76510','27370','27110','27350','27140','60590','76590','27370','76660','76730','27150','76730','76730','76270','27110','76560','76270','76590','27600','27600','27400','27520','76190','27420','27520','27350','76590','76660','27400','27400','76560','76560','76390','27510','27370','27140','60220','60380','76490','60380','76590','76590','76490','27940','27520','76190','76730','27520','27660','27660','76560','76190','76730','27110','27510','27110','27490','60380','76510','27490','76510','27800','76510','76730','76660','76270','76390','60850','27110','27110','27510','60380','60220','76190','27110','76390','27350','76550','27930','76660','60380','60220','60850','76550','27290','50630','76730','76740','76560','27870','76490','76730','27420','60650','76170','76550','76660','76330','76560','27950','27800','27420','27110','76560','27510','76730','27510','76270','60590','60590','76640','76490','27290','27500','76510','76190','60220','76560','76510','60380','27930','27490','60220','27500','76550','27920','27920','76730','76810','76880','27110','27350','76190','76390','76190','27930','27930','76630','27490','76740','76740','60650','76660','76330','27630','27950','27600','27290','76170','27830','76390','76740','76810','60380','27720','27350','27510','27500','76560','60380','27950','27110','27800','27800','27140','76490','76550','27110','76640','76660','27630','27950','60220','27890','76550','27950','76560','27500','76560','76560','27930','76510','27930','76810','27930','76390','60650','60220','76640','27930','27290','27930','27930','27500','50330','60220','76170','76880','27110','27680','60850','27720','27290','60590','76390','27110','27120','27110','60850','76640','27350','27420','27800','60220','76560','76550','60240','76640','76740','76740','76740','27290','76740','27290','76730','76210','76340','27800','27110','76330','76640','76330','27930','27800','60590','27950','27110','76170','60380','27630','60220','60380','76450','27930','27950','95770','95770','76340','76860','27930','27110','76630','60380','76560','76340','76740','27630','27800','60220','76370','60220','76630','27180','76630','27500','76560','76170','76370','27290','27630','27290','27140','76450','27120','76630','76640','76860','27620','27110','50700','27110','76640','60650','60650','76740','76390','27630','27930','27120','76660','27630','27290','60380','60650','76370','76560','76560','95770','76640','60380','27290','27680','27120','27930','60240','27180','76740','76660','76210','60220','76460','76390','76740','76340','76660','76860','27800','60220','60590','76550','27930','27950','60380','76390','76170','60650','27500','27930','76740','76450','76340','76370','60112','27200','60650','27110','76450','27950','27120','27800','60240','27800','27450','76210','60380','27170','76170','27120','27930','60590','60220','76640','60240','27170','60590','27680','76390','60850','76630','27930','27120','27800','76460','60960','76640','60590','27500','60650','27170','60650','60220','60220','27680','60650','76450','27680','60220','76340','76450','76460','27450','60112','60240','76390','60210','76640','76740','60590','27450','27680','76630') AND fami_id='5' AND cate_id='88' AND type_id='1' AND ssrubr_id='2' AND wish_id<>'571402' 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='2' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=427137 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 = 427137 AND W.type_id = 1) OR (W.util_id <> 427137 AND W.type_id = 2)) AND (M.post_util_id = 427137 OR M.dest_util_id = 427137) 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 = 427137
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='2' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=426710 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 = 426710 AND W.type_id = 1) OR (W.util_id <> 426710 AND W.type_id = 2)) AND (M.post_util_id = 426710 OR M.dest_util_id = 426710) 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 = 426710
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='2' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=409415 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 = 409415 AND W.type_id = 1) OR (W.util_id <> 409415 AND W.type_id = 2)) AND (M.post_util_id = 409415 OR M.dest_util_id = 409415) 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 = 409415
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='2' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=374595 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 = 374595 AND W.type_id = 1) OR (W.util_id <> 374595 AND W.type_id = 2)) AND (M.post_util_id = 374595 OR M.dest_util_id = 374595) 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 = 374595
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='2' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=81048 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 = 81048 AND W.type_id = 1) OR (W.util_id <> 81048 AND W.type_id = 2)) AND (M.post_util_id = 81048 OR M.dest_util_id = 81048) 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 = 81048
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='2' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=315312 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 = 315312 AND W.type_id = 1) OR (W.util_id <> 315312 AND W.type_id = 2)) AND (M.post_util_id = 315312 OR M.dest_util_id = 315312) 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 = 315312
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='2' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=207847 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 = 207847 AND W.type_id = 1) OR (W.util_id <> 207847 AND W.type_id = 2)) AND (M.post_util_id = 207847 OR M.dest_util_id = 207847) 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 = 207847
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='2' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=179824 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 = 179824 AND W.type_id = 1) OR (W.util_id <> 179824 AND W.type_id = 2)) AND (M.post_util_id = 179824 OR M.dest_util_id = 179824) 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 = 179824
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='2' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=172610 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 = 172610 AND W.type_id = 1) OR (W.util_id <> 172610 AND W.type_id = 2)) AND (M.post_util_id = 172610 OR M.dest_util_id = 172610) 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 = 172610
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 2
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