Description de l'annonce
A la retraite et Dispo . Travail méticuleux et Propre.
#Carreleur
Voir les annonces autour de moi Géolocaliser
Poster une annonce
A la retraite et Dispo . Travail méticuleux et Propre.
#Carreleur
Demande un service Carreleur entre voisins ou proposer mes services Carreleur.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom, 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='332362'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'carreleur' 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='3' AND c.cate_id='50'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('68' 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='134528' 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` = 134528
SELECT util_cp FROM utilisateur WHERE util_id=134528 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 = 332362
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=588 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 134528 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='332362'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='332362' 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=134528 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=134528 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 = 134528 AND W.type_id = 1) OR (W.util_id <> 134528 AND W.type_id = 2)) AND (M.post_util_id = 134528 OR M.dest_util_id = 134528) 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 = '332362'
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='134528' AND wish_id<>'332362' 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='68440'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.7*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.7*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((7.36667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.250339197041 AND ville_latitude_deg<48.149660802959 AND ville_longitude_deg>6.6985317262173 AND ville_longitude_deg<8.0348082737827 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 ('68440','68440','68440','68440','68440','68440','68440','68720','68440','68350','68440','68510','68350','68400','68510','68510','68200','68100','68720','68130','68510','68510','68720','68510','68130','68720','68720','68510','68170','68510','68720','68510','68130','68130','68390','68130','68790','68720','68130','68720','68110','68870','68460','68130','68680','68120','68510','68130','68870','68990','68720','68130','68390','68120','68130','68130','68990','68490','68720','68680','68260','68130','68130','68950','68130','68510','68490','68130','68730','68720','68130','68270','68220','68960','68490','68210','68730','68720','68560','68730','68128','68130','68270','68390','68220','68210','68520','68960','68210','68850','68310','68960','68960','68220','68560','68520','68118','68210','68220','68560','68520','68210','68640','68480','68640','68640','68640','68210','68220','68560','68840','68210','68210','68210','68640','68220','68700','68490','68190','68220','68128','68480','68780','68220','68490','68210','68210','68220','68740','68540','68330','68210','68700','68700','68700','68300','68128','68780','68640','68500','68740','68700','68210','68580','68210','68210','68480','68540','68800','68190','68700','68210','04124','68780','04056','68210','68210','68190','68480','04055','04123','04123','68500','68580','68740','68220','68220','68210','68580','68210','04057','68116','68210','68580','68210','04009','04020','04002','04000','04019','04091','04018','04005','04030','04070','04075','04010','68480','68480','68890','04031','68700','68580','68580','68210','68780','68210','68480','68480','04054','68360','68780','68210','68480','68800','68580','04001','68480','68220','68780','68800','04051','04089','04041','04041','04089','04089','04039','04039','04089','68220','68500','04102','04102','04058','68210','68500','68580','68480','68480','68250','68890','68480','68290','68210','04105','68210','68500','68580','68250','04104','04118','04053','68800','68500','68740','68480','04101','04052','04052','90150','68800','04125','04125','90150','04103','04059','68740','68780','04112','04112','68500','68220','68480','68620','90100','68480','90100','68480','68210','68480','04112','68500','04127','90150','68210','68480','90360','04115','04108','68210','68210','68740','68480','04106','68290','68480','68760','90360','68480','90100','04126','68500','68740','68740','90100','68290','04116','68760','68500','04040','04142','04042','04042','90150','90150','68740','04114','04142','68500','68480','68250','68250','68500','04117','04153','04153','68530','90150','90150','04107','90110','68127','90150','04132','68250','04132','90110','68290','90130','02935','90370','90150','68530','90100','02944','68480','90130','68480','68250','04223','90110','90110','68480','90150','04144','04147','90100','68290','90100','90110','90130','90150','04243','02814','68690','68250','68480','68610','02813','04244','04245','68600','68550','68690','90110','90100','90100','68610','68570','68290','90150','02933','04224','04143','04148','04133','68250','90100','04133','04222','68290','90340','02943','02933','68250','68480','68610','68600','90100','04302','90140','02807','02947','90170','02812','90340','90150','90150','90140','90140','04254','02807','90160','04145','68290','68470','68290','04202','68470','90100','68550','90100','04402','02946','90170','02924','04203','68570','04225','04303','04242','04303','02953','02805','90380','68420','68600','04304','04146','02806','90160','04253','02932','68290','90600','68600','68600','90170','68290','90340','04414','90140','02953','04412','02803','90170','90300','68470','68470','68600','02942','04204','68127','04246','68280','90100','68420','04226','90400','68420','68420','68280','02925','90140','90160','02926','04252','04252','04410','02923','04421','02952','90200','02800','02800','68420','68470','04413','90300','04305','02954','04310','04310','90120','68600','68230','02800','68290','04232','04422','90400','90140','04227','04206','02822','90200','02823','04247','68121','68470','04411','68280','68600','68830','90300','04419','90100','68420','68600','02922','02802','02857','68380','02900','02900','02900','90000','68600','90100','90400','04208','90120','90400','68600','02950','68140','02950','04312','90200','90300','04423','04228','04234','02824','90200','90400','68230','90100','04313','68420','04417','04415','04233','02828','02826','25490','68600','68140','68820','02825','25490','02842','04416','90400','90100','02902','04453','68140','90300','04207','90330','02856','02915','90400','90200','90300','25490','90400','68380','25490','02830','02905','90400','04452','68230','68280','68920','04433','02882','04464','02882','90850','25600','90300','02852','68320','68920','68140','04424','04451','90700','90500','02854','02827','02883','02888','04450','02903','02853','68380','04418','04229','90200','25600','90100','90850','68230','04314','68230','90400','04432','02843','68380','04426','02884','04425','68180','02832','04323','25230','90500','68000','68140','90350','68140','68380','90800','90800','02830','02904','68320','25600','04435','04455','68230','68320','02827','04434','02829','04463','04462','68820','88540','68320','25230','25460','04461','04436','02855','68140','68320','02916','90200','90800','25200','02762','04719','02906','04441','70400','02889','68320','04322','04315','02885','70400','90800','25400','68320','68040','68320','04436','02864','25600','25600','04456','68230','68230','25310','70400','68320','90200','68140','25190','88310','02863','04442','02747','04437','70400','25230','02744','04460','25400','04465','70400','04466','04431','04717','02747','70400','02907','25200','68125','04457','04316','04443','68320','02745','02746','68320','25400','70290','04324','68770','02873','88560','88160','25310','02886','02748','02740','25200','02742','68320','04714','04332','02908','70290','04447','04444','02717','02364','25700','25190','25230','70400','25400','70400','04715','68320','68910','70400','25310','04317','02912','04446','04716','70290','04712','02748','04333','70400','04492','02715','02743','04713','68240','04467','68240','02362','02718','04438','04497','70400','02716','25420','68240','68320','70400','25310','70440','04458','88250','02735','02717','88160','70400','04334','04325','04716','25310','04445','02912','88310','04710','25310','70400','04493','02887','02715','25310','04524') AND fami_id='3' AND cate_id='50' AND type_id='1' AND ssrubr_id='588' AND wish_id<>'332362' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 588
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 588
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='3' 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 (50) 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 (38) 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 (45) 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 (231) 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 (47) 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 (42) 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 (37) 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 (43) 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 (39) 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 (229) 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 (230) 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