Discuter
Description de l'annonce
Bonjour je propose ma scie a onglet en location sur la métropole lilloise
20euros / jour
chèque de caution exigé 300euros #scie a onglet
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Bonjour je propose ma scie a onglet en location sur la métropole lilloise
20euros / jour
chèque de caution exigé 300euros #scie a onglet
Annonces similaires
Tout voirLouer une scie a onglet entre particuliers ou proposer une scie a onglet en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
20€
Pour appeler mon voisin & organiser le 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 filtre_dpt=''
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='305613'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'scie-a-onglet' 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='87'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='59'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='100836' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 100836
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 = 305613
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=41 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='305613'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='305613' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 100836 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=100836 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 = 100836 AND W.type_id = 1) OR (W.util_id <> 100836 AND W.type_id = 2)) AND (M.post_util_id = 100836 OR M.dest_util_id = 100836) 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='100836' 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 = '305613'
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='100836' AND wish_id<>'305613' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59235'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.4833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.4833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.15- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.033639197041 AND ville_latitude_deg<50.932960802959 AND ville_longitude_deg>2.4433156856277 AND ville_longitude_deg<3.8566843143723 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 ('59235','59310','59710','59246','59310','59242','59710','59551','59310','59710','59242','59283','59310','59148','59239','59283','59710','59242','59239','59310','59194','59273','59551','62790','59830','59261','59286','59870','59162','59194','59273','62820','59310','59830','62141','59310','59133','59310','59950','59830','59310','59870','59175','59113','59830','59167','59262','59119','59810','59830','59128','59175','59830','07611','62590','62970','59146','59133','59830','59870','59155','62220','59310','59690','59147','62119','59870','59139','59553','59553','59450','59780','59182','59790','59152','59152','59112','59230','07610','59152','59870','59147','62950','59263','59178','59226','59500','59139','59230','59780','59490','07624','59287','07502','59182','59287','59147','59870','59870','59187','59260','59251','59178','59176','59152','59176','59552','07618','62710','59553','59490','59112','62640','59552','07522','07504','62880','59169','59320','59179','59510','59185','62110','07620','07623','07621','07506','62740','07522','59320','62490','59171','59120','59000','59169','59800','59160','59350','59777','59165','59780','59226','59370','62440','59272','59178','62112','59580','07620','07522','59171','59178','59169','07620','07522','07620','59169','59510','07500','59136','59390','59320','62410','62880','62880','07620','59184','62117','62420','59211','62490','59221','07501','59110','59320','59215','62112','59580','62320','62320','07500','59171','07520','62880','59158','59130','62490','62138','59151','59170','59290','62490','59169','59234','07620','59496','62221','62218','59230','62320','59234','59700','59390','59134','59350','59320','07503','59151','59390','62410','59158','59158','59320','59320','07641','59274','62430','59390','07622','62490','07500','59320','59134','59124','62320','59135','07730','59134','62680','59320','62580','59520','59491','59493','59650','59655','62410','59230','07521','59230','59151','59234','59158','59160','62138','07642','59151','62490','07520','62580','59840','59172','59496','62300','59255','07640','59134','07536','59840','59118','59115','59156','59252','59220','62410','62490','59252','07730','62580','07548','59135','59134','62580','59151','59265','59420','59100','59840','62118','59172','59480','07730','62210','62860','59910','59247','59150','07730','07540','07640','59237','07743','62490','07643','62300','62118','59199','59249','07743','59195','59293','62138','59111','62580','59220','59480','59494','59259','59252','07904','07540','59249','59111','62580','59195','59200','59265','07542','07730','59199','62860','59220','59590','07640','07740','59247','62138','62750','62118','59282','62156','07712','59280','62138','62860','62860','59247','07530','07531','62156','59111','07538','07604','62580','62860','62580','59494','62580','59192','62860','07730','59121','07730','07608','62118','62840','62156','59295','59295','62118','59282','62118','59174','62860','62156','59111','59410','62860','59890','07543','62800','62860','62149','59223','59250','59126','62840','59265','59121','07740','59930','59554','07742','62149','59970','07604','62580','62156','62840','07700','59280','07604','59116','62143','62580','59860','07532','59141','07700','59224','62980','62149','62156','07540','59960','59265','07604','62160','07711','59265','62118','08587','62860','59268','59125','07534','59236','62156','59141','59554','62223','62149','59278','62153','07533','62860','62980','62182','07760','62149','59193','62223','59296','59400','59163','62136','62580','59300','08587','59880','62160','59890','59970','59233','07783','07601','08510','07760','07604','62182','59141','07600','59554','07540','59224','59300','62840','07534','59166','62223','62113','62113','62670','62223','59300','59770','62860','07602','62128','59198','62223','08587','59117','59161','62128','59554','08510','59554','07603','59560','07780','07780','62860','59161','62136','62153','62160','07760','59970','62840','62128','62182','07906','59850','59560','07782','07784','07760','62660','62114','59161','08511','07904','08930','07760','62223','07784','08554','62136','62217','59227','62144','59264','62223','59554','08510','62128','62223','08940','62290','62000','59269','62113','62128','07910','59188','62182','59277','07971','59213','08583','07911','08930','59163','59940','59990','59243','59269','59990','07971','08930','62400','62172','59161','59227','59227','62217','62144','59990','59188','59400','08560','07910','59181','07320','62860','59267','62860','62400','62217','59213','62128','07901','62530','59163','59129','07971','59400','62128','07971','59253','62860','59990','08957','07321','62136','62530','59154','07781','07911','08552','62217','62217','08582','08510','62530','07911','07910','62131','62131','62144','08940','62128','62860','59400','07904','07910','07910','62131','59990','62161','62161','62400','59269','08950','59267','59400','07760','62128','62128','08952','62217','07910','07900','07900','62147','59213','59213','07750','59990','62620','59400','59188','62147','07972','59940','07750','62232','59144','62128','59294','62620','62000','59217','07972','08551','62232','62232','59292','07350','59400','59920','08501','07911','07910','07750','07387','62144','59990','59159','07750','07903','07321','08980','07972','08953','08580','62175','07380','07973','62232','08902','62690','59940','62161','62690','62128','07903','62196','08550','07910','59530','07911','62232','08500','59281','62690','62128','62690','62128','62920','09690','07750','07903','62150','07350','62159','59213','59213','07912','08560','62161','08501','59530','07322','08950','59214','59144','62147','07380','59660','59217','62620','62940','07912','07973','08560','62144','59730','62199','62620','59400','62217','08956','59270','62350','62173','62690','59217','08980','08951','08553','07387','62150','59267','59159','62123','62175','62121','59730','62147','59241','59400','59400','59217','07911','59144','07387','07322','08890','62350','07812','62122','62124','59530','08980','08581','59730','62147','62920','62175','59730','62690','62690','08880','62121','08902','59157','62123','59530','62123','59144','09690','07382','08520','07970','59144','07812','62147','07387','07812','07350','59270','08902','62920','09690','09690','62690','62159','59157','62150','07387','62175','62150','59730','62124','08570','08958','62700','08530','59159','62173','62159','62124','08880','08573','62123','59270','62123','62123','08581','59530','62121','07387','62150','09600','07387','62175','62350','59258','62173','59530','59540','08570','62690','59271','59258','07950','07334','07370','62124','08540','59232','08880','62122','62121','07950','62150','62350','59540','59144','08900','59270','07812','62690','07387','62123','59218','59218','07812','08572','07350','07812','07370','59530','62690','59127','59570','07802','62173','62450','59231','62124','62147','59270','08980','62540','62123','59530','59218','59258','59530','62350','59191','08900','62121','62121','62450','62150','62690','08954','08531','62123','62123','07801','07911','08860','59730','07332','07334','09690','59218','07950','62124','08531','08570','07370','08970','62690','07951','08791','08570','59191','62690','59570','59530','62127','08900','07332','08890','62810','07300','62116','62123','62450','59540','62460','62124','59270','59270','62540','62350','62690','62116','62121','07387','59530','62157','62150','59570','59266','07387','59540','09790','62350','62450','59225','07950','62124','07890','62116','59570','09681','62121','59360','59570','59144','07333','62127','59530','59144','07890','62124','09700','62124','59191','07803','62123','62450','62810','08792','62470','08980','07800','62460','59299','08908','62116','08710','62450','07387','62690','07330','62124','62450','59190','08900','62150','62123','62111','59530','62810','07950','59225','59127','62190','62123','07370','08870','59222','07804','59231','62450','59980','59231','07301','59266','09790','08800','62123','62450','07331','62470','09790','62260','62121','59222','07340','07810','59570','62151','59190','59530','62450','08710','62124','62810','07804','59190','62127','09790','62810','59570','07811','08710','08790','08770','62810','08870','59570','59980','62330','62127','09680','07890','62260','62190','07390','62124','59127','62127','62121','59360','59222','59266','59270','62810','62450','62158','62460','62124','07340','07800','08800','59288') AND fami_id='5' AND cate_id='87' AND type_id='1' AND ssrubr_id='41' AND wish_id<>'305613' 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='41' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=540260 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 = 540260 AND W.type_id = 1) OR (W.util_id <> 540260 AND W.type_id = 2)) AND (M.post_util_id = 540260 OR M.dest_util_id = 540260) 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 = 540260
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='41' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=504658 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 = 504658 AND W.type_id = 1) OR (W.util_id <> 504658 AND W.type_id = 2)) AND (M.post_util_id = 504658 OR M.dest_util_id = 504658) 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 = 504658
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='41' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=339897 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 = 339897 AND W.type_id = 1) OR (W.util_id <> 339897 AND W.type_id = 2)) AND (M.post_util_id = 339897 OR M.dest_util_id = 339897) 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 = 339897
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='41' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=248307 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 = 248307 AND W.type_id = 1) OR (W.util_id <> 248307 AND W.type_id = 2)) AND (M.post_util_id = 248307 OR M.dest_util_id = 248307) 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 = 248307
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='41' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=319130 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 = 319130 AND W.type_id = 1) OR (W.util_id <> 319130 AND W.type_id = 2)) AND (M.post_util_id = 319130 OR M.dest_util_id = 319130) 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 = 319130
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='41' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=318960 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 = 318960 AND W.type_id = 1) OR (W.util_id <> 318960 AND W.type_id = 2)) AND (M.post_util_id = 318960 OR M.dest_util_id = 318960) 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 = 318960
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='41' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=236940 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 = 236940 AND W.type_id = 1) OR (W.util_id <> 236940 AND W.type_id = 2)) AND (M.post_util_id = 236940 OR M.dest_util_id = 236940) 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 = 236940
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='41' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=145922 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 = 145922 AND W.type_id = 1) OR (W.util_id <> 145922 AND W.type_id = 2)) AND (M.post_util_id = 145922 OR M.dest_util_id = 145922) 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 = 145922
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='41' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=134347 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 = 134347 AND W.type_id = 1) OR (W.util_id <> 134347 AND W.type_id = 2)) AND (M.post_util_id = 134347 OR M.dest_util_id = 134347) 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 = 134347
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 41
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