-800kg
qu'à l'achat
Description de l'annonce
Bonjour
Je recherche une remorque 2 essieux pour un weekend.
#Remorque
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-800kg
qu'à l'achat
Bonjour
Je recherche une remorque 2 essieux pour un weekend.
#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='379904'
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('59' 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='158165' 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` = 158165
SELECT util_cp FROM utilisateur WHERE util_id=158165 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 = 379904
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=727 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 158165 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='379904'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='379904' 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=158165 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=158165 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 = 158165 AND W.type_id = 1) OR (W.util_id <> 158165 AND W.type_id = 2)) AND (M.post_util_id = 158165 OR M.dest_util_id = 158165) 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 = '379904'
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='158165' AND wish_id<>'379904' 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 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='995' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 158165
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59272'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.55*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.55*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.91667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.100339197041 AND ville_latitude_deg<50.999660802959 AND ville_longitude_deg>2.2089864030211 AND ville_longitude_deg<3.6243535969789 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 ('59272','59184','59136','59112','59251','59274','59147','59185','59134','59496','59221','59134','59147','59134','59147','62138','59112','59134','59133','62410','59211','59496','59480','59263','62138','59249','59320','59320','59320','59320','59320','59134','59139','59133','59249','59320','62220','59113','59480','59320','62410','62138','62880','62410','62880','62880','59320','62840','62138','59175','62880','59320','62840','59139','59551','62138','59120','62410','62820','62590','59175','59239','59261','62440','62710','59155','59280','59840','62149','59160','59710','59239','62149','62840','62136','62149','62740','62640','59551','62221','62218','59840','62119','59130','59162','62840','59000','59800','59160','59350','59777','59790','62149','62300','59840','62750','62136','59810','59710','59930','62420','62110','62980','59280','62149','59710','59350','62430','59246','59273','62840','59110','62141','59710','59193','62950','62136','59237','59260','62980','59283','62113','62113','62300','62970','59116','62790','59940','62660','59370','62680','62160','59700','59520','59283','59118','59950','62400','59850','62210','07783','62400','59273','59242','59253','62670','59310','59262','59242','62136','59235','62800','62113','62320','62320','62320','59236','62320','62143','59286','59181','59128','62290','59830','62160','59890','07782','62114','59830','62400','59940','62580','59890','62490','62580','59152','59152','62131','62131','59553','59553','59940','62490','59170','59290','59510','59910','62131','62232','59830','62232','62232','59242','62160','59194','62580','59310','62232','62580','59553','59491','59493','59650','59655','62530','59152','62153','59660','59560','62580','62580','62920','59830','62350','59152','62620','07784','59420','62232','62580','08950','59510','59310','59500','62580','62196','62172','59148','62153','59119','62350','59194','07784','59223','59250','59126','59830','62580','08952','59780','62199','62620','62530','08957','62144','59270','62490','59552','07780','07780','59780','59390','59780','62580','59310','59310','59100','59552','62580','62490','62580','59830','62920','59200','59830','62920','59450','59390','62530','59390','62122','59560','62117','62350','62620','62940','59270','59270','59167','08951','62350','59390','59117','62112','08950','59232','62620','59310','62223','59169','59187','08953','07781','08956','59166','62150','59870','62350','59150','59310','62144','62690','62144','08940','07522','62700','07522','62490','07611','59270','62122','07610','07502','62223','62112','59960','08958','59287','07520','62118','59115','62150','62118','62118','07730','59270','59870','59182','62118','59310','62118','59310','07712','62690','59146','08902','62223','59182','59287','62150','62350','62223','07522','62690','62350','62540','62223','59169','59270','62144','59169','07522','07730','62150','07504','62490','62157','62223','08980','62118','62540','62223','59151','07700','08902','62150','62150','62690','59176','08954','62690','62223','07618','59270','62161','62161','07730','59190','62490','59870','59310','59690','62150','62190','62690','59176','07506','62490','08900','07700','62460','59870','08940','08930','59190','07501','62000','59870','07730','59490','59169','08970','08930','07730','62144','59169','07624','62330','59230','59190','62470','62118','59226','62690','62156','08902','59299','07730','07520','62151','62156','62690','59151','07503','62690','62190','07620','62156','07500','62690','08980','62150','59178','62260','62217','62161','59151','59151','59259','62460','59230','62470','59190','59190','62127','59870','62000','62217','08560','59165','62161','07730','59490','59870','62190','07743','59189','08930','62217','62217','59178','07740','07620','62156','07621','62128','62156','62260','62128','62156','59270','08900','59234','08511','59189','59580','07623','62330','07711','07500','62127','07743','62690','59179','07500','08980','62150','62860','62217','62156','62690','62190','07620','59114','08510','62123','62860','07620','62123','08908','62550','62860','07740','59171','62123','62123','59234','62860','62860','08900','59151','59580','62690','62690','62128','07620','07540','62190','62190','59114','62190','62120','59189','62128','59226','62690','62460','62260','08900','07742','62128','62123','62128','08890','59234','59171','07521','08510','07620','07542','08510','62550','07641','62123','59265','62217','59178','08980','62860','08510','08587','59215','08970','59114','07548','62550','07536','62260','59178','08560','62120','62550','59190','62123','07642','62127','62217','62120','59173','59158','62182','62128','62550','59190','62182','62120','08880','62550','62130','08587','62182','62173','62860','08501','62690','62120','07622','07640','62128','59265','59171','62550','08906','62127','62810','59252','62860','62175','62123','59247','07540','62810','62127','62120','59158','62860','07904','59670','08560','62550','59252','08587','62120','59114','59230','08904','62127','59158','08554','62190','59172','62120','62860','62550','62173','59247','08880','62128','62182','07543','62127','59124','62550','59158','08501','62120','62120','62127','07531','08890','07643','08500','62120','62128','07640','08980','59230','62860','07760','62173','62810','59190','62860','59135','62127','59173','59230','08640','62127','62123','62123','62960','62960','62175','59670','59173','62550','62810','59252','07760','08978','59156','62130','59247','62810','62175','62860','08920','62145','62810','62123','59172','62173','07530','62175','59670','62550','08880','62128','62128','62127','59255','59111','62123','59220','59670','08920','62550','59111','62175','62128','62860','08904','59265','62127','08583','08920','62550','59265','62130','59670','07540','62121','07640','62810','07538','59293','08552','08550','59173','59554','62810','62120','59135','08972','62127','62120','62130','62121','62123','59265','07760','08920','62120','62120','07532','59670','08520','59295','59295','59199','62810','07760','59111','62960','62145','59670','62128','62550','62123','59268','59554','62134','08640','59195','59220','07604','62130','08582','07533','08840','62121','62860','59670','62158','59282','59470','59554','59494','08551','62130','59199','07540','62810','62116','08530','08972','59554','62121','62860','08860','62120','59141','62123','59173','62127','59220','62130','59195','62130','62130','62127','07608','59670','59111','62120','62810','59590','08640','07760','08800','07760','08640','62810','59282','07534','07604','08840','62111','62159','62116','62860','62134','59400','62159','62960','07604','59121','62145','07604','62120','62116','59554','08580','59494','62134','62270','08650','62120','08647','59141','07534','59192','62130','62158','62810','62130','62810','59670','62158','59161','08531','08870','08553','07750','08531','08647','62810','08540','62147','08972','62130','59670','07910','62130','59121','59470','59174','62810','59141','07910','62145','08800','59410','62129','59970','59400','59161','62134','62130','62159','62116','62124','08800','62158','59122','62129','62111','59554','59400','59470','62121','62121','62130','08691','07906','08570','62147','62134','08870','08791','07750','62270','59224','09690','62130','62270','59670','59296','07750','07604','08870','62121','62147','62130','62810','08647','62111','59267','62158','07750','62960','62130','08570','62960','59285','62121','07601','59860','62134','59161','62810','08770','62111','59470','08650','07911','62575','08840','62134','62130','59125','07910','07910','07910','07602','59267','62129','07910','62134','07600','59400','62450','62124','08581','62450','08710','62960','62124','62960','59278','07910','62450','62124','62134','59163','07750','07904','62147','08647','62130','62810','08792','59198','62450','08573','59470','62129','62116','59233','62158','62147','59970','62130','62270','59224','62130','59300','62760','59161','07911','62510','62121','07911','62810','07901','62134','07603','59880','08647','62760','62134','62575','59159','08830','62158','59277','62121','62147','59285','08800','08650','09690','08581','62500','59300','62134','59300','62130','62130','62570','09690','09690') 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<>'379904' 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=444611 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 = 444611 AND W.type_id = 1) OR (W.util_id <> 444611 AND W.type_id = 2)) AND (M.post_util_id = 444611 OR M.dest_util_id = 444611) 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 = 444611
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=482703 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 = 482703 AND W.type_id = 1) OR (W.util_id <> 482703 AND W.type_id = 2)) AND (M.post_util_id = 482703 OR M.dest_util_id = 482703) 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 = 482703
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=460190 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 = 460190 AND W.type_id = 1) OR (W.util_id <> 460190 AND W.type_id = 2)) AND (M.post_util_id = 460190 OR M.dest_util_id = 460190) 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 = 460190
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=444176 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 = 444176 AND W.type_id = 1) OR (W.util_id <> 444176 AND W.type_id = 2)) AND (M.post_util_id = 444176 OR M.dest_util_id = 444176) 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 = 444176
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=412376 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 = 412376 AND W.type_id = 1) OR (W.util_id <> 412376 AND W.type_id = 2)) AND (M.post_util_id = 412376 OR M.dest_util_id = 412376) 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 = 412376
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=390742 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 = 390742 AND W.type_id = 1) OR (W.util_id <> 390742 AND W.type_id = 2)) AND (M.post_util_id = 390742 OR M.dest_util_id = 390742) 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 = 390742
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=343913 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 = 343913 AND W.type_id = 1) OR (W.util_id <> 343913 AND W.type_id = 2)) AND (M.post_util_id = 343913 OR M.dest_util_id = 343913) 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 = 343913
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=282033 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 = 282033 AND W.type_id = 1) OR (W.util_id <> 282033 AND W.type_id = 2)) AND (M.post_util_id = 282033 OR M.dest_util_id = 282033) 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 = 282033
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=278818 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 = 278818 AND W.type_id = 1) OR (W.util_id <> 278818 AND W.type_id = 2)) AND (M.post_util_id = 278818 OR M.dest_util_id = 278818) 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 = 278818
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=116387 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 = 116387 AND W.type_id = 1) OR (W.util_id <> 116387 AND W.type_id = 2)) AND (M.post_util_id = 116387 OR M.dest_util_id = 116387) 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 = 116387
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