-3000kg
qu'à l'achat
Description de l'annonce
Location caravane une personne
#Caravane
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-3000kg
qu'à l'achat
Location caravane une personne
#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='572473'
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('62' 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='432873' 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` = 432873
SELECT util_cp FROM utilisateur WHERE util_id=432873 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 = 572473
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=973 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 432873 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='572473'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='572473' 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=432873 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=432873 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 = 432873 AND W.type_id = 1) OR (W.util_id <> 432873 AND W.type_id = 2)) AND (M.post_util_id = 432873 OR M.dest_util_id = 432873) 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 = '572473'
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='432873' AND wish_id<>'572473' 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='62127'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.4*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.4*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.43333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.950339197041 AND ville_latitude_deg<50.849660802959 AND ville_longitude_deg>1.7278883689314 AND ville_longitude_deg<3.1387716310686 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 ('62127','62130','62127','62130','62130','62127','62460','62150','62127','62130','62127','62127','62550','62127','62130','62130','62127','62550','62150','62130','62127','62460','62130','62130','62550','62127','62690','62130','62150','62127','62150','62130','62690','62130','62460','62130','62550','62150','62130','62690','62130','62127','62550','62127','62130','62150','62550','62550','62470','62127','62150','62550','62130','62470','62690','62690','62127','62270','62130','62150','62690','62130','62134','62130','62550','62130','62690','62810','62550','62270','62260','62260','62270','62690','62130','62150','62620','62134','62130','62130','62810','62700','62134','62130','62690','62540','62810','62620','62940','62810','62690','62260','62810','62270','62690','62134','62690','62810','62550','62810','62550','62550','62270','62540','62810','62134','62270','62270','62810','62134','62690','62134','62620','62130','62130','62690','62130','62130','62690','62122','62810','62810','62134','62260','62151','62130','62690','62530','62130','62270','62530','62550','62157','62270','62134','62130','62550','62620','62270','62270','62134','62144','62122','62134','62196','62123','62134','62530','62144','62270','62130','62172','62190','62810','62190','62199','62810','62270','62144','62960','62810','62134','62123','62123','62190','62131','62134','62270','62232','62920','62810','62960','62960','62770','62131','62131','62123','62270','62232','62270','62770','62190','62810','62114','62190','62120','62190','62810','62810','62810','62190','62310','62290','62134','62270','62770','62770','62144','62160','62120','62810','62810','62310','62270','62960','62232','62232','62144','62123','62960','62123','62113','62270','62161','62310','62770','62770','62153','62670','62160','62920','62960','62400','62120','62190','80600','62920','62158','62770','62810','62390','62161','62123','62770','62161','62161','62270','62310','62350','62270','62123','62310','80600','62770','62270','62113','62113','62310','62660','62158','62160','62145','62158','62310','62980','62123','80600','62120','80600','62270','62310','62770','62120','62158','62153','62143','62770','62770','62232','62120','62120','62770','62158','62149','62145','62145','62310','62350','62980','62960','62123','62400','62390','62770','62800','62770','62580','80600','62770','62000','62149','62390','62390','62123','62123','62330','62350','62960','62123','62120','62310','62580','62223','62330','80600','62120','62158','62223','62400','62123','62310','62390','62310','62390','62310','62120','62760','62310','80600','62310','62750','62770','62350','62560','62390','62173','80600','62145','62310','62350','62149','62760','62760','62770','62120','62760','62140','62390','62223','62158','62760','62760','62123','62310','62223','62580','62140','62223','62111','62120','62350','62310','62310','62149','62173','62149','62217','62300','62560','62350','62140','62140','62580','80600','62760','62140','80370','62136','62310','59189','62390','62217','62217','80600','62138','62000','62390','62310','62140','62760','62173','62390','62223','62140','62210','62560','62140','80600','80370','80600','62300','62136','62140','62173','62310','62410','62760','62138','62580','62217','62129','80600','62138','80600','62111','62390','62129','62111','62560','62120','62111','62136','59660','62111','59189','62760','62140','62129','62760','62120','62760','62140','62410','62140','59189','62136','59480','62390','62390','80600','62140','62580','62120','62580','62223','62760','80370','62116','62680','62140','62430','62140','80370','62175','80150','62310','62410','62221','62218','62840','62580','62140','62217','62138','62140','80600','62380','62140','62129','62760','62760','62760','62990','62880','62140','62140','80370','62175','62129','80600','80560','62140','62217','80600','62320','62217','59496','62390','80560','59253','62840','80370','62580','80370','62120','62390','62223','59940','62129','62580','62560','62175','80560','62990','62880','62880','62560','62580','59940','62116','62560','80600','62111','62380','62560','62990','62175','80150','62420','62320','62111','80560','62560','62138','80370','62175','80560','59173','62111','59173','62440','62116','62120','80560','80560','62990','62410','62121','62118','62560','59480','80560','59190','62128','80150','62128','59496','80630','62320','62320','62990','59221','62740','62140','80750','62111','62128','80370','62990','62990','62144','62580','62118','59134','59274','62380','62128','62575','62570','80560','62990','62116','62880','62840','80370','62380','80150','62128','80370','62116','80150','59173','80600','80560','62110','62640','80370','62120','62570','80750','62650','59134','62710','62990','80150','62120','59190','62128','80370','62121','62650','59249','62128','62140','62118','62490','80560','59232','62560','62118','62121','62840','59185','62118','80370','62116','62990','62650','62490','59249','62650','59184','80600','62575','59173','80370','80370','59190','80560','62650','59940','59173','80370','80560','80670','80560','62650','62380','80560','80670','62140','62650','59134','62990','62650','62570','59270','62380','62380','62870','62380','80370','59272','62128','80150','62118','62650','80620','59112','62570','80300','62121','62990','62510','59190','80620','62121','62121','62219','59190','59270','62220','80150','59136','80560','80370','80560','59190','80300','80150','62128','80150','62128','62950','80150','62119','62490','62156','62650','80620','62118','59251','62121','62380','62156','80560','80620','80300','62840','62590','62219','62870','62490','80260','62870','62650','59134','62128','59112','80150','80150','80150','80560','80560','62121','62870','80300','80150','62156','62990','62380','62990','80300','62159','59190','80300','59134','62380','80560','62380','62500','59133','62121','62121','80150','62170','59190','80560','62650','59147','62156','62970','80260','62500','62380','59181','59553','62500','59270','59114','80620','62650','80620','62450','59147','80300','62870','62156','62650','62380','59270','59320','62500','80670','80300','80300','80150','62128','62128','62182','80120','62117','62650','80260','62380','59280','62490','62500','80670','62170','62820','59147','80150','62870','80260','62141','59670','62500','59270','80135','59670','80260','59211','80670','59320','59320','80670','62170','62170','62156','59162','80120','80150','62182','59670','80300','62128','62450','80620','59193','62170','62500','80670','80135','62450','80135','59133','80850','80300','80620','80300','62380','59261','62490','59128','62380','59850','59950','59553','59553','62500','62380','62450','62870','59143','62500','80300','59552','59320','62650','59263','59114','62112','80780','59670','59670','62490','62450','59670','80260','80300','62450','80260','59670','80560','80560','62450','62156','59239','62112','59280','62240','59320','59320','80300','62450','80150','62240','62790','59285','59114','59239','59500','80150','59259','80300','62182','62490','62170','80690','80690','62450','62380','59552','80620','80135','62159','80135','59270','62182','62500','80300','80300','59169','62650','59551','59930','59113','80150','59114','80650','80300','80300','62860','62650','62450','59320','59320','59320','80150','59840','62860','62910','80690','59139','62159','59286','62910','59283','62450','62870','80260','59151','62650','59143','80260','80260','80260','59283','59670','80260','59670','80610','59270','62380','62170','80690','07783','59160','62860','80260','80132','80135','59270','80135','80300','62450','80300','62170','62124','80300','80150','62240','62170','62170','59551','62380','59175','62910','80690','62124','80620','80360','59143','62170','80300','62450','08951','08950','80300','62890','59116','59120','62170','62170','62170','62860','59151','62170','62860','62860','59840','62860','07782','80132','59139','80260','59285','59670','80260','59169','59246','62450','80610','80360','62240','62910','59299','62860','62170','59710','80800','59119','59175','59285','80260','59670','62240','59450','08958','62910','59187','62830','80300','59470','59670','62240','80132','62650','80150','80120','80690','59151','62170','80132','59470','80120','80150','62450','62650','80810','59155','62170','80360','62124','80120','80260','80300','80420','80420','08954','62850','62860','80300','62170','59710','59194','80830','80830','80360','59169','62910','08952','80800','59840','80300','59236','59143','62170','80260','62180') 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<>'572473' 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=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=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=346707 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 = 346707 AND W.type_id = 1) OR (W.util_id <> 346707 AND W.type_id = 2)) AND (M.post_util_id = 346707 OR M.dest_util_id = 346707) 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 = 346707
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=259099 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 = 259099 AND W.type_id = 1) OR (W.util_id <> 259099 AND W.type_id = 2)) AND (M.post_util_id = 259099 OR M.dest_util_id = 259099) 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 = 259099
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=181642 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 = 181642 AND W.type_id = 1) OR (W.util_id <> 181642 AND W.type_id = 2)) AND (M.post_util_id = 181642 OR M.dest_util_id = 181642) 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 = 181642
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=153693 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 = 153693 AND W.type_id = 1) OR (W.util_id <> 153693 AND W.type_id = 2)) AND (M.post_util_id = 153693 OR M.dest_util_id = 153693) 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 = 153693
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=53451 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 = 53451 AND W.type_id = 1) OR (W.util_id <> 53451 AND W.type_id = 2)) AND (M.post_util_id = 53451 OR M.dest_util_id = 53451) 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 = 53451
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=51263 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 = 51263 AND W.type_id = 1) OR (W.util_id <> 51263 AND W.type_id = 2)) AND (M.post_util_id = 51263 OR M.dest_util_id = 51263) 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 = 51263
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