Discuter
Description de l'annonce
Bonjour, ca serait pour refaire ma façade de maison #sableuse
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Bonjour, ca serait pour refaire ma façade de maison #sableuse
Annonces similaires
Tout voirLouer une sableuse entre particuliers ou proposer une sableuse en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
110€
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='348753'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='sableuse' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1129'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'sableuse' LIMIT 1
SELECT c.cate_id, c.cate_title, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='5' AND c.cate_id='87'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='59'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='154412' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 154412
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 = 348753
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1129 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='348753'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='348753' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 154412 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=154412 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 = 154412 AND W.type_id = 1) OR (W.util_id <> 154412 AND W.type_id = 2)) AND (M.post_util_id = 154412 OR M.dest_util_id = 154412) 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='154412' 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 = '348753'
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='154412' AND wish_id<>'348753' 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='59171'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.33333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.917039197041 AND ville_latitude_deg<50.816360802959 AND ville_longitude_deg>2.628383505516 AND ville_longitude_deg<4.038276494484 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 ('59171','59171','59179','59171','59490','59870','59124','59215','59135','59870','59255','59220','59870','59156','59870','59490','59178','59580','59220','59135','59195','59178','59172','59870','59178','59293','59172','59870','59165','59220','59580','59282','59146','59176','59195','59178','59121','59494','59230','59230','59111','59870','59176','59282','59121','59230','59182','59252','59494','59174','59590','59310','59252','59234','59224','59111','59111','59111','59410','59167','59192','59182','59287','59125','59252','59226','59148','59310','59690','59234','59233','59226','59169','59287','59310','59310','59310','59234','59224','59310','59295','59295','59296','59194','59169','59247','59158','59300','59198','59860','59300','59300','59247','59141','59151','59230','59194','59141','59450','59880','59227','59119','59187','59770','07624','59310','59269','59310','59230','59247','07623','59199','59265','59213','59158','59554','59141','59158','59265','59227','59227','59310','59169','59269','59199','59213','07620','59400','59188','59278','59169','59990','59265','07621','59188','59970','59310','59151','59990','59554','59158','07611','59235','59286','59277','59268','59161','59129','59552','59500','59151','59269','59264','59990','07622','59161','59265','59283','59970','59990','59213','59213','59169','59990','62860','59161','07620','59970','59294','07620','62860','59283','59163','59151','62860','59552','59553','59553','59243','59242','62790','07620','59151','07620','59188','59128','59242','62112','59265','59161','07620','59246','59554','07618','59950','62112','59144','59830','59530','07610','59292','07608','59710','62860','59213','59213','62490','59830','59554','59730','59242','59554','62490','59530','62860','59217','07641','59400','59553','59830','59990','62141','59990','07604','59710','59554','59830','62117','62860','62860','59830','59214','59730','59163','59551','07502','62970','07506','59154','59530','59144','59162','62490','07500','59710','59400','59730','07504','59730','07387','07640','59920','59830','07640','07640','59239','62860','59259','59530','07500','59267','59217','07600','59163','59144','07603','62860','59400','59217','07643','07604','07642','59730','59144','59780','59400','62490','59273','59261','62860','59530','59239','59530','62490','59273','07604','59400','07380','62490','07601','07521','07320','62950','59144','07387','07538','59710','59218','59218','07387','07380','62119','59271','62820','07350','59400','59217','62156','59530','07387','59400','59157','59551','62860','62156','07522','07536','59157','59830','07501','62860','07604','59218','59144','59780','59540','07522','59262','59267','07602','59540','59530','07500','07530','59730','59218','62118','07604','07387','62590','62490','62156','59152','59530','59281','59400','07321','59159','07382','07350','59152','59152','07522','59530','07548','62860','59570','07387','59133','59530','62182','62118','62860','07387','07522','07503','07321','07387','07971','59810','59400','07971','07534','62490','07904','07322','62110','59530','62182','59152','59241','59540','62220','59360','07971','62156','59175','07531','62640','07540','07971','62147','59540','07904','62156','59144','59113','59530','62320','62320','62580','59127','59191','07350','59159','59570','62710','59191','59133','59144','07370','07972','07370','59175','59222','07973','62860','59258','59570','62156','59258','59225','59570','59222','59530','62740','07322','59780','62118','07540','59155','62147','59790','07532','62320','59112','59147','59570','62118','07520','59980','62420','62156','07387','59139','07387','59222','07973','59510','07906','07350','62880','59191','59288','07520','07370','07534','59260','59267','59360','59225','62580','62182','62118','62320','62580','62440','59147','59390','59570','62580','07904','62860','59550','07533','59258','07542','07972','59570','59263','07387','62860','59980','59360','62118','62118','59570','07543','07540','59251','59510','07743','59139','62182','59530','59550','59147','62147','62580','62128','59127','07334','07743','59980','62680','59159','07972','07370','07300','62430','07730','07730','62880','62880','59570','59112','62221','62218','59185','07901','62128','07540','59390','62580','62147','59390','59980','59980','59570','62580','62128','59370','59231','07911','59360','59266','62880','07730','07340','59390','07903','07970','07334','07903','62147','59320','59000','59800','59160','59350','59777','62410','59360','07760','59127','59127','07760','62580','59127','07740','62223','59570','07903','07330','62128','62210','07900','07900','59570','59115','59120','59238','07332','07301','59170','59290','07333','59360','59272','59320','62128','62128','07730','59221','07950','07911','62147','62300','62223','62128','62159','59266','62147','59360','62410','62580','59110','59550','07911','07340','59184','59136','62128','07910','07760','62138','62128','62300','59570','59142','07742','07950','59320','07340','07332','62124','02420','07340','07390','59211','59231','07740','07812','62124','07331','62410','59491','59493','59650','59655','07730','59700','62580','59496','07730','62128','59266','59150','59130','02110','59360','07911','59320','62124','59137','62217','62124','07080','59231','07910','62128','59350','62223','07390','07730','07080','07910','07812','62124','59274','07950','62410','59100','62217','59138','59145','07812','59570','02110','07802','59145','62138','07911','08587','07080','59520','59138','59134','59297','07910','07910','62159','59550','59320','07760','62223','07951','02110','62124','59360','07040','59320','59320','59420','62124','07712','02420','59134','07910','62124','07012','59134','07812','62128','59496','08587','59360','07812','59138','02110','62750','59620','62000','07080','62124','59360','59320','62580','62580','07911','62128','62223','07910','62223','59118','59320','07950','62800','59910','07012','62217','07040','62217','08587','59134','59160','07711','59840','02110','07801','62223','62124','02110','02420','59620','59550','59200','07760','02110','02110','59550','62128','07040','07050','02420','62138','62175','59138','62153','62450','08510','07812','59840','07950','62143','62217','62217','59330','62223','59330','59480','07910','62121','62159','59550','62121','07700','07011','59480','59750','07912','80360','59360','07080','59840','59134','07040','07750','02110','59237','62138','07912','62450','62124','07033','07040','08583','80122','08554','59249','07800','59620','07700','07050','62138','07050','62124','80240','07040','80740','07870','62175','07040','62450','02630','80360','07810','02420','02110','62160','07750','07811','07803','62450','02450','07040','07024','07750','62153','07911','62124','07750','62124','59249','59600','59620','08582','62121','62121','59330','59550','62450','02420','80740','07760','07750','62175','62160','59223','59250','59126','62980','07040','80240','02110','59960','59330','62149','62149','02420','02110','08510','80360','07941','07050','62000','07940','59280','62840','07022','62450','07000','62144','62144','62121','59440','62149','07942','08552','59600','62173','62121','07022','07022','62160','62161','62161','02630','62217','62175','62450','59244','59620','59440','59890','80240','07804','62980','02450','07020','80112','62840','08510','07890','07804','59600','62121','09690','62450','80360','02450','62450','62149','07041','07800','09600','07940','08580','62670','02420','62450','59244','59720','62450','02110','80240','08511','02420','59600','62175','59330','59330','07022','08551','80240','59930','02420','02230','62161','07050','07020','07032','02450','62173','02420','59440','62121','62114','62450','02630','62149','62450','59244','62113','62113','62144','59116','62840','07870','59280','80360','02170','62450','09690','02420','02110','62172','07822','59600','07943','07890','09690','09690','59166','62161','08930','59440','62121','59330','07822','62116','59440','59236','02420','07870','62136','62123','02510','07050','08581','02420','59550','07870','62450','07030','62173','62144','62123','59131','59600','62530','07022','08930','62530','59117','07890','80240','80240','02510','02110','59890','62660','62290','62116','07861','59193','59600','62173','59680','62116','80240','62530','07034','08553','02510','07041','59600','62116','59440','08510','07823','07783','08581','62113','08560','08550','02490','62690','07780','07780','62690','62123','62450','80360','59560','62144','62136','62840','80240','62121','02490','80760','07830') 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='1129' AND wish_id<>'348753' 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='1129' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=411049 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 = 411049 AND W.type_id = 1) OR (W.util_id <> 411049 AND W.type_id = 2)) AND (M.post_util_id = 411049 OR M.dest_util_id = 411049) 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 = 411049
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='1129' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=212924 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 = 212924 AND W.type_id = 1) OR (W.util_id <> 212924 AND W.type_id = 2)) AND (M.post_util_id = 212924 OR M.dest_util_id = 212924) 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 = 212924
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='1129' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=295348 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 = 295348 AND W.type_id = 1) OR (W.util_id <> 295348 AND W.type_id = 2)) AND (M.post_util_id = 295348 OR M.dest_util_id = 295348) 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 = 295348
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='1129' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=286666 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 = 286666 AND W.type_id = 1) OR (W.util_id <> 286666 AND W.type_id = 2)) AND (M.post_util_id = 286666 OR M.dest_util_id = 286666) 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 = 286666
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='1129' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=257685 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 = 257685 AND W.type_id = 1) OR (W.util_id <> 257685 AND W.type_id = 2)) AND (M.post_util_id = 257685 OR M.dest_util_id = 257685) 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 = 257685
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='1129' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=153500 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 = 153500 AND W.type_id = 1) OR (W.util_id <> 153500 AND W.type_id = 2)) AND (M.post_util_id = 153500 OR M.dest_util_id = 153500) 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 = 153500
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='1129' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=151630 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 = 151630 AND W.type_id = 1) OR (W.util_id <> 151630 AND W.type_id = 2)) AND (M.post_util_id = 151630 OR M.dest_util_id = 151630) 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 = 151630
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='1129' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=142940 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 = 142940 AND W.type_id = 1) OR (W.util_id <> 142940 AND W.type_id = 2)) AND (M.post_util_id = 142940 OR M.dest_util_id = 142940) 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 = 142940
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='1129' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=112735 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 = 112735 AND W.type_id = 1) OR (W.util_id <> 112735 AND W.type_id = 2)) AND (M.post_util_id = 112735 OR M.dest_util_id = 112735) 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 = 112735
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1129
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