2024.11.24 Sunday Emma
 
FAST SEARCH DETAILED SEARCH Search of certificate of incorporation EUROPEAN LEVEL SEARCH OUR PRODUCTS USEFUL INFORMATION ABOUT US JOB CONTACT  

RELATED
CLASSIFICATION INDEX

Bedding bedding Bedspread Tablecloths Table linen Lake Balaton hotels Curtains Curtains Curtains and decor curtain rails Jacquard fabric Klöpli nylon curtain soft furnishings haberashery Carpets Hotel hotel furnishings, textiles Hotels hotels Carpet rugs and carpets Carpets Textile textile goods Towel Wax on canvas Carpet Wholesale textiles Textiles Sheet Variable with each other decorative materials Shutter for black-out material Flameless Trevira CS products Of textiles for hotels Pensions for textiles Textiles restaurants Cloth Towels Organza curtains Organza curtains lead cord Rugs Cambric curtain Szablé Jacquard curtain Lace curtains Klöpli Klöpli curtain effect Ready curtains Journal Curtain Panel curtain Embroidered voile curtain Voila curtain Organza party Embroidered organza Chenille striped organza Etched organza Novatex Reig Marti Jamil Horn, textiles Yebane Neutex Patterned canvas Flannel White linen Raw canvas Cambric Damask Crepe Iron on canvas Chintz Angie Hotel Mosonmagyaróvár patterned flannel white flannel white damask colored damask crepe canvas patterned crepe solid crepe dirt piece kemping patterned materials Children's decoration materials canvas sheet Production for hotels Hotel facilities workwear for hotels bértextília hospitals Training firms Downtown Hotel Hotel Budapest Balaton hotels Thanks for Szeged Hotel Bükki Hotel Hotel safes Hotels, restaurants, furniture 21 room hotel Recruitment for security guards



Home > Detailed search > Of textiles for hotels

Detailed search

Got error 28 from storage engine
select c.eredeti_id ceg_id, c.cegnev, c.irsz, c.utca, c.email,c.web, c.tel_korzet, c.tel_szam, c.tel2_korzet, c.tel2_szam, c.fax_korzet, c.fax_szam, c.mobil_korzet, c.mobil_szam, c.fax2_korzet, c.fax2_szam, c.mobil2_korzet, c.mobil2_szam, c.webaruhaz, c.blog, c.kiemelt, c.kulcsszo, c.ajanlatURL, c.web2, c.email2, c.skype, c.logo, v.megnev varos_nev, c.egyk k_id , c.eredeti_id vi_id , p.pozicio from ceg c left join varos v on c.varos_id = v.varos_id left join megye m on v.megye_id = m.megye_id left join k_ceg_cimszo k on c.eredeti_id = k.ceg_id left join cimszo sz on sz.eredeti_id = k.cimszo_id left join pozicio p on p.partner=c.eredeti_id and (0 or p.fogalom like "Of textiles for hotels" ) and now()>=p.tol and now()<=ig where k.cimszo_id=sz.eredeti_id and c.eredeti_id=k.ceg_id and ( sz.eredeti_id = "21707" ) group by c.eredeti_id order by p.pozicio is null, p.pozicio, c.hirdmeret desc limit 150