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