Haskon Civata
HASKON Cıvata Sanayi ve Ticaret A.Ş.

Contact
Address:
1.Org. San. Böl. Çamlıyayla Sok. no:5
KONYA
42000
TÜRKİYE

E-mail: This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
Telephone: +90 332 248 90 90
Fax: +90 332 248 29 64
http://www.haskoncivata.com

Information: Sipariş Vermek İçin Formu Doldurunuz. Sipariş Verirken Lütfen İstediğiniz Ürün Adını, Sayısını ve Telefon Numaranızı Eklemeyi Unutmayınız.

 














Turkish (Turkiye)English (United Kingdom)
No valid database connection Incorrect DATETIME value: '0000-00-00 00:00:00' SQL=SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,cc.title as cattitle,s.title as sectitle FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-06-13 19:21:44' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-06-13 19:21:44' ) AND a.id IN (58,59,60,61) AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND s.published = 1 AND cc.published = 1 ORDER BY ordering LIMIT 0,4