-3000kg
qu'à l'achat
Description de l'annonce
Recherche caravane à louer rapidement merci
#Caravane
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-3000kg
qu'à l'achat
Recherche caravane à louer rapidement merci
#Caravane
Louer une caravane entre particuliers ou proposer une caravane en location.
Poster une annonce
-3000kg
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='321119'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='caravane' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='973'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'caravane' 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='173'
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='121811' 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` = 121811
SELECT util_cp FROM utilisateur WHERE util_id=121811 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 = 321119
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=973 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 121811 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='321119'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='321119' 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=121811 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=121811 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 = 121811 AND W.type_id = 1) OR (W.util_id <> 121811 AND W.type_id = 2)) AND (M.post_util_id = 121811 OR M.dest_util_id = 121811) 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 = '321119'
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='121811' AND wish_id<>'321119' 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='602' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 121811
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59179'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.917039197041 AND ville_latitude_deg<50.816360802959 AND ville_longitude_deg>2.595053505516 AND ville_longitude_deg<4.004946494484 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 ('59179','59490','59171','59171','59870','59490','59215','59870','59171','59870','59580','59124','59870','59165','59870','59146','59176','59580','59156','59220','59135','59176','59255','59172','59870','59178','59172','59182','59178','59870','59178','59293','59220','59111','59135','59234','59282','59230','59252','59167','59182','59287','59195','59230','59252','59220','59178','59310','59148','59287','59195','59169','59121','59282','59234','59111','59111','59194','59169','59252','59494','59310','59111','59234','59230','59121','59310','59247','59310','59151','59224','59450','59494','59310','59295','59295','59194','59119','59590','59187','59174','59310','59690','59226','59226','59247','59125','59410','59296','59192','59265','59310','59247','59141','59141','59169','59233','59224','59169','59310','59158','59198','59554','59265','07624','59265','59310','59151','59286','59300','59552','59500','59860','59300','59141','59230','59310','59235','59300','59400','07623','59151','59169','59283','59227','59554','59230','59158','59268','59880','59553','59553','59552','59770','59283','59151','59269','59199','62860','59213','62860','07620','59128','62112','62790','59265','59188','59151','07611','59158','59227','59227','07621','62860','59161','59950','62112','59188','59161','59246','59161','59277','59199','59213','59242','59265','62490','59269','59242','59129','59158','59710','59278','62490','59990','62860','59554','59970','59553','07622','07620','62141','59161','62117','59990','59830','07620','62860','07620','59242','59554','62970','07610','07618','07620','59830','59554','59162','62860','62860','59213','59213','62490','59269','59710','59294','59188','59551','59264','59990','07620','59970','59990','59830','59554','59990','59292','59239','59259','59710','59970','62860','59163','59400','59830','62490','59830','59217','59243','62860','59400','62490','59261','07608','62860','59530','59830','07502','59239','07641','62950','59213','59213','59144','62490','59267','07506','07504','59730','59273','62119','59214','07500','62820','62156','62156','59710','07604','59400','59273','59400','59730','59551','59530','59780','62860','59400','07500','59217','07640','62118','07640','59217','62490','59990','59730','62860','59730','59990','59530','62590','07640','62156','59163','07642','59154','59144','59830','07643','59730','59262','59267','62118','59400','07522','07387','07604','59400','59217','59920','07600','59133','07521','62182','59530','59780','07603','59157','62860','62490','59163','62860','07501','62110','59152','59144','59281','59157','07604','59159','07522','07538','59271','59152','59152','07536','62220','59530','62156','59530','62640','59400','62182','59144','07601','62156','62320','62320','59540','62580','59810','59218','59218','59400','07522','07500','07320','07380','62710','59540','59175','59144','59113','07387','59530','59133','07604','62156','07387','07530','07380','62147','62740','07350','62118','59218','07522','07387','07548','62320','59175','59152','59241','62860','59730','07602','07503','59218','07604','62118','59144','62420','59112','59159','59147','62156','59530','59155','62147','62880','59530','07321','07387','62580','59790','07904','62320','62580','62118','59127','59530','59258','59540','62580','62440','07350','59258','59191','59139','07382','62182','59530','07534','59780','07540','07531','59570','59360','59191','59540','59147','07387','62860','07971','07971','62118','62118','07321','07387','59260','59267','62580','59263','59510','59225','62860','07387','07971','07520','59251','62680','07904','62128','59530','62182','07540','07322','07971','59147','62430','59530','59139','59222','62880','62880','62221','62218','59144','59390','59222','07532','62147','07520','59185','59258','59191','07972','59112','62128','59980','62580','07350','07973','59144','62580','59570','59530','07370','07370','59510','59225','62128','59159','59570','59570','62880','07322','07542','07906','62147','07534','59222','59360','62410','07743','62580','07533','59127','62223','59980','62210','59570','59288','62128','07743','07543','07730','07973','59370','59320','62147','07730','07387','59231','07540','59390','07387','59360','59550','07350','07904','59390','62300','59221','59000','59800','59160','59350','59777','62223','59272','62128','62128','07370','59980','59266','07972','62128','59120','62580','59320','59570','62410','59390','62159','59550','62300','59570','07730','07387','59184','62138','07540','62128','59530','59170','59290','59980','59980','62147','59136','62147','59570','62128','59127','07972','07901','07334','59115','62410','62580','59127','59110','59127','07740','59320','07730','62124','62128','07911','07300','59496','59360','59211','07370','59266','62124','07760','62217','59570','59238','07760','62223','62128','59320','62124','59360','62410','07903','59570','62217','59130','59700','59360','07903','59231','59274','59491','59493','59650','59655','07970','62138','59142','62223','07900','07900','07903','02420','07334','07340','62124','07911','59350','07742','62124','59266','59150','07760','59134','59231','62159','07730','07740','07730','62750','62000','59570','62580','59320','07330','62580','59496','59134','07332','62128','07910','62124','59360','62223','07950','62223','59320','59320','07911','59570','07333','59134','07301','62124','59520','62128','62800','59100','62217','07730','62217','59550','62223','59297','59320','62124','62124','59320','59134','59420','59137','02110','59360','62128','62153','07950','62138','07340','02110','62175','07812','07911','59160','07712','08587','02420','07332','62143','07910','59118','62223','59570','62217','62217','59840','62124','07340','59910','07340','07910','62450','07390','59480','07331','62121','62121','59480','07760','62159','59840','08587','62138','59200','07910','07910','07812','07911','07812','59134','02110','62450','02110','02420','07080','07950','07711','02110','07802','59840','07390','62124','02420','59360','07080','59145','62138','08587','59249','07910','59237','62175','80360','59145','59138','59360','02110','59550','62160','59570','07910','07951','59138','62153','07760','07080','08510','07911','07812','62450','59360','07700','07812','62124','80122','02110','02110','62450','07040','59249','62160','62121','62121','80240','62980','62175','59620','80360','07012','59138','62124','62149','62450','62149','62000','07950','62124','80740','07080','07700','62144','62144','07801','07910','59550','62149','62840','07012','62160','62173','62121','62161','62161','59550','07040','62121','02420','59620','08554','07812','07750','59280','08583','62217','07912','62175','62450','02110','62980','07050','80360','59360','07912','07950','07040','59223','59250','59126','59138','80240','62450','02420','80740','62840','62149','59960','59550','62670','02110','62121','59330','59330','62450','07750','62175','59890','07011','62161','02630','59750','08510','08582','07750','07750','80240','02420','62450','62450','07080','02110','07040','80360','62114','62173','07800','07760','62450','07033','02110','62144','80112','59620','62121','62149','62113','62113','02450','07750','07040','59930','07870','62172','07810','07911','07050','07803','07050','08552','62450','62450','07811','80240','07040','62161','07040','62840','08510','80240','62450','02420','59550','62123','59280','59116','62116','59620','80360','07024','07040','08511','62121','62144','62136','02630','62173','59330','59600','62530','62123','02420','02110','62530','02420','09690','02420','07941','62450','08580','62290','07940','62660','59236','59330','07040','08551','07050','02450','62173','59440','62116','62530','07942','59166','62116','02420','02230','09600','07022','59244','07804','07000','62113','62116','62690','07890','62690','08930','59440','62144','59193','59600','07022','62123','02450','07804','07022','59620','59890','62136','59117','07800','62123','80240','80240','02630','62840','62121','07020','07783','02110','59244','07940','02420','02420','62450','80360','02450','59600','09690','08930','80360','80240','62690','62123','62123','07041','62690','09690','09690','62690','07780','07780','59720','59330','59330','59560','80760','62136','59600','80240','07022','08581','59560','07050','07890','02170','59440','07020','62123','62123','80360','80300','08560','59244','02490','62840','07032','08510','80360','62400','62620','07822','02490','02110','02510','62111','08930','62131','62131','07870','07784','62131','08940','80300','59850','62123','80240','62450','07943','80360','08550','08553','62690','62123','80360','07782','07822','07784','02510','62150','62116','80240','59440','59600') AND fami_id='5' AND cate_id='173' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='973' AND wish_id<>'321119' 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='973' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=536065 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 = 536065 AND W.type_id = 1) OR (W.util_id <> 536065 AND W.type_id = 2)) AND (M.post_util_id = 536065 OR M.dest_util_id = 536065) 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 = 536065
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='973' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=479473 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 = 479473 AND W.type_id = 1) OR (W.util_id <> 479473 AND W.type_id = 2)) AND (M.post_util_id = 479473 OR M.dest_util_id = 479473) 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 = 479473
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='973' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=476192 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 = 476192 AND W.type_id = 1) OR (W.util_id <> 476192 AND W.type_id = 2)) AND (M.post_util_id = 476192 OR M.dest_util_id = 476192) 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 = 476192
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='973' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=407768 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 = 407768 AND W.type_id = 1) OR (W.util_id <> 407768 AND W.type_id = 2)) AND (M.post_util_id = 407768 OR M.dest_util_id = 407768) 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 = 407768
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='973' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=369075 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 = 369075 AND W.type_id = 1) OR (W.util_id <> 369075 AND W.type_id = 2)) AND (M.post_util_id = 369075 OR M.dest_util_id = 369075) 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 = 369075
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='973' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=367081 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 = 367081 AND W.type_id = 1) OR (W.util_id <> 367081 AND W.type_id = 2)) AND (M.post_util_id = 367081 OR M.dest_util_id = 367081) 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 = 367081
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='973' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=335961 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 = 335961 AND W.type_id = 1) OR (W.util_id <> 335961 AND W.type_id = 2)) AND (M.post_util_id = 335961 OR M.dest_util_id = 335961) 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 = 335961
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='973' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=318742 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 = 318742 AND W.type_id = 1) OR (W.util_id <> 318742 AND W.type_id = 2)) AND (M.post_util_id = 318742 OR M.dest_util_id = 318742) 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 = 318742
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='973' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=311955 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 = 311955 AND W.type_id = 1) OR (W.util_id <> 311955 AND W.type_id = 2)) AND (M.post_util_id = 311955 OR M.dest_util_id = 311955) 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 = 311955
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='973' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=304954 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 = 304954 AND W.type_id = 1) OR (W.util_id <> 304954 AND W.type_id = 2)) AND (M.post_util_id = 304954 OR M.dest_util_id = 304954) 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 = 304954
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