Réserver
Description de l'annonce
Loue moto bineuse
J'habite Le Perreux sur Marne #motobineuse
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Réserver
Loue moto bineuse
J'habite Le Perreux sur Marne #motobineuse
Annonces similaires
Tout voirLouer une motobineuse entre particuliers ou proposer une motobineuse 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='300440'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'motobineuse' 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='94'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='91327' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 91327
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 = 300440
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=4 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='300440'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='300440' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 91327 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=91327 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 = 91327 AND W.type_id = 1) OR (W.util_id <> 91327 AND W.type_id = 2)) AND (M.post_util_id = 91327 OR M.dest_util_id = 91327) 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='91327' 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 = '300440'
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='91327' AND wish_id<>'300440' 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='94170'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.85*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.85*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.400339197041 AND ville_latitude_deg<49.299660802959 AND ville_longitude_deg>1.8166517637462 AND ville_longitude_deg<3.1833482362538 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 ('94170','94120','93360','94360','94130','93110','93330','93250','94500','94350','93220','94340','93130','94410','94300','93160','93460','93100','94100','94210','94340','93320','94430','93340','93140','93260','93230','94420','93170','94160','93000','94220','77420','93370','94700','94000','77500','93310','94140','93390','94880','94490','94880','93190','77185','93500','94200','77184','94205','94380','94370','94380','93270','94510','77181','93470','77340','77186','93150','93700','94400','77177','94270','93410','77200','94600','93350','77360','94470','93600','94800','77181','93120','93300','94460','75009','75116','75020','75019','75018','75017','75010','75011','75016','75015','75014','75012','75013','75003','75001','75002','75005','75000','75004','75006','75007','75008','77680','77183','77090','77270','94320','93440','94250','94450','93290','93420','77410','94310','94390','93400','77600','94110','94190','94440','77400','95500','93210','93200','77400','92120','93240','94238','94235','94240','94234','94230','94237','94233','94236','94231','94239','94232','95140','94290','94550','77600','77600','77400','92170','91330','94440','92240','95500','91560','92390','93450','77330','77164','77150','94440','94150','92110','77135','92220','92340','77400','77600','95400','77170','94480','93380','77150','77400','91200','91800','93430','95500','95700','77400','92300','92320','95500','95360','91230','94520','94520','92600','77290','92230','94260','92200','77400','92130','77410','92260','92330','77600','91550','91270','77410','91320','93800','92140','77410','77144','92100','77600','92160','95410','91860','92270','92350','95880','95190','91800','95200','95400','92400','92250','95720','95170','77173','95350','77410','92290','92190','92360','91210','77410','92150','92800','91480','92700','77700','77144','77990','95380','91370','95440','77170','91260','95218','95210','91300','91480','95160','77290','91420','95380','77700','92210','77410','95230','77450','77380','95720','77990','95100','77450','77220','95350','91170','77230','95580','95580','77230','77166','91160','91380','92500','92310','77174','95380','95110','95380','91450','95190','95120','95460','77230','77700','92000','92370','77410','95870','77220','92410','95600','91130','91000','91600','91390','78800','92380','77700','77700','77410','95720','77220','77410','91570','77220','91120','95330','91360','77166','77230','77450','91350','78140','92420','92430','91160','91250','95380','91450','78420','91090','77230','95680','95190','91000','77127','91360','95130','91430','95470','95850','77450','77450','77174','91140','95570','77450','77450','78220','77230','77170','77230','95390','95720','77230','91160','95570','77230','77410','77450','91430','78170','77165','95130','77580','78500','77220','91160','77860','78400','95670','91280','77230','91250','77111','91700','95320','77390','78350','77610','95850','95470','95240','95530','77165','77165','95570','78360','95270','91700','78290','78380','77230','77165','91140','77550','91080','91700','77860','95270','91070','77111','78000','95370','95560','78150','77610','91400','95570','91250','95470','91100','78600','95270','95560','95470','95270','95270','91620','78430','78150','95560','91240','78560','77100','78350','78530','60128','91090','77124','78110','77610','77860','91400','77550','95250','95840','77230','91310','78600','77124','77100','95550','95150','77610','77550','77280','95560','91220','91220','77550','77580','77580','95220','91310','91310','77230','91440','91620','77390','60330','78230','77580','95270','91100','77165','95270','77176','78117','95270','95740','95590','78870','95270','78160','60128','77163','77122','95480','77124','77100','91190','91940','78750','77580','60950','78100','95840','77390','91460','77390','77610','77163','91250','91830','60560','60520','77610','77124','78590','60330','78620','77610','91190','91310','91940','91540','91540','78112','77163','78117','77950','77176','77580','78210','77240','77390','91540','77470','95540','77178','77240','91940','91190','78700','77390','95270','78590','91810','95590','78280','77950','78330','77390','91180','95270','77580','77178','60580','60520','77240','77910','77910','60260','95270','77950','77580','77165','77165','60520','60330','95430','91640','95630','91540','78300','77470','77470','78260','91290','77950','91630','95430','78114','77390','77580','77515','78240','95610','77139','91400','77470','95590','60950','91630','91710','78960','78470','91290','77390','77470','78570','91830','95260','78860','77310','95760','60330','77540','78180','77515','78450','78470','91680','95290','77310','91750','60950','95310','77910','78780','78240','95260','78390','91630','78955','77390','77470','95620','91340','91520','77390','77390','95660','77950','91630','91640','60440','77350','77580','95000','95300','77580','77390','77910','60820','77720','77139','78460','77515','77470','91610','78570','91750','60440','77000','77000','91770','78190','77720','77310','95340','77540','91630','77950','60270','77350','77139','95000','60300','60300','95820','78470','77131','91470','77115','91470','78450','91470','91680','95300','78340','77515','77350','95340','78670','78670','91640','60440','77190','78630','95300','95280','77139','77440','77540','91750','60500','60300','60300','60500','60300','77120','91760','95690','78810','60300','77720','60440','91650','91470','77120','91790','77660','60300','77580','78510','77000','60440','77720','91640','60230','95490','77115','77515','95520','77540','91470','91850','91650','78540','78460','77131','60300','60460','77120','78720','91730','60530','95300','78370','91590','95690','78480','77440','77720','77440','77000','95340','91510','91510','91530','95650','60740','77930','78990','95000','91650','77540','77660','78720','78320','60340','91590','77440','95690','60340','77190','78810','77820','60530','77930','78121','60300','95650','95650','77540','77120','78320','95800','77540','95690','95180','95810','78720','91910','91730','91590','60300','77720','60440','77640','78630','60530','91730','60810','60300','91840','77930','78850','60460','77139','77120','91890','60530','78320','78830','60620','77930','77440','78740','77440','78580','60810','77590','95810','60620','78130','91470','60440','77930','77440','77440','91580','91530','78310','60530','77440','91590','77120','78640','60620','60810','77260','60540','78920','77260','60540','78640','78720','77720','78310','77120','60440','78740','95810','77720','91490','78760','77930','91590','91580','77820','60160','91530','95650','95650','60620','77260','60700','77370','78830','60530','95450','60660','77590','77630','60620','60800','60540','77720','91580','77590','77720','78640','78580','91590','95810','78410','77120','78130','95450','77145','60800','60810','95450','95810','91580','95830','60620','77440','91590','60800','60540','78650','60530','60100','78690','60180','91490','91580','78124','78250','77169','91490','78640','78690','77370','91410','91580','60160','77630','77141','77820','91530','78124','60620','78250','91820','77370','78490','78720','95830','60660','60660','95810','78580','77640','91590','60810','60660','60660','60540','60110','91820','77169','77440','78250','77510','77260','95450','95450','60110','60620','78410','78580','77920','78730','78730','78490','78490','77120','78610','60550','60870','77970','60810','78250','78126','78250','95640','60620','77850','91880','95810','60800','77630','78650','60890','95450','77840','91720','78490','60810','91410','60620','77440','77260','78410','77120','60800','95640','60800','77370','77133','91150','77260','78125','78410','91410','78410','60250','60410') AND fami_id='5' AND cate_id='88' AND type_id='1' AND ssrubr_id='4' AND wish_id<>'300440' 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='4' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=311956 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 = 311956 AND W.type_id = 1) OR (W.util_id <> 311956 AND W.type_id = 2)) AND (M.post_util_id = 311956 OR M.dest_util_id = 311956) 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 = 311956
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='4' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 311956
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='4' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=525453 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 = 525453 AND W.type_id = 1) OR (W.util_id <> 525453 AND W.type_id = 2)) AND (M.post_util_id = 525453 OR M.dest_util_id = 525453) 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 = 525453
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='4' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=309513 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 = 309513 AND W.type_id = 1) OR (W.util_id <> 309513 AND W.type_id = 2)) AND (M.post_util_id = 309513 OR M.dest_util_id = 309513) 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 = 309513
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='4' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=324522 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 = 324522 AND W.type_id = 1) OR (W.util_id <> 324522 AND W.type_id = 2)) AND (M.post_util_id = 324522 OR M.dest_util_id = 324522) 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 = 324522
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='4' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=72410 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 = 72410 AND W.type_id = 1) OR (W.util_id <> 72410 AND W.type_id = 2)) AND (M.post_util_id = 72410 OR M.dest_util_id = 72410) 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 = 72410
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='4' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=374667 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 = 374667 AND W.type_id = 1) OR (W.util_id <> 374667 AND W.type_id = 2)) AND (M.post_util_id = 374667 OR M.dest_util_id = 374667) 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 = 374667
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='4' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=435532 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 = 435532 AND W.type_id = 1) OR (W.util_id <> 435532 AND W.type_id = 2)) AND (M.post_util_id = 435532 OR M.dest_util_id = 435532) 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 = 435532
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='4' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=185224 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 = 185224 AND W.type_id = 1) OR (W.util_id <> 185224 AND W.type_id = 2)) AND (M.post_util_id = 185224 OR M.dest_util_id = 185224) 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 = 185224
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='4' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=408132 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 = 408132 AND W.type_id = 1) OR (W.util_id <> 408132 AND W.type_id = 2)) AND (M.post_util_id = 408132 OR M.dest_util_id = 408132) 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 = 408132
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 4
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