Réserver
Description de l'annonce
Location 600 cbr 1993 en excellent état pour la journée ou en mensuel. #moto
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Réserver
Location 600 cbr 1993 en excellent état pour la journée ou en mensuel. #moto
Annonces similaires
Tout voirLouer une moto entre particuliers ou proposer une moto en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
40€
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='639293'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'moto' 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='81'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='401383' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 401383
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 = 639293
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=864 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='639293'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='639293' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 401383 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=401383 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 = 401383 AND W.type_id = 1) OR (W.util_id <> 401383 AND W.type_id = 2)) AND (M.post_util_id = 401383 OR M.dest_util_id = 401383) 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='401383' 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 = '639293'
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='401383' AND wish_id<>'639293' 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='78940'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.76667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.350339197041 AND ville_latitude_deg<49.249660802959 AND ville_longitude_deg>1.0840032105093 AND ville_longitude_deg<2.4493367894907 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 ('78940','78490','78890','78940','78490','78490','78490','78490','78910','78770','78490','78910','78770','78490','78910','78650','78490','78490','78910','78550','78490','78770','78640','78490','78770','78950','78910','78770','78640','78650','78113','78770','78610','78550','78910','78760','78640','78770','78790','78690','78113','78640','78550','78790','78790','78550','78310','78610','78124','78910','78850','78310','78550','78790','78113','78790','78610','78550','78930','78125','78580','78910','78790','78124','78690','78370','78990','78580','78610','78810','78580','78790','78113','78910','78320','28410','28410','78790','78930','78200','78930','28410','78121','78125','78930','78930','78111','78113','78340','78126','28410','78790','78320','78810','78320','78113','78580','78125','28260','78450','28560','78790','78580','78930','78680','78200','78125','28410','78190','78120','78410','78410','78930','78125','28560','78200','78390','28210','78980','78125','78440','78980','78450','28210','28410','78970','78200','78200','78711','78860','28410','78720','78630','78980','28210','78200','78410','28410','78470','78180','78410','78920','28210','28260','78200','78720','78200','78630','78720','78125','78520','78200','78200','78330','78720','28210','78410','28500','78590','28410','28260','78125','28230','78240','78960','28500','78200','78210','78470','78200','78130','78440','78280','28260','78240','78460','78440','78980','78590','28260','28260','28230','78200','78720','28210','78820','28130','28260','78620','78114','78120','28260','28210','78460','28210','78112','28130','27540','78870','78670','78670','78980','28210','28210','78250','78440','78125','78125','78250','78710','78160','78125','78520','78540','91470','28570','28210','28500','78130','78750','28260','28500','28130','78300','78117','78120','27640','78955','78100','78470','28500','78980','78480','78150','78440','78250','78520','78440','78440','28500','28260','78117','78150','78520','78250','78270','91470','28210','78510','78830','91470','78250','27530','78430','78250','78230','78000','78980','95450','28320','78530','78350','78560','28500','91190','28130','27730','78740','28130','27780','78270','78440','78290','78380','28500','28320','78110','28130','78740','78570','78440','78830','91190','28500','78440','91470','78170','78730','28210','78260','78270','95180','78730','78730','27750','78270','95450','78270','28210','78220','27710','78730','28520','28520','78270','95000','28500','78400','78350','27730','91400','95510','95510','95510','78270','91190','91940','78440','28130','78570','95780','28320','92420','92430','27220','28100','91400','78660','78840','28130','78270','78270','78600','78140','78840','95450','27810','27640','27730','28210','27650','28500','92380','95450','28130','78360','28320','95280','28500','95800','27120','78780','92410','27220','91440','27220','28700','28700','28210','92370','78270','78700','92310','91470','28320','78660','28130','95450','95510','91940','95780','95450','95490','27220','91410','28130','91400','95000','27640','91430','78270','78600','91470','91640','27120','91640','91940','27650','95450','95780','27220','92500','28170','78730','78270','78420','95650','92210','95420','95420','27120','27220','91570','95510','28700','28700','92000','28500','27120','27220','95420','78270','27620','95450','91430','27120','95000','91640','91530','95450','27620','27620','78800','95610','28130','28500','28500','27650','78660','95510','78270','27220','28170','91640','78500','92190','92360','91410','27220','92800','92150','27220','78660','28700','91530','95450','28300','28500','27320','95650','91410','27120','92100','95530','95710','27120','95650','95650','27220','91680','28170','91410','95870','28300','78660','28500','27630','95450','95450','91140','91120','92140','27120','95370','92130','27770','92350','27120','95220','28170','27320','92290','95520','95450','27220','27120','95300','28300','91370','92250','27220','95420','95420','28500','28700','91140','92400','95420','95420','95450','28500','28500','28300','95420','95450','28700','92700','95240','91530','27200','28300','92200','95310','92320','91530','95480','27120','92260','92330','78660','95710','28380','91620','91410','91160','27220','95650','95300','28500','27220','91300','95640','27120','91680','92270','91160','28700','95420','91460','95420','28700','91410','92220','95100','27120','91650','92240','95830','27620','27950','91650','92170','95710','78660','95640','95640','92300','92160','28500','28300','95830','27120','95130','95250','95750','27220','95110','92600','27950','28300','27120','91650','28700','27220','27220','91620','27630','91410','92120','92340','27630','27320','28350','28300','92110','27220','27950','91380','28270','91160','91580','28300','94260','91160','95130','95420','91410','91520','91340','91580','28300','91310','28700','28700','91310','91310','91410','95420','27120','95300','28270','28170','27320','95810','94110','94250','94238','94239','94234','94230','94233','94237','94240','94235','94231','94236','94232','27120','95430','27630','27320','92230','95120','91180','95150','95550','28700','28300','27630','95640','95218','95210','27950','27950','91320','91310','28700','27220','28170','95810','27510','27220','28300','91700','95750','91910','91730','28700','95420','95320','95300','27930','27950','75007','75008','75005','75006','75001','75014','75004','75003','75002','75009','75010','75011','75000','75012','75019','75116','75017','75013','75016','75015','75020','75018','27120','91290','94550','60240','27630','27120','93400','28630','91360','93800','95640','91420','27930','28170','95770','95740','27120','94150','91790','27630','60240','91240','91410','27120','95540','60240','28700','27510','27950','28000','28170','60240','95640','27510','91870','27930','95390','95600','91290','28190','94800','91630','94270','27120','95230','92390','93450','91360','91150','28270','95640','91410','27920','27920','27320','95880','27220','27630','27220','28300','28630','27930','91580','60240','60240','28700','95430','95810','95630','28300','95680','95580','95580','27930','95770','95770','28700','28170','95840','91550','91630','95810','27420','28700','27320','95840','27120','27510','94205','94200','91220','91220','91390','91600','91730','94320','28350','27510','27120','91700','93430','28190','91730','28170','93200','93210','27950','27240','27930','95810','60240','27940','95560','91780','95760','27600','27950','91630','60240','27420','91580','95170','28110','91780','91780','60240','28700','94400','95690','28700','28700','95360','28630','28700','28700','27240','27930','27720','94390','94310','60240','93120','93300','28190','91630','95160','91260','27600','93310','95410','28300','91200','27420','91150','28270','28300','27240','95640','28630','28600','27180','27240','91170','94140','94220','28700','93380','93500','28630','27510','94160','94600','91700','27930','95570','60240','95810','27700','95690','95690','91630','60119','93240','27940','93170','95620','60240','60240','22680','91350','94290','27930','91510','91510','28700','27490','94480','28630','95690','28700','27930','28300','94700','27930','27930','95330','28170','27870','91270','27510','60240','95560','95350','27570','28630','95290','60119','95810','94300','28170','28170','95590','91580','28360','95350','93100','60240','91210','28700','27490','91150','91070','93260','93230','28190','28270','60119','93350','91740','91740','95570','28700','27420','95560','27930','27420') AND fami_id='5' AND cate_id='81' AND type_id='1' AND ssrubr_id='864' AND wish_id<>'639293' 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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=143984 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 = 143984 AND W.type_id = 1) OR (W.util_id <> 143984 AND W.type_id = 2)) AND (M.post_util_id = 143984 OR M.dest_util_id = 143984) 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 = 143984
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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=547305 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 = 547305 AND W.type_id = 1) OR (W.util_id <> 547305 AND W.type_id = 2)) AND (M.post_util_id = 547305 OR M.dest_util_id = 547305) 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 = 547305
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='864' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 547305
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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=546401 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 = 546401 AND W.type_id = 1) OR (W.util_id <> 546401 AND W.type_id = 2)) AND (M.post_util_id = 546401 OR M.dest_util_id = 546401) 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 = 546401
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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=546386 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 = 546386 AND W.type_id = 1) OR (W.util_id <> 546386 AND W.type_id = 2)) AND (M.post_util_id = 546386 OR M.dest_util_id = 546386) 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 = 546386
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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=544098 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 = 544098 AND W.type_id = 1) OR (W.util_id <> 544098 AND W.type_id = 2)) AND (M.post_util_id = 544098 OR M.dest_util_id = 544098) 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 = 544098
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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=542210 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 = 542210 AND W.type_id = 1) OR (W.util_id <> 542210 AND W.type_id = 2)) AND (M.post_util_id = 542210 OR M.dest_util_id = 542210) 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 = 542210
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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=538486 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 = 538486 AND W.type_id = 1) OR (W.util_id <> 538486 AND W.type_id = 2)) AND (M.post_util_id = 538486 OR M.dest_util_id = 538486) 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 = 538486
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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=537835 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 = 537835 AND W.type_id = 1) OR (W.util_id <> 537835 AND W.type_id = 2)) AND (M.post_util_id = 537835 OR M.dest_util_id = 537835) 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 = 537835
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='864' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=536228 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 = 536228 AND W.type_id = 1) OR (W.util_id <> 536228 AND W.type_id = 2)) AND (M.post_util_id = 536228 OR M.dest_util_id = 536228) 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 = 536228
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 864
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