Recherche rainureuse béton à louer
Prix
20€/jour
Description
Bonjour, je souhaite louer une rainureuse béton très rapidement. #rainureuse
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Émerainville (77184) · publié depuis 3 mois ou +
Discuter
Prix
20€/jour
Bonjour, je souhaite louer une rainureuse béton très rapidement. #rainureuse
-100kg
qu'à l'achat
4x moins cher qu'en magasin
Annonces similaires
Tout voirLouer une rainureuse entre particuliers ou proposer une rainureuse 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='331033'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='rainureuse' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1046'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'rainureuse' 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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('77' 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='133071' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 133071
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 = 331033
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1046 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 133071 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='331033'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='331033' 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=133071 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 = 133071 AND W.type_id = 1) OR (W.util_id <> 133071 AND W.type_id = 2)) AND (M.post_util_id = 133071 OR M.dest_util_id = 133071) 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='133071' 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 = '331033'
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='133071' AND wish_id<>'331033' 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='77184'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.367039197041 AND ville_latitude_deg<49.266360802959 AND ville_longitude_deg>1.9337758163378 AND ville_longitude_deg<3.2995641836622 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 ('77184','77185','77340','77680','94420','77186','77420','77183','77090','77200','94510','93160','94350','77360','77600','94880','94490','94880','77135','77164','93460','77330','77600','77600','93330','94500','77400','77177','77500','94430','94360','77400','94370','94380','77600','94340','94100','94210','77400','93360','77400','77150','94170','77150','93220','94130','77600','77600','93370','77400','94470','94120','94440','94340','77181','77144','93110','94380','93250','77400','93470','77170','77410','77181','94410','94000','77173','94440','93320','93340','77400','93390','93190','77220','94440','77700','77270','77144','93130','77700','94460','77410','77220','77174','94450','93410','94700','94520','94520','94300','91330','93270','93140','77220','93100','94220','94140','94160','77700','77220','77170','77166','77450','93000','93260','93230','94190','77410','91800','77450','93170','77700','94600','93290','77174','91480','77410','91800','94400','77700','91560','93600','91860','77610','77220','77410','94200','77380','94205','77450','94290','93310','77450','94390','94310','77410','77170','77390','93420','91480','77410','93150','93700','91230','77580','94320','77166','94270','93500','77450','77610','94480','94800','77290','77860','77111','77410','77450','91200','77410','77450','93350','91270','77610','77860','77610','77111','77410','77450','94550','93300','93120','75002','75016','75017','75009','75018','75007','75000','75005','75014','75004','75013','75003','75012','75008','75011','75001','75019','75020','75116','75015','75006','75010','77290','94250','93440','94110','91210','94150','77127','94237','94239','94230','94235','94231','94232','94233','94234','94238','94236','94240','77230','95500','91550','77580','77580','77390','77860','95700','77580','92120','77163','77610','91250','77410','95500','95140','91450','77550','77990','77163','77100','77610','92340','77610','77550','77230','95500','93240','91260','93400','91320','77550','93200','93210','95500','77165','77580','77390','91450','77163','92240','94260','92170','92220','77230','77100','77124','95400','91130','91000','77165','77165','91000','91090','77230','77390','91280','77390','91170','77124','77550','77230','77390','77990','91250','92160','77100','93450','92390','92320','91420','95380','92330','92260','93380','77165','95190','77230','92110','77580','91350','77230','93430','95380','91250','77580','92130','77515','95360','77470','92140','91600','91390','77390','92350','77230','95720','91100','77390','77124','77390','77580','92300','77540','91300','77230','77176','77950','77580','92290','77515','95380','77230','92600','92230','95400','95200','91380','91160','91360','95380','77950','92200','91370','95410','77124','92100','93800','77122','91080','95350','77390','91700','92360','92190','95880','77165','91360','77470','95170','77240','77230','77240','77390','77176','77470','92270','95440','77950','95470','91070','92400','77515','77230','95720','91090','77390','77950','77540','92250','77131','77470','77470','77720','77580','92150','92800','95190','77390','91100','77230','91160','77580','92700','77470','95160','77910','91120','91830','91250','91700','77720','77515','92210','95380','95218','95210','77910','95350','91160','77540','91160','95230','91700','91140','95470','77280','77240','91570','95460','60330','77950','95190','77115','95720','77120','92310','92370','95100','77470','77540','77120','91430','77131','77515','77910','95580','95670','95580','95850','77178','77950','91540','91540','91240','77139','77120','77165','77720','77165','92410','60330','91220','91220','92500','77178','77720','77350','95110','95120','60128','91620','77310','77000','77000','95600','77910','95330','77540','91140','78140','92380','91310','77580','92000','95470','60950','91430','77310','95720','95870','91540','95850','92420','92430','95570','78800','77540','77120','77720','77540','77660','91310','91310','95470','95680','77115','91830','78220','95270','95570','91810','60330','95270','77350','60128','77139','78350','77350','77190','77310','78420','95130','91540','91620','77440','77000','95270','95270','95390','77139','77120','95270','77720','60330','91400','91750','77820','91400','78170','77440','95130','91460','77660','95570','60440','95570','95320','91710','91310','78400','77120','78500','60440','77720','77640','95560','77139','77000','78000','91440','91630','91750','77120','77440','95240','60520','60950','77370','95530','78290','78380','78530','78350','78360','95270','60560','60950','78150','91180','91940','95560','77720','91630','91750','95270','95560','77440','77720','91290','91610','78150','95370','77120','95560','95270','77720','91940','78430','95270','77190','91190','60520','77260','78600','77260','77141','95840','78560','78117','60520','91290','77930','77370','60440','77590','77260','77440','60440','77440','77820','95250','77440','77440','78110','91770','77169','91630','95150','95550','77930','78600','91190','95590','91940','91190','77370','60580','77590','95220','91630','78230','77970','91640','91680','77120','78117','77930','95740','77139','77820','91340','91520','77169','78870','60300','60300','91630','91760','77590','60260','78160','77510','95840','77440','77930','95270','95480','60440','78750','60620','60300','91590','77640','78100','91840','95270','77930','91400','91590','78210','78590','77120','60620','95590','77260','60620','78620','91850','78280','77440','60620','77630','91640','95270','77370','60300','78112','77930','91890','78470','77145','95540','78114','77970','77169','78330','78590','77440','91790','77320','91680','91590','77920','77370','78700','77370','91510','95590','91510','78960','77850','91650','91490','77370','91730','77260','60440','95630','95430','60440','78470','60300','60300','77169','60620','95260','77630','77370','91640','77750','77133','60440','60620','95430','60300','60300','78180','77260','91650','91470','60270','91590','78300','95260','60820','78460','78260','95290','91470','78240','77750','60500','77320','77133','95760','77440','95610','91640','77370','91470','77510','78450','78390','60500','77870','91490','78860','91470','60620','95660','77840','78570','91490','77320','95620','60620','91650','77370','91730','60300','60810','60890','95820','77138','77320','91590','77830','91730','91910','95310','78240','77970','60810','78470','91530','77630','95340','78780','78955','77260','77320','95340','77510','78190','60800','91470','77210','60620','60620','91590','77730','95300','60800','91820','95000','77370','91590','77830','77750','60740','60300','77370','60460','78340','60810','77510','78460','77970','60800','78570','78450','91580','91580','91580','77840','91820','77300','60340','60890','95000','77440','95300','60300','77210','77830','77750','77510','77730','78720','60810','91530','60340','60230','95300','95690','91580','60530','78670','78670','91590','77970','77730','91490','77320','78630','91720','78810','60800','77810','91470','78720','77154','60800','95280','02310','60620','60890','77320','78830','77160','60700','77430','91580','77750','60530','78320','77320','77320','02810','77370','91880','95340','77520','78510','78720','60620','78370','95520','77840','77154','95490','78990','60460','95690','91530','77160','02310','77510','95300','77730','78540','91490','60890','78320','91720','95690','60530','91580','60530','60620','60800','60890','78480','95650','60800','60160') AND fami_id='5' AND cate_id='87' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='1046' AND wish_id<>'331033' 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='1046' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=527122 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 = 527122 AND W.type_id = 1) OR (W.util_id <> 527122 AND W.type_id = 2)) AND (M.post_util_id = 527122 OR M.dest_util_id = 527122) 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 = 527122
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='1046' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=462610 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 = 462610 AND W.type_id = 1) OR (W.util_id <> 462610 AND W.type_id = 2)) AND (M.post_util_id = 462610 OR M.dest_util_id = 462610) 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 = 462610
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='1046' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=197288 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 = 197288 AND W.type_id = 1) OR (W.util_id <> 197288 AND W.type_id = 2)) AND (M.post_util_id = 197288 OR M.dest_util_id = 197288) 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 = 197288
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='1046' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=420284 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 = 420284 AND W.type_id = 1) OR (W.util_id <> 420284 AND W.type_id = 2)) AND (M.post_util_id = 420284 OR M.dest_util_id = 420284) 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 = 420284
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='1046' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=403697 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 = 403697 AND W.type_id = 1) OR (W.util_id <> 403697 AND W.type_id = 2)) AND (M.post_util_id = 403697 OR M.dest_util_id = 403697) 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 = 403697
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='1046' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=373377 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 = 373377 AND W.type_id = 1) OR (W.util_id <> 373377 AND W.type_id = 2)) AND (M.post_util_id = 373377 OR M.dest_util_id = 373377) 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 = 373377
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='1046' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=318901 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 = 318901 AND W.type_id = 1) OR (W.util_id <> 318901 AND W.type_id = 2)) AND (M.post_util_id = 318901 OR M.dest_util_id = 318901) 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 = 318901
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='1046' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=292661 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 = 292661 AND W.type_id = 1) OR (W.util_id <> 292661 AND W.type_id = 2)) AND (M.post_util_id = 292661 OR M.dest_util_id = 292661) 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 = 292661
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='1046' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=290968 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 = 290968 AND W.type_id = 1) OR (W.util_id <> 290968 AND W.type_id = 2)) AND (M.post_util_id = 290968 OR M.dest_util_id = 290968) 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 = 290968
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='1046' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=260197 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 = 260197 AND W.type_id = 1) OR (W.util_id <> 260197 AND W.type_id = 2)) AND (M.post_util_id = 260197 OR M.dest_util_id = 260197) 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 = 260197
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