-300kg
qu'à l'achat
Description de l'annonce
Bonjour je recherche une bétonnière pour samedi prochain
#Betonniere
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-300kg
qu'à l'achat
Bonjour je recherche une bétonnière pour samedi prochain
#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='513310'
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='355061' 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` = 355061
SELECT util_cp FROM utilisateur WHERE util_id=355061 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 = 513310
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=73 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 355061 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='513310'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='513310' 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=355061 LIMIT 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 `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 = '513310'
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='355061' AND wish_id<>'513310' 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='59221'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.5167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.5167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.88333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.067039197041 AND ville_latitude_deg<50.966360802959 AND ville_longitude_deg>2.176145768042 AND ville_longitude_deg<3.590514231958 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 ('59221','62138','62410','59496','59185','62138','59274','59184','59496','59112','59272','62410','59251','62410','62880','62880','59134','62880','62138','59112','62410','59134','59136','62880','59480','59480','59147','62220','62138','59133','62138','59147','59134','62440','59147','62710','62149','62840','62590','62221','62218','62149','59133','59249','59134','62740','59249','62300','62640','59263','62820','62840','62750','59211','62149','59134','62430','62420','62149','59113','62980','59261','59320','59320','62119','59320','59320','62110','59551','62149','59239','59139','59320','62300','62136','62980','59239','59320','62160','59162','59175','62680','62113','62113','59320','62950','62210','59320','62800','62136','59139','62141','59175','62670','62660','59320','59551','59710','59120','62143','62970','59280','62320','62320','62136','59155','62160','62320','62320','62840','62840','62113','59840','62400','62290','59160','62790','62114','59283','59246','59950','62400','59710','59710','62580','62580','59283','62840','62580','62160','62580','62490','59940','59128','62153','59840','62400','59710','62131','62131','59790','62136','59286','59273','59810','62530','62490','62131','59130','59253','59000','59800','59160','59350','59777','59280','62580','59310','59930','59840','59193','62580','62580','62232','62580','62232','62232','62172','62153','59553','59553','59553','62620','59235','62580','59350','62232','59110','62144','59260','62530','62232','59242','59242','62196','62620','59237','62580','62920','62580','59116','62580','59850','62490','59273','62530','59194','59370','59500','62199','59940','07783','59262','59181','62490','59700','62350','59660','59520','62620','62940','59940','59118','59552','62223','62350','59119','62122','59552','59830','62920','62117','62620','59236','62144','62144','59830','59310','62690','59194','62150','62920','62223','07782','59148','59450','62112','59310','59242','59890','62150','62690','62700','62118','62223','59169','59830','62350','62118','59152','59152','62690','62223','62118','59890','62118','62490','62122','62223','62118','62144','59187','59510','62150','59167','62350','59830','59170','59290','62112','62223','59152','59310','62223','59910','62690','62161','62161','62150','62150','62690','08950','62540','59491','59493','59650','59655','59310','62350','59152','62223','62118','62150','59560','59270','62690','59287','07784','59830','59510','62490','62000','62350','59780','59232','59420','62150','59270','62144','59169','62540','62157','08952','59182','62490','62690','59182','59287','59270','59830','59151','59780','07784','59870','59830','62460','08957','62690','59169','62118','62690','59146','62350','59223','59250','59126','59780','62690','62161','59870','62490','59390','62217','62156','59310','59270','07780','07780','62000','62470','59310','59100','62161','08951','62150','62217','62156','62190','59390','62217','62217','62156','62127','59390','59176','59200','08950','59169','59310','62460','59560','62151','62260','07611','59151','62128','62128','62470','59310','59259','59390','62690','62156','62123','08956','59169','08953','62690','59176','62217','62156','62127','07610','62123','59151','59270','59117','62156','07522','62190','62330','07502','62150','08958','07781','07522','62123','62123','59151','62260','59870','59270','62690','59490','59870','62690','62190','62156','59150','59166','62690','59190','08940','62123','07520','62860','62128','62128','62128','62123','62860','07730','62128','59115','62550','62860','07522','62460','59960','59870','59310','59690','59190','62217','59165','59234','07504','62190','08902','59270','62123','07712','62860','62860','07522','62330','62217','08954','07618','59230','59190','59189','62127','59490','59189','59190','59151','62260','59580','59178','62190','62190','62550','59226','59190','62173','07730','62690','59870','08902','62190','62120','62128','07624','62550','62810','07506','62123','08980','62128','62182','62130','59870','62810','59234','62550','59230','62127','62175','59179','62182','62860','59299','08900','07700','08970','62550','59580','62260','07730','07501','59265','59178','59234','62182','62550','62127','62173','07620','59189','62127','62127','59171','62120','07500','07730','62860','62127','07700','07730','62128','07503','08940','62550','07520','62120','62173','62860','62810','08902','08930','62128','62182','59270','62550','62123','62123','62860','07621','08930','62810','59114','07623','59265','07730','62127','59215','07620','62120','62810','62175','59171','62123','62175','62127','08980','62173','62860','62810','59114','62175','59247','62123','62120','62120','62550','62550','62130','07620','07500','62190','59252','59173','07743','62175','62860','62127','07620','62120','62127','59226','07730','59178','59190','07500','62128','62128','62128','08900','62810','59247','07740','08560','62121','07620','62860','62860','62810','59252','07743','08930','62120','62120','62130','62550','59178','62860','62550','62123','62960','62960','08908','62550','62127','62810','59114','59190','62120','62121','08511','07711','59171','59172','62550','62120','08980','62123','07620','08510','59247','62158','07540','08900','07740','07641','62145','07521','59124','62130','59252','59265','59158','62128','62121','08970','08900','62130','62116','62810','59670','59265','62123','07536','07548','62121','07742','07642','07542','62550','59111','59173','59173','62860','62127','62127','59156','07622','62130','62130','62810','59172','59114','59230','08890','59190','62960','62134','59554','59158','62111','62130','62810','59265','08510','59111','08510','59135','08587','08980','62116','07640','62120','59158','59554','08510','62130','62116','62860','62145','62159','59220','62158','59268','59670','62270','62120','08560','59255','62810','59295','59295','62159','62810','62158','59293','62120','08906','07540','59158','07904','59554','59230','62810','59111','62130','08587','08880','59554','59230','62810','62134','62130','59670','59173','62120','62130','62860','62130','08501','62134','62158','07643','62116','62111','07640','59670','08978','08904','59670','59135','59141','07543','07531','62960','08587','62159','62158','62130','62111','08560','62121','62121','62147','62270','59282','62124','59220','08554','62270','62810','59554','62120','62145','59400','62121','08640','62130','59195','62810','59111','62121','62111','62130','08880','07760','62130','07530','08890','08501','62134','59670','59670','62147','59173','08980','62120','62120','59161','59400','08500','62130','59670','62130','59282','62134','59220','59199','59400','59141','59494','07640','07760','08920','59195','07538','62147','62145','62810','08972','62450','62158','62450','59161','08904','62450','59141','62116','62134','62760','62124','59554','07540','59670','62120','62450','62960','62134','62810','08920','62124','59121','62129','62270','08920','62760','59267','59590','62121','62124','62130','08583','08880','62134','59199','62158','07604','62147','62130','62960','07532','59470','62134','59267','62121','62129','62130','59494','62111','62147','08920','08552','07760','08640','59121','08550','80600','59161','07760','62960','62270','07608','62130','62130','59192','07533','59400','62134','62111','59296','62960','62134','62450','62116','08972','59174','62450','59670','62450','62129','62810','62111','62450','59670','08520','62147','62124','62130','59410','07540','62270','62270','59224','07604','62270','08582','62575','08840','62270','59159','08640','62134','07534','07604','80300','62130','08640','59161','59267','62760','62760','07604','80300','08551','59470','07760','59670','62129','62760','62134','59970','62111','08530','59125','59198','08860','62134','59285','08972','62450','62450','62270','07760','07534','62450','62124','80600','59277','59860','59400','08647','62450','62310','62130','62130','08650','08840','08800','80300','59470','80600','62510','62124','59122','59281','59470','59224','62575','62270','62760','59400','59233','62134','62130','62130','08647','08580','62760','62124','62570','59159','07910','62111','80560','59159','62129','62760','08691','07750','62310','62310','62129','07604','62810','59188','07910','80300','59278','62130','59300','62500','62310','59400','07601','08553','07906','62560','62310','08531','08870','59285','08531','59129') 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<>'513310' 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=457401 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 = 457401 AND W.type_id = 1) OR (W.util_id <> 457401 AND W.type_id = 2)) AND (M.post_util_id = 457401 OR M.dest_util_id = 457401) 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 = 457401
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=321226 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 = 321226 AND W.type_id = 1) OR (W.util_id <> 321226 AND W.type_id = 2)) AND (M.post_util_id = 321226 OR M.dest_util_id = 321226) 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 = 321226
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 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