Discuter
Description de l'annonce
Loue bétonnière thermique tractable grande capacité 330 litres #betonniere
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Loue bétonnière thermique tractable grande capacité 330 litres #betonniere
Annonces similaires
Tout voirLouer une betonniere entre particuliers ou proposer une betonniere en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
35€
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='625645'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'betonniere' 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='62'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='508573' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 508573
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 = 625645
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=73 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='625645'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='625645' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 508573 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=508573 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 = 508573 AND W.type_id = 1) OR (W.util_id <> 508573 AND W.type_id = 2)) AND (M.post_util_id = 508573 OR M.dest_util_id = 508573) 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='508573' 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 = '625645'
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='508573' AND wish_id<>'625645' 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='62156'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.2667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.2667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.95- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.817039197041 AND ville_latitude_deg<50.716360802959 AND ville_longitude_deg>2.2465348074258 AND ville_longitude_deg<3.6534651925742 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 ('62156','62156','62156','62156','62156','62118','62118','62156','62118','62118','62490','62118','62128','62128','62156','62118','62182','59259','62118','62128','62490','62128','62860','62182','62182','62128','62223','62860','62182','62490','62490','62490','62490','62860','62860','62128','62580','62117','62128','62112','62860','62223','59151','62128','62217','62860','62580','62128','62128','62860','59151','62217','62580','62112','62580','62860','59151','62128','62860','59169','62490','62860','62223','62217','62860','62128','62490','62580','62860','59552','62128','62217','62000','62860','59169','62175','62128','62580','59553','59169','62860','62580','62580','59552','62223','62159','62217','62217','59151','62223','62320','62320','62860','62121','62320','62223','62320','59500','62121','62175','62580','62580','59151','59553','59553','62159','62124','62223','62175','62159','59187','62223','62147','59265','62860','59265','62147','62860','62173','62680','62580','62121','59169','62175','62217','59450','62121','59169','59265','59128','62000','62110','62124','62124','62124','62950','59287','62210','59234','62121','62121','62450','62420','62147','62175','59554','62450','62970','62173','59119','59400','59554','62147','62430','62147','59234','59247','59182','59287','62450','59950','62121','62580','62640','62124','62161','62161','59265','62740','62119','59247','62121','62116','59400','62450','62300','59286','62450','62147','62153','62161','59234','62173','59265','62221','62218','62141','62173','59268','62450','62116','62144','59176','62116','59167','62123','62116','59267','59182','62123','59247','62300','62790','62450','62710','62124','62161','62121','59267','59554','59194','62450','62124','62440','59283','62450','59554','59554','62450','62124','59267','62153','59176','62800','59194','59162','62123','59252','59165','62123','62123','59159','62143','62121','62144','59159','62450','59580','62111','59554','62124','62880','62590','59283','62450','62147','59252','62124','59580','59252','59161','62124','62880','62880','62123','62123','59146','62144','62880','62450','59400','62116','62123','59400','62144','80300','62450','59159','62750','62144','62123','59111','62123','59161','62124','59295','59295','62123','62123','59141','59490','59281','62220','80300','62124','62450','62124','59231','80300','59148','62690','62123','62160','62116','62820','59261','62160','59870','59400','62690','62410','59239','62111','62123','59172','62450','59241','62690','62410','80360','59141','62160','59310','62410','80360','59215','80360','59870','59161','62111','59246','80360','80360','59111','62810','62172','59111','62123','59490','62530','62111','80300','59141','62410','80360','80300','62690','62111','59161','62450','80360','62690','59231','59239','80360','62690','62111','59310','62530','59400','62158','62690','59179','62810','80360','59400','62810','59172','62158','59551','62158','62114','59112','59185','59133','62690','59235','80240','59231','62111','59221','59133','59870','59258','59171','59870','59400','62138','80360','59111','62670','59266','62810','59710','62980','62810','80300','59551','59258','80360','59293','59156','62158','59400','62138','80360','62450','80300','62690','59258','62980','62690','59124','80122','62690','59171','59277','62760','62530','80300','59297','59251','62810','59112','59147','80360','62138','62690','59310','62150','59870','80300','59266','59310','80240','62690','62149','62138','59710','62111','59496','62158','80240','59217','62149','59496','80300','59282','59296','62150','62150','62111','80560','62690','59266','62810','59282','59400','59217','62760','80560','59710','80240','62149','62690','62620','80560','62290','62113','62113','59480','59147','80760','59272','59147','62690','80200','59171','59220','59184','59129','80300','59242','80300','62138','59870','59870','80300','80560','59127','62810','59274','59113','59310','62149','62810','62810','80300','62760','59710','59217','80740','62127','59188','80360','62113','62158','80300','80300','80360','59178','62150','80560','62620','62760','59157','62810','59198','59255','80112','59242','80560','59136','59217','59263','59310','62660','59188','02420','80240','62620','59310','62150','59135','59134','62760','62760','59178','62127','59220','59230','59191','62131','80300','62158','59273','59134','59175','80240','80240','62127','59292','62620','62940','59157','80560','62131','62131','80300','59480','59175','80360','02420','62810','62127','62760','62810','59310','80300','80300','80360','59188','62127','59121','59230','62127','59178','59214','80560','62149','80560','02420','80740','59220','59242','80600','59127','62127','80200','80200','62840','80240','80360','59134','59139','80200','62810','59127','59195','62810','59224','59227','59227','59191','62150','62196','59139','80200','62127','59121','59142','59191','59135','80560','62760','59830','59155','59127','80240','59310','59690','59540','80560','80560','62232','59310','80300','80300','02420','02420','62127','59195','59273','62810','59224','80300','80240','02420','62150','62810','62150','59178','62810','80560','59211','62150','80560','80200','80200','62840','59134','59320','59810','62700','62400','62127','59226','59320','62232','62400','59830','80200','80810','62760','59540','80340','02420','80300','59249','80240','62136','62127','62232','62232','59227','62810','59249','59225','80240','80560','59494','59225','62199','62270','59233','80560','59127','80340','62127','59125','59294','59830','59262','62760','07611','62760','59790','59320','80600','59830','80560','02110','62122','62460','62136','59830','62460','59226','62400','80340','59320','59320','80200','80240','02420','59230','59320','80200','59320','59271','59174','59730','59213','62810','59134','59120','80200','07624','62810','62760','80240','59540','80200','62136','59494','80300','62760','59730','62127','59830','80200','02490','62127','80560','62127','62460','59590','62920','02490','59830','62540','62920','59730','62130','80300','59213','59269','80300','80560','62760','59540','62270','62122','02420','59410','80340','80340','62130','59300','59260','02110','80600','07610','59320','59320','62232','62470','80300','02420','59980','02490','07623','59238','59152','59152','59780','59192','80560','59980','02420','80980','62130','80600','80340','62270','62760','62270','59213','59213','80300','59000','59800','59160','59350','59777','59152','80200','80240','80340','80300','62130','62130','62270','59300','80300','62810','59730','62760','59158','80240','62470','07621','59980','59980','62130','59730','07618','62130','62540','07502','80300','59300','80340','80300','59840','62270','59160','80200','07620','80200','59780','62840','59269','80300','02110','59213','59213','62130','59280','80200','62550','59360','62130','62260','80240','59158','80600','62920','59130','59980','02420','07620','80340','59370','80200','80200','59230','62136','59152','59860','80200','62840','59110','80200','62350','62130','62157','59770','80340','80200','80800','07504','59230','80300','59269','07620','62550','02110','62260','59158','80200','80240','07620','59940','59510','59880','02420','80560','80600','59730','80600','59990','07620','80600','59350','07522','80800','02420','59253','07506','62270','59840','62840','80560','80560','80113','02110','80600','80200','59840','80200','80600','62130','62550','62550','59199','80560','02490','59530','80200','59137','62130','62270','62270','59990','59530','80200','07622','62151','80340','59158','62550','02420','07522','59780','59700','02110','62350','80340','02490','07620','59990','02420','80600','62130','59218','59218','02490','02490','59360','80800','62550','59360','07500','59199','62350','59218','80200','07522','62270','80113','59360','59510','80121','02490','59520','80800','02110','80800','62130','07500','59222','80200','62130','59930','59237','59390','59660','59280','59170','59290','62350','80320','02490','07522','62130','62130','59990','62130','59218','59278','62550','59193','59118','07641','80200','80800','80600','07501','59222','62260','62190','62130','59990','80260','59940','59970','62270','62270','59530','62350','62270','59530','80600','02420','80260','80260','02110','80630','59144','80340','02100','80320','62550','59264','62550','07520','02110','59360','62130','62350','80200','80131','59116','80200','80200','62550','80800','80800','80800','59491','59493','59650','59655','59390','80320','02760','80320','80800','02230','62130','80340','80200','59530','59970','59530','62190','07640','59530','59390','07642','59360','59390','07503','80260','62550','02490','59850','62550','07521','62260','02110','07500','80260','02110','02110','59970','59243','02100','02100','62190','02590','80260','80600','62130','59940','59222','62190','62190','07783','59910','59163','02100','07608','59530','07640','62190','59181','80131','80260','62130','62270','62270','07536','62550','07730','59360','80600','80170','59420','07643') AND fami_id='5' AND cate_id='87' AND type_id='1' AND ssrubr_id='73' AND wish_id<>'625645' 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='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=444611 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 = 444611 AND W.type_id = 1) OR (W.util_id <> 444611 AND W.type_id = 2)) AND (M.post_util_id = 444611 OR M.dest_util_id = 444611) 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 = 444611
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='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=347813 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 = 347813 AND W.type_id = 1) OR (W.util_id <> 347813 AND W.type_id = 2)) AND (M.post_util_id = 347813 OR M.dest_util_id = 347813) 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 = 347813
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='73' 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='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=268608 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 = 268608 AND W.type_id = 1) OR (W.util_id <> 268608 AND W.type_id = 2)) AND (M.post_util_id = 268608 OR M.dest_util_id = 268608) 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 = 268608
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='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=82038 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 = 82038 AND W.type_id = 1) OR (W.util_id <> 82038 AND W.type_id = 2)) AND (M.post_util_id = 82038 OR M.dest_util_id = 82038) 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 = 82038
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='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=54434 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 = 54434 AND W.type_id = 1) OR (W.util_id <> 54434 AND W.type_id = 2)) AND (M.post_util_id = 54434 OR M.dest_util_id = 54434) 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 = 54434
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='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=317594 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 = 317594 AND W.type_id = 1) OR (W.util_id <> 317594 AND W.type_id = 2)) AND (M.post_util_id = 317594 OR M.dest_util_id = 317594) 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 = 317594
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='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=307565 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 = 307565 AND W.type_id = 1) OR (W.util_id <> 307565 AND W.type_id = 2)) AND (M.post_util_id = 307565 OR M.dest_util_id = 307565) 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 = 307565
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='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=293829 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 = 293829 AND W.type_id = 1) OR (W.util_id <> 293829 AND W.type_id = 2)) AND (M.post_util_id = 293829 OR M.dest_util_id = 293829) 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 = 293829
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='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=272633 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 = 272633 AND W.type_id = 1) OR (W.util_id <> 272633 AND W.type_id = 2)) AND (M.post_util_id = 272633 OR M.dest_util_id = 272633) 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 = 272633
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 73
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