-800kg
qu'à l'achat
Description de l'annonce
Bonjour, je cherche une remorque bagagere 4m long double essieu a louer pour 5 jours.
#Remorque
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-800kg
qu'à l'achat
Bonjour, je cherche une remorque bagagere 4m long double essieu a louer pour 5 jours.
#Remorque
Louer une remorque entre particuliers ou proposer une remorque en location.
Poster une annonce
-800kg
qu'à l'achat
Envoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
SHOW TABLES LIKE 'pays'
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='484755'
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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('77' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='316681' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 316681
SELECT util_cp FROM utilisateur WHERE util_id=316681 LIMIT 1
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 484755
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=727 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 316681 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='484755'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='484755' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=316681 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=316681 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 = 316681 AND W.type_id = 1) OR (W.util_id <> 316681 AND W.type_id = 2)) AND (M.post_util_id = 316681 OR M.dest_util_id = 316681) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '484755'
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='316681' AND wish_id<>'484755' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (w.wish_area IS NULL OR w.wish_area='' OR w.wish_area='FR')
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='77139'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.0333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.0333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.93333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.583639197041 AND ville_latitude_deg<49.482960802959 AND ville_longitude_deg>2.2474674218189 AND ville_longitude_deg<3.6191925781811 HAVING distance <= 50 ORDER BY distance ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('77139','77440','77139','77910','77910','77139','77910','77440','77910','77139','77139','77440','77165','77165','77124','77440','60620','60440','77124','77470','60620','77122','77440','77440','60620','77145','77440','60620','77440','77178','77440','77470','77124','77440','77165','77470','60620','77660','77178','77124','77100','60440','60620','77660','60440','77840','77470','60890','77100','77165','77165','77100','60330','77410','77230','77165','77440','77440','60620','77165','77470','60620','60620','77470','77230','60890','77450','77470','60620','77450','60330','77410','77410','77260','77260','60330','77840','77230','60440','60890','77640','77580','77580','77450','77860','02810','77410','60440','77230','60440','77230','77580','77260','77580','77450','60890','60890','77580','77260','60620','77440','77230','60620','77450','77260','77580','77860','77840','77230','02810','77260','60890','77700','77860','77450','60950','60330','77410','77260','77450','77230','77410','77640','77450','77410','60800','77580','77580','60620','60440','77280','77580','60890','77410','77580','77580','60141','77230','77230','02310','02810','60950','77138','77290','60800','60440','02460','60950','77700','60141','60117','77410','77144','77700','60300','77730','77410','60800','02810','02810','02810','77730','77120','77400','77230','02310','77730','77400','77163','60800','77750','60117','60800','02810','60800','77144','77400','77700','02310','77230','02470','60117','60300','60300','60800','02810','77120','02810','77290','02600','77700','77163','77515','77580','60117','77730','02310','02460','77510','77400','02470','77990','77600','77410','02470','77750','77750','77230','77400','02460','02310','77515','02810','02600','77400','77174','77120','77600','02810','77990','02400','60300','02470','02310','77270','77169','60800','77600','60800','77174','02810','60128','77400','77515','60117','02470','02310','77750','02600','77120','77181','02470','60810','60128','77600','77600','60810','60800','60129','02470','02400','95470','02310','95470','02600','60800','02310','77600','93290','77177','02600','02400','02400','02600','77360','77163','60127','77750','95380','95380','60129','60810','77169','60123','60129','02470','77750','77510','60520','60300','77181','93470','60123','77515','02600','77164','95470','02470','02310','93410','02600','77200','02600','95380','02400','77500','77090','77183','02210','60127','02400','02310','77515','02600','60320','60129','77186','77510','93420','77169','60810','60810','77510','02210','77120','77610','93370','02400','95700','60300','02210','60520','93390','93190','60320','60320','77120','77135','60520','93270','02400','60300','77510','02400','95380','77610','77220','77510','60810','02600','77420','93600','02400','77610','60410','02600','95670','77510','02570','77185','02600','60560','02600','77169','02210','93460','77120','77120','95380','02210','95500','02600','60410','77540','02600','77680','60410','02600','60320','77120','77184','02210','77131','02600','02210','95470','93220','93160','02210','93340','93320','60810','77131','02400','95190','02400','02570','77610','60410','95500','60300','60300','77320','02210','77510','60410','02600','02210','02600','60410','95270','02400','60700','02400','60350','02210','95190','60300','02400','77610','60350','95190','02400','77340','77330','02600','77220','02210','77320','77510','93330','93360','95850','95500','60350','94350','93250','77540','60350','95270','95270','94420','02570','60700','77320','60580','02600','77120','77220','02400','02400','95720','02210','95850','77510','02210','60610','02600','93700','93150','93140','02540','95500','77610','95270','60300','02210','60500','94170','02400','95720','77220','02210','94360','93110','94510','93130','77610','95270','95400','60126','02210','93000','60700','60350','02400','95140','02540','60126','77320','77320','02210','60260','94120','02210','60500','95270','94500','93440','02540','60350','95720','02400','77540','02290','77220','95720','02600','60700','77320','02600','77540','93350','94880','94490','94880','02210','60710','02600','94130','77540','02200','60700','77320','60880','60350','60350','02540','02210','77150','95270','02210','94430','02130','93230','93260','02650','95440','77173','02400','95400','95200','77141','95270','02200','77150','60740','60870','60880','02290','60880','60710','77320','60350','94100','94340','94210','93100','60350','60550','60270','77390','93240','60350','77390','02540','95460','77320','77320','02650','60350','02650','02330','95350','02210','02210','94380','94370','93500','95570','02400','94340','60100','77320','94300','77320','02290','93380','02540','93170','60940','60700','02130','93300','93120','02540','94410','02130','93310','60870','60680','60680','60680','95570','95350','77540','60153','77390','02200','02210','60180','60700','95270','77320','60340','77540','02290','77390','95410','02210','60870','02290','77320','77320','60190','60350','95270','02540','95360','60200','60680','77970','93200','93210','02200','60350','02540','77170','77166','94440','60160','02200','02130','77320','60940','02200','60200','95330','02330','77970','95570','02330','94160','94470','60340','95160','95270','93430','60350','94000','77970','02850','77970','95170','77320','77170','02200','94440','94380','77390','02330','60940','02200','60750','60170','60190','60160','77970','77390','94220','94700','02210','77720','77370','02200','60700','02130','77320','60820','02330','77560','77320','02290','02200','02200','60290','02200','77390','02850','02850','95270','95560','02330','93450','92390','60460','60190','77390','02850','95560','60280','77170','51210','02290','77111','95880','02200','60660','02130','02290','94440','60350','94140','02850','60140','02330','60290','02200','77390','51210','95570','02330','93400','02200','60140','95560','02850','02130','95580','95580','02330','77111','94460','94520','94520','02200','60190','60190','95230','02330','93800','60150','02220','02130','02130','51210','02290','94450','94200','94205','60200','60200','60460','95590','02200','02200','75004','75003','75013','75002','75000','75001','75005','75006','75019','75017','75020','75016','75018','75015','75014','75007','75012','75011','75116','75010','75009','75008','60190','60290','60140','95820','60190','91330','77166','02200','95680','95590','02130','92230','95600','51210','60140','60660','60660','95590','77370','60140','94400','94270','02130','95210','95218','51310','94600','91480','60350','77560','60350','77720','60150','77720','95340','60150','60170','02200','02290','60190','92110','77390','94190','77320','95260','95560','51700','95390','02330','91800','60660','02200','60660','91800','77380','60660','94800','77390','60150','60150','95120','60190','02130','51310','92600','02200','60530','02200','02850','60290','60190','77320','91860','02200','77560','02200','77560','02290','77320','60190','60530','77370','92300','60140','02200','60190','02290','02220','77550','95260','95840','02130','95320','51210','91560','94320','60113','60113') 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<>'484755' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='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_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='727' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=541399 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 = 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 abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 541399
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='727' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=414270 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 = 414270 AND W.type_id = 1) OR (W.util_id <> 414270 AND W.type_id = 2)) AND (M.post_util_id = 414270 OR M.dest_util_id = 414270) 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 = 414270
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='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_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='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_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='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_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='727' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=355935 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 = 355935 AND W.type_id = 1) OR (W.util_id <> 355935 AND W.type_id = 2)) AND (M.post_util_id = 355935 OR M.dest_util_id = 355935) 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 = 355935
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='727' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=352436 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 = 352436 AND W.type_id = 1) OR (W.util_id <> 352436 AND W.type_id = 2)) AND (M.post_util_id = 352436 OR M.dest_util_id = 352436) 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 = 352436
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='727' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=213882 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 = 213882 AND W.type_id = 1) OR (W.util_id <> 213882 AND W.type_id = 2)) AND (M.post_util_id = 213882 OR M.dest_util_id = 213882) 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 = 213882
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='727' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=302846 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 = 302846 AND W.type_id = 1) OR (W.util_id <> 302846 AND W.type_id = 2)) AND (M.post_util_id = 302846 OR M.dest_util_id = 302846) 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 = 302846
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (87) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (88) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (81) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (110) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (227) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (176) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (79) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (208) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (228) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (207) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (95) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (173) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (83) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (93) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (193) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (91) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (232) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (92) ORDER BY ssrubr_order ASC
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT COUNT(*) AS nbavis FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
Contactez-nous