-300kg
qu'à l'achat
Description de l'annonce
Bonjour, je cherche une bétonnière a louer 350L. Merci.
#Betonniere
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-300kg
qu'à l'achat
Bonjour, je cherche une bétonnière a louer 350L. Merci.
#Betonniere
Louer une betonniere entre particuliers ou proposer une betonniere en location.
Poster une annonce
-300kg
qu'à l'achat
Envoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
SHOW TABLES LIKE 'pays'
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='367254'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='betonniere' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='73'
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 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='179264' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 179264
SELECT util_cp FROM utilisateur WHERE util_id=179264 LIMIT 1
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 367254
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=73 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 179264 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='367254'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='367254' 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=179264 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=179264 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 = 179264 AND W.type_id = 1) OR (W.util_id <> 179264 AND W.type_id = 2)) AND (M.post_util_id = 179264 OR M.dest_util_id = 179264) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '367254'
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='179264' AND wish_id<>'367254' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (w.wish_area IS NULL OR w.wish_area='' OR w.wish_area='FR')
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59253'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.6333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.6333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.7- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.183639197041 AND ville_latitude_deg<51.082960802959 AND ville_longitude_deg>1.9910630963833 AND ville_longitude_deg<3.4089369036167 HAVING distance <= 50 ORDER BY distance ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('59253','59940','62136','59940','62840','59660','62840','62136','62136','59940','62350','62136','62400','62840','59232','62232','62840','59181','62149','62400','59270','62840','62350','62350','59249','62350','59270','62350','59270','59249','59270','62920','62350','59193','59850','62920','59480','62400','62149','62138','62232','62232','59134','62660','59134','59280','59190','59480','62149','59270','59190','59134','59280','59134','62350','62232','62138','62920','59496','62232','62138','59190','62113','62113','62149','59270','59190','59190','59274','62149','62113','59930','62199','62330','59320','07783','62131','62131','08950','59189','59134','08951','62122','62138','59496','62131','07782','62196','59320','59189','59320','59270','62980','62980','62290','59184','59116','59136','62190','08958','62190','62122','62138','59320','62620','08952','62330','59840','59272','62157','59189','59211','08950','59114','59114','59221','59320','62670','08954','59299','62410','59320','59270','59236','59190','59160','08956','59173','62190','62410','59840','62540','59190','62540','62410','62410','59112','62151','62700','59185','59320','62190','08957','59114','62620','62940','59320','62114','62160','62530','08970','59890','59251','59147','59670','62120','62750','62620','62120','62190','62120','08953','62120','59840','59320','62120','07784','59560','59237','59190','62120','59114','62880','62620','59173','62190','62190','59147','62260','62160','59120','59173','59263','62880','59670','62880','62470','62120','08900','59112','59147','59139','62260','07784','59890','62460','59670','62470','62150','62120','59130','62120','62120','59133','62260','59173','08902','62260','62550','59670','62880','62160','62150','62300','62150','62172','62530','62143','59350','62800','08970','59670','62120','62120','62440','62550','62120','62145','62150','62220','62221','62218','07781','59118','62190','59113','59139','08902','59670','62300','62150','62460','07780','07780','59670','08978','59670','59175','62530','59133','62550','59777','59000','62120','59350','59800','59160','59110','62120','59173','62550','62550','08908','62710','59520','62150','62150','62120','62960','59670','62960','62120','59155','62690','59560','62430','62550','59175','62550','62740','62550','62590','62550','59700','08902','62120','08900','62210','62150','62145','62640','62144','62153','62820','62550','59551','62420','62153','08900','59670','08980','62580','62120','59670','62460','62690','59790','62680','62150','62550','59470','08972','59117','59370','59239','59261','08940','62690','62127','59910','08906','62110','59126','59223','59250','59710','62960','59670','62129','59260','08900','62127','62129','62144','62690','62550','59239','59285','59810','62145','62119','62690','59470','08640','62575','62145','08980','59470','62130','62320','62580','59166','62960','59551','62134','62550','62690','59162','62320','08904','62950','08972','62510','59420','59470','62144','59491','59650','59493','59655','62144','62129','62320','62320','59285','62500','62690','62580','62690','62580','62575','62129','59290','59170','59273','62690','62127','08640','08972','59710','62960','62690','59470','62580','59122','62690','62580','62141','62550','59710','62570','08640','08904','62970','62580','59710','62550','08940','08980','59200','59246','59285','62690','62580','62130','62127','59262','08980','08640','62130','59470','62690','62960','62223','62144','59100','59143','59273','62960','62134','59283','62134','62580','59510','62129','62790','62570','08691','62500','59960','62127','62130','59380','62570','62490','62127','59950','59830','08920','62130','62219','08920','59242','62960','62134','08930','59470','62690','62580','62580','62127','59283','62134','08920','62161','62161','62570','59510','62129','62500','59122','62223','59242','59152','59152','08647','62223','59143','62490','59310','62134','62580','62130','59128','59470','59470','59235','62500','62127','62690','59380','59286','62219','08920','62380','62380','59152','59830','59390','08647','59470','59390','62560','59152','08930','59143','62127','62127','62134','08890','59390','08647','62161','08650','62161','62690','59553','62130','62380','59150','59380','62490','62560','62134','59830','59553','59553','08980','59380','62123','62223','62130','62223','62500','62123','62123','07712','59780','08647','08560','62223','62123','07700','62134','59390','62380','62134','62134','62127','08691','62130','62130','59242','62310','08691','62500','59122','62223','62310','08890','62130','08690','59470','62810','62130','08930','59143','62310','08647','59830','62310','62560','62130','59380','62127','08880','62490','62000','59194','59780','62123','59310','62310','59470','59115','62500','59780','62810','62118','62000','59500','62127','08691','62560','59830','62127','07700','62810','08840','08560','59122','62134','62810','62910','59143','62118','62380','62134','62380','62560','62910','59552','59630','62130','59380','62118','07730','62310','62130','62130','62117','08691','62380','62380','08690','62223','62310','59119','62127','62130','59552','62380','08511','59143','07730','59830','62810','62134','59310','62134','62130','07730','62123','62130','62130','62500','08880','62123','07520','62310','62217','62217','59194','62310','62310','59830','62118','59148','62560','62123','62217','08600','59380','62810','62500','62112','59380','59310','07522','62810','62118','62217','59380','62130','59450','62118','62810','62910','07522','59310','62310','59380','62270','59284','08690','08650','08510','07730','59169','62810','62310','08510','08840','62130','62490','08630','08560','62560','08630','62910','62270','08630','62130','59143','08600','59492','07522','62810','08501','62130','08600','62910','08650','62112','62130','62310','59187','62118','59167','07730','07502','59310','62810','08880','62270','08690','62217','62123','62217','07610','62810','62560','08600','07711','62130','62130','62310','62310','08510','59630','07730','07522','59122','08840','62810','07611','07730','62380','62310','08501','62500','62128','62380','62810','62490','62130','62810','62156','62310','59310','62173','62173','62128','62490','62123','62123','62380','08600','62123','62770','62130','62130','59287','59870','62770','62270','62310','07504','07520','59630','62130','62380','62560','62217','62910','08800','59169','59151','62130','59229','08500','62810','07740','59380','62156','59182','62890','62158','62128','62270','62490','59310','62310','08630','59287','59182','62130','62156','62770','59310','08600','59870','08800','62128','59630','59380','07743','08600','62560','59146','07501','62270','62270','62156','62128','59380','08510','59169','62890','62156','08630','07503','07618','07740','08600','08630','62173','62173','08630','07506','08610','08600','62123','59229','62370','62156','62810','08600','62123','08800','62770','62770','62175','59630','07743','62770','62128','62128','62270','59259','62810','08860','62380','08630','08587','08830','07742','62310','62270','59176','59169','62270','59495','59151','62810','07500','62270','62158','62380','62890','62380','59180','08520','62560','62270','59690','59310','08870','62770','59254','62770','08610','62890','59151','62156','08870','59870','08630','62175','07620','59176','59169','62270','62380','62158','62175','08587','62380','62810','08600','62175','62123','07624','62270','08610','62650','62175','62370','07500','62860','08554','62890','59870','62128','59226','62310','59151','62158','62128','59490','59870','08800','08630','08830','07540','08600','08550','59230','59210','62810','62860','08870','08600','08530','08587','07542','07500','59279','62310','08660','07620','62182','62860','62370','62650','62770','62890','59630','62770','62380','62128','62860','62860','59178') 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='73' AND wish_id<>'367254' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=462648 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 = 462648 AND W.type_id = 1) OR (W.util_id <> 462648 AND W.type_id = 2)) AND (M.post_util_id = 462648 OR M.dest_util_id = 462648) 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 = 462648
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=451068 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 = 451068 AND W.type_id = 1) OR (W.util_id <> 451068 AND W.type_id = 2)) AND (M.post_util_id = 451068 OR M.dest_util_id = 451068) 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 = 451068
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=449463 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 = 449463 AND W.type_id = 1) OR (W.util_id <> 449463 AND W.type_id = 2)) AND (M.post_util_id = 449463 OR M.dest_util_id = 449463) 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 = 449463
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=433537 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 = 433537 AND W.type_id = 1) OR (W.util_id <> 433537 AND W.type_id = 2)) AND (M.post_util_id = 433537 OR M.dest_util_id = 433537) 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 = 433537
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=355061 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 = 355061 AND W.type_id = 1) OR (W.util_id <> 355061 AND W.type_id = 2)) AND (M.post_util_id = 355061 OR M.dest_util_id = 355061) 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 = 355061
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=266659 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 = 266659 AND W.type_id = 1) OR (W.util_id <> 266659 AND W.type_id = 2)) AND (M.post_util_id = 266659 OR M.dest_util_id = 266659) 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 = 266659
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=252042 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 = 252042 AND W.type_id = 1) OR (W.util_id <> 252042 AND W.type_id = 2)) AND (M.post_util_id = 252042 OR M.dest_util_id = 252042) 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 = 252042
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=237673 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 = 237673 AND W.type_id = 1) OR (W.util_id <> 237673 AND W.type_id = 2)) AND (M.post_util_id = 237673 OR M.dest_util_id = 237673) 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 = 237673
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=235069 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 = 235069 AND W.type_id = 1) OR (W.util_id <> 235069 AND W.type_id = 2)) AND (M.post_util_id = 235069 OR M.dest_util_id = 235069) 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 = 235069
SELECT ssrubr_slug, ssrubr_title, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='73' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=206700 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 = 206700 AND W.type_id = 1) OR (W.util_id <> 206700 AND W.type_id = 2)) AND (M.post_util_id = 206700 OR M.dest_util_id = 206700) 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 = 206700
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (87) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (88) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (81) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (110) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (227) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (176) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (79) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (208) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (228) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (207) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (95) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (173) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (83) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (93) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (193) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (91) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (232) ORDER BY ssrubr_order ASC
SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (92) ORDER BY ssrubr_order ASC
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT COUNT(*) AS nbavis FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
Contactez-nous