Recherche à louer garage
Description
Bjr recherche garage à louer sur fresnes sur Escaut côté Marcel cachin ou résidence des alouette fresnes sur Escaut
Urgent merci #garage
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Fresnes-sur-Escaut (59970) · publié depuis 3 mois ou +
Discuter
Prix
85€/mois
Bjr recherche garage à louer sur fresnes sur Escaut côté Marcel cachin ou résidence des alouette fresnes sur Escaut
Urgent merci #garage
Autres annonces du voisin
Tout voirAnnonces similaires
Tout voirLouer un garage/parking entre particuliers ou proposer un garage/parking en location.
Poster une annonceEnvoyer 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 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='294388'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='garage' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='519'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'garage' 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='79'
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='57444' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 57444
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 = 294388
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=519 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 57444 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='294388'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='294388' 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=57444 LIMIT 1
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 = 57444 AND W.type_id = 1) OR (W.util_id <> 57444 AND W.type_id = 2)) AND (M.post_util_id = 57444 OR M.dest_util_id = 57444) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='57444' AND note_visu IN (1,3,4)
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 = '294388'
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='57444' AND wish_id<>'294388' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ssrubr_slug, 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='519' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=57444 AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 57444
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59970'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.4167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.4167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.6- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.967039197041 AND ville_latitude_deg<50.866360802959 AND ville_longitude_deg>2.8943097054346 AND ville_longitude_deg<4.3056902945654 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_cp IN ('59970','59970','59278','59154','59264','59163','59163','59243','59970','59163','59860','59920','07380','07350','07387','59880','59990','07320','59990','07380','07350','59192','59199','59770','59990','59300','07387','59199','59410','59590','07603','59990','59990','07382','07322','07321','07387','59494','07350','07600','07321','07387','07387','59300','07370','07322','07387','59174','59494','59144','07608','59230','59990','07370','07387','59144','07350','59230','59158','59230','07973','59144','07387','07601','59300','07971','59144','07972','07370','59195','59990','59135','07973','59269','07387','07334','07604','59158','59144','59125','59570','07971','07300','59195','07602','07971','59158','07387','59570','59178','07604','07971','07604','59530','07387','59158','59220','59269','59570','07604','59226','59135','59178','59121','59233','59570','07370','07334','07340','07330','07622','59220','59269','59144','59255','07333','07301','59121','59570','07604','07640','07332','59530','59224','07904','59530','07972','07620','59570','59171','07340','59224','59144','07970','59213','59530','07904','59178','07390','59220','07623','07331','59230','07640','07340','07340','59213','07950','07538','07972','59570','07620','07332','59227','59144','59530','59870','59570','59570','59178','07390','07621','07643','59213','59213','59530','59226','59230','07620','07534','07620','07080','59171','07641','07640','07950','07624','07903','59124','07080','59282','59870','59870','59310','59690','07012','59530','59530','07080','59530','59570','07903','59213','59213','07620','07530','59530','59171','07012','59156','59570','07080','07906','59570','59530','07950','59282','59570','07642','07040','59293','07620','59179','07050','07812','07903','07951','07011','07040','07901','59310','59530','59870','07534','07802','07500','59198','59310','59730','07521','59172','59227','59227','07033','07536','59490','07080','07950','07040','59215','07900','07900','59310','07050','07618','59294','07532','07050','59870','07040','07812','07950','59570','59296','59218','59218','59218','07531','59111','07911','07024','07812','07040','07040','07904','59730','07611','07500','07812','07870','07548','59870','07506','59172','07533','59111','59310','07801','07540','07812','07000','07050','07911','59490','07040','07022','59530','07040','07022','07040','59138','59188','07610','07500','59750','59218','07020','59870','07022','59530','59111','07504','59530','07911','07811','59188','59310','59138','59580','59600','59310','07810','07911','07540','07800','07940','07540','59730','59330','07020','07941','07812','59580','07502','59730','07501','07050','07942','59146','07032','07022','59165','59600','59138','07760','07940','59830','59188','07911','07041','59252','07911','59111','59730','59288','07803','59176','07543','07540','59310','59129','59145','59141','59330','07503','07870','07050','59830','07910','07522','59252','59252','07030','59730','07760','59295','59295','59292','59138','59620','59310','07870','59176','07910','59600','07870','07943','59148','59145','07022','07034','59222','59222','59550','07910','59182','59830','07522','59550','59830','59277','07542','59600','07804','59330','59242','07800','59234','07911','59141','59330','59600','07910','07910','07910','59214','59222','07041','59141','59620','07522','07034','59720','59780','59167','59600','07061','07522','59271','07822','07031','07804','07870','07822','59182','59287','59830','07910','59247','07823','59194','59830','59247','07743','07861','59234','07830','59780','07520','59360','07021','59161','07912','07890','07830','59234','59600','59550','59400','07120','59242','59169','59235','59287','07830','59550','07743','59131','59620','59217','59620','59194','07760','59554','59600','07912','07063','07822','59169','59600','59550','59242','59217','59550','59310','07910','07070','59360','59161','59620','07061','59540','07070','59161','59330','59330','07861','59247','59680','59152','07520','59217','59265','59540','07063','59554','59330','07830','07730','07760','07120','59119','59151','07120','07120','07830','07110','59161','59540','59450','59830','59152','59152','59360','59273','07750','59265','59680','59540','59400','06560','59187','59152','07890','59157','59268','59168','59245','59360','07740','59360','07120','59360','59780','59440','07866','59710','07070','07110','59710','07120','59157','07742','07120','59262','07730','07890','07130','59265','59246','59680','59710','59440','07070','59265','07862','59440','07120','59273','59554','07730','59980','59550','59440','09600','59286','59283','59169','07750','59164','07740','07860','59554','59400','59217','07750','59440','59283','07830','59390','07880','59680','07750','59151','59169','59400','07830','62860','07110','07866','59360','59225','07120','07863','07760','59551','08587','59460','62790','07060','07060','07130','59265','07730','59680','07750','08587','59980','59390','59400','59440','59510','07730','59400','59440','59680','59500','08587','06560','59510','59552','59244','59151','59191','59980','07062','59115','59400','07100','59710','59390','59810','59550','59244','59740','59169','59950','07134','62860','59360','59680','07131','59128','59554','59740','59553','59553','07864','62860','07760','07110','07120','59390','08583','59360','59216','59191','59244','59151','59554','59239','07730','59552','59225','59400','07730','59267','08582','62860','59680','07100','09690','59151','59239','07130','62112','07134','59440','62141','59162','59980','59980','09690','59551','62112','59127','59191','09690','09690','59216','59216','08510','59260','08554','59360','02110','59261','59790','59440','62860','59149','59740','02110','59360','07711','62490','01547','06560','07100','09660','59175','62970','06567','07070','08580','59400','59440','07110','59150','06567','59440','59440','59281','09500','07090','62490','59553','09690','07830','08552','59740','07090','62820','59155','02450','09681','62860','62860','59740','59170','59290','08581','59175','07100','07850','09500','62117','59258','01541','06560','06567','07850','59360','06560','08551','59113','59267','59740','59133','59440','59238','62490','09500','09500','59370','59159','62860','59740','07712','59127','07100','08581','07134','07133','09660','59241','59139','59258','59550','62860','59149','09661','09688','07190','02450','07190','59259','09500','07190','59137','62950','62119','59440','59491','59493','59650','59655','59100','09680','02170','62590','59127','06542','62490','07700','59740','07090','09660','09660','06543','62860','09700','09500','01430','07134','09500','09570','02630','06560','08573','09680','02110','07170','59159','59149','07191','62490','08572','02450','59000','59800','59160','59350','59777','07181','07141','02110','02110','62860','59740','06567','62860','59740','59133','02450','62490','62860','09680','08553','59139','07850','07170','59177','59258','62156','59400','02110','06540','59177','62220','09790','59127','09660','08510','59127','59147','59420','59263','62156','01570','59110','07700','09572','59700','07140','07140','01540','07090','08510','07170','59200','59147','01570','08570','62147','59112','09500','07170','09700','02170','08570','09660','09570','62490','09790','07141','09700','02170','01430','62118','62156','59120','62860','09667','09660','59320','09571','62182','09667','59219','59740','59147','07090','62110','62640','09700','59910','09667','62710','06470','09506','59520','02110','06530','08570','06150','09700','59142','59219','59130','59350','06500','08550','06500','59251','09506','07170','06540','59267','59740','06533','62118','62860','09790','09660','08511','01430','62182','62147','59320','09700','59266','59177','09570','02630','02510','62490','09790','01430','09620','09700','06500','62740','62320','62320','09506','62156','01570','07180','07160','62880','59740','02420','59219','09506','07090','59960','02110','02260','07181','59118','06470','59112','59320','08570','09790','62580','62156','09500','09700','59159','09630','09630','02110','02170','06530','07160','07160','01460','06500','62420','62147','59185','62440','62156','59266','62320','59231','09700','09506','06470') AND fami_id='5' AND cate_id='79' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='519' AND wish_id<>'294388' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, 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='519' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=490690 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 = 490690 AND W.type_id = 1) OR (W.util_id <> 490690 AND W.type_id = 2)) AND (M.post_util_id = 490690 OR M.dest_util_id = 490690) 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 = 490690
SELECT ssrubr_slug, 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='519' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=189592 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 = 189592 AND W.type_id = 1) OR (W.util_id <> 189592 AND W.type_id = 2)) AND (M.post_util_id = 189592 OR M.dest_util_id = 189592) 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 = 189592
SELECT ssrubr_slug, 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='519' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=222428 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 = 222428 AND W.type_id = 1) OR (W.util_id <> 222428 AND W.type_id = 2)) AND (M.post_util_id = 222428 OR M.dest_util_id = 222428) 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 = 222428
SELECT ssrubr_slug, 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='519' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=210219 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 = 210219 AND W.type_id = 1) OR (W.util_id <> 210219 AND W.type_id = 2)) AND (M.post_util_id = 210219 OR M.dest_util_id = 210219) 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 = 210219
SELECT ssrubr_slug, 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='519' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=180290 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 = 180290 AND W.type_id = 1) OR (W.util_id <> 180290 AND W.type_id = 2)) AND (M.post_util_id = 180290 OR M.dest_util_id = 180290) 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 = 180290
SELECT ssrubr_slug, 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='519' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=176795 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 = 176795 AND W.type_id = 1) OR (W.util_id <> 176795 AND W.type_id = 2)) AND (M.post_util_id = 176795 OR M.dest_util_id = 176795) 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 = 176795
SELECT ssrubr_slug, 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='519' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=171216 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 = 171216 AND W.type_id = 1) OR (W.util_id <> 171216 AND W.type_id = 2)) AND (M.post_util_id = 171216 OR M.dest_util_id = 171216) 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 = 171216
SELECT ssrubr_slug, 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='519' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=169135 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 = 169135 AND W.type_id = 1) OR (W.util_id <> 169135 AND W.type_id = 2)) AND (M.post_util_id = 169135 OR M.dest_util_id = 169135) 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 = 169135
SELECT ssrubr_slug, 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='519' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=165207 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 = 165207 AND W.type_id = 1) OR (W.util_id <> 165207 AND W.type_id = 2)) AND (M.post_util_id = 165207 OR M.dest_util_id = 165207) 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 = 165207
SELECT ssrubr_slug, 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='519' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=152485 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 = 152485 AND W.type_id = 1) OR (W.util_id <> 152485 AND W.type_id = 2)) AND (M.post_util_id = 152485 OR M.dest_util_id = 152485) 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 = 152485
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 n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)
Contactez-nous