-3000kg
qu'à l'achat
Description de l'annonce
Je desire tracter Caravane pour un weekend depart Verquin jusque Noyon
#Caravane
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-3000kg
qu'à l'achat
Je desire tracter Caravane pour un weekend depart Verquin jusque Noyon
#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='269527'
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='53451' 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` = 53451
SELECT util_cp FROM utilisateur WHERE util_id=53451 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 = 269527
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=973 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 53451 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='269527'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='269527' 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=53451 LIMIT 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 `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 = '269527'
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='53451' AND wish_id<>'269527' 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='62131'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.5*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.5*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.63333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.050339197041 AND ville_latitude_deg<50.949660802959 AND ville_longitude_deg>1.9263958452443 AND ville_longitude_deg<3.3402641547557 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 ('62131','62131','62131','62232','62620','62196','62113','62232','62290','62400','62232','62232','62199','62660','62113','62113','62122','62620','62940','62620','62530','62149','62920','62670','62920','62400','62980','62700','62620','62114','62149','62122','62980','62232','62400','62540','62149','62920','62150','62149','62150','62160','62530','62149','62160','62150','62172','62540','62350','62150','62150','62460','62157','62136','62160','62470','62138','62530','62150','62136','62690','62138','62136','62260','62470','62138','62460','62750','62150','62350','62150','62151','59480','62350','62143','62190','62840','62260','62350','62690','62410','62800','62690','62136','62350','62144','62127','62840','62150','62550','62350','62690','62153','62138','62410','62127','59496','59660','62690','62190','62460','62190','62144','62153','62260','62550','62410','59253','62690','62550','62300','59940','62190','59480','62300','62580','62190','62190','62550','62350','62690','62550','62138','62550','62690','62690','62144','62330','62690','59940','62690','62260','59496','62130','62880','62190','62120','59134','62144','59274','62840','62410','62690','62550','62550','59221','59249','62127','62210','62880','62880','59134','62221','62218','62690','62127','62330','62144','62120','59249','62430','62550','62840','62580','62550','62690','62190','59184','62440','62127','62580','62127','62120','62130','62680','59134','62127','59185','62550','62120','62550','62550','62550','62880','59189','62580','62690','62960','62960','59272','62223','62120','62130','62161','62161','62120','62420','62127','59940','59189','59136','62127','62130','62740','59112','62690','62840','62120','62120','62127','62580','59134','62550','62710','62320','62223','62120','62580','59232','62123','62123','62123','62123','62161','62134','62127','62640','62161','59189','62580','62960','59251','62120','62145','59134','62320','62130','62223','62810','62130','62580','62130','62110','62127','59112','62220','59190','62130','62810','59320','62134','62320','62320','62580','59270','62810','62223','62127','59270','62123','59147','62145','62134','59280','62130','62580','62810','62223','59181','62120','62000','59133','62127','62120','59320','59320','62130','59211','59147','62590','59190','62810','62223','62960','59147','59193','62127','62580','59173','62130','62120','62119','62810','62130','62134','62123','62123','59190','62123','62130','62580','59190','62134','59320','62000','59850','59270','62810','62810','62223','62145','62130','62950','62130','59320','62810','62130','59270','62490','59263','59280','62134','62130','62130','62270','62134','59320','59133','62820','62120','62960','62134','62810','62217','62217','59173','62134','59930','59270','59320','59190','59840','59320','62810','62270','59190','62123','62217','62130','62490','59320','62810','62130','62145','59261','62810','62270','62118','62960','62134','59173','62223','62130','62960','59139','62134','62970','59113','62120','59160','59162','62490','62130','62810','62217','62120','07783','62118','62960','62810','62141','62120','62217','62134','59239','59551','59239','62123','62123','62123','62810','62130','62129','62173','62130','59116','62118','59840','62134','62130','62130','62158','59120','59114','59270','59175','62134','62173','62270','07782','59190','62217','62310','59173','08950','59190','62129','59139','62129','59950','59553','62490','62270','62810','62134','62120','62118','08951','62123','59175','62123','62130','59128','62790','62270','62270','59114','62118','62173','62810','59551','59840','59270','62310','62130','62130','62310','62810','62217','62130','59155','62310','59710','59173','62310','62158','62173','62120','59236','62270','62118','59553','59553','59283','62128','62118','59670','62560','59283','62158','62129','08952','59130','62270','08958','62810','62128','62130','62117','59237','62128','62130','59286','59670','62575','62129','59246','62270','62130','62128','62123','59270','62310','08950','59114','62158','59670','62175','62560','59299','62770','62270','62310','62129','59552','62270','62810','62128','08954','59000','59800','59160','59350','59777','59350','62128','59500','59114','62175','59710','59890','59710','62310','62770','62156','08956','62310','62175','62310','62158','62175','59790','59552','59110','62112','62270','62490','62270','08957','62560','59670','62156','62158','62175','62570','62380','62111','62111','62770','62575','59890','62310','80600','62158','59810','62310','62490','62770','62770','62116','59560','59710','62310','59310','07784','62156','59670','62310','62310','62570','59118','59273','62128','62510','62128','59169','62112','62380','62270','62156','62760','80600','59670','62560','59520','62270','08970','08953','62121','62156','59260','62310','62310','59194','62770','59119','59235','80600','62156','62810','59670','59700','07784','62270','62490','59370','62111','62111','62570','59670','62560','62270','62490','59450','62770','62760','62128','59670','62116','62121','62770','62116','59242','62310','62128','62380','62500','62310','59242','62270','59151','59670','62570','80600','62770','59187','59194','62760','62760','08900','62219','62770','62128','59273','59259','62121','62182','62560','62380','62500','59262','62770','59169','59670','62390','62270','62156','62760','62219','07780','07780','62380','62310','08902','62270','62111','59670','62560','62270','62770','80600','59285','07781','62760','62116','62500','62760','62121','62270','62860','59910','59148','08978','08970','62770','59167','59830','62770','62770','59151','59143','62760','59285','08902','62760','59560','59310','80600','62182','59287','62560','59830','59310','62128','62128','62860','62770','62380','62380','62111','62111','62182','59169','62182','59170','59290','62500','59151','59223','59250','59126','59169','62116','62560','62770','59491','59493','59650','59655','59182','59287','62310','62500','59470','62760','59242','62310','62390','62860','62860','59152','59152','59510','08908','62140','62380','59420','59117','62380','62159','62390','59830','62500','59182','62390','62860','59285','62121','62128','62140','80600','08940','62770','08902','62760','62121','08980','62500','59310','62111','59470','59152','62111','80560','59830','62760','59151','62390','62116','08900','59143','59169','62390','59143','80560','80600','62560','62860','62121','62121','62560','59470','62860','59152','59470','59146','62380','59510','08972','80560','62121','59166','59176','62390','08900','59310','62310','80560','59200','59100','62500','62860','80600','62390','59470','62140','62140','62140','59870','62121','59151','62140','80600','62500','62760','62860','59470','59830','62140','59870','62140','62860','80560','62650','59780','62760','62450','59176','80560','80560','08906','62910','62380','59390','62860','59470','08900','59234','62380','59470','59780','62760','80600','62159','80600','62990','59780','62140','80300','08980','59830','59390','62910','80600','80300','59390','80600','62860','62140','62760','62450','62860','80370','62860','59830','80560','62159','62650','62140','08640','62390','59960','59143','59265','62390','59470','62990','80600','62380','62390','59310','59310','62910','62140','80560','59490','62990','80370','62450','62380','59390','62650','08972','62450','80560','80300','59165','59122','80300','59310','08972','59470','08940','62124','80600','62450','62140','80560','62450','59870','80560','80300','80300','62140','08904','62500','59150','59234','62910','62650','59265','59234','62450','59870','62390','62140','62990','59310','59380','59143','62380','07611','62140','62140','59143','62860','08640','62650','59580','08980','59470','62124','62910','62650','07712','62650','08930','62380','07522','62390','62390','08640','62450','07610','07522','62860','59115','07502','62450','80370','80600','62140','59580','80560','80370','08980','59490','80600','07730','07520','08904','62650','62450','62990','62990','62140','62140','62890','62990','62990','59122','80560','59470','62124','07700','08640','59380','59247','62380','80150','59247','62140','80560','80300','08930','59870','62147','59380','08691','80600','59265','80630','07522','80560','62450','62124','62910','59143','62380','59179','62650','07730','59310','59690','80370','59380','62147','62450','62650','59870','62380','62380','80600','80370','62860','59630','62390','59230','62390','59252','62380','62147','07504','80370','07522') 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<>'269527' 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=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 abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 432873
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=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=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=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