We Know What it Takes To Be The Leader !

Who we are?

Ascomp is a dedicated software house specialising in business solutions.Since past ten years Ascomp has been rendering its services across the industries and launched its key product Reckoner in 1997 that integrates various branches of an enterprise. The special area of focus being ....

Read More

Why chose us?

Reckoner is an Enterprise Resource Planning system that gives your company efficient supply chain management at every level of your operation. It's an information technology system that integrates data captured at all different stages and provides managers a clear, complete...
Read More

News and Events




SQL=SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias)!=0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems FROM web_categories as c LEFT JOIN web_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM web_categories AS cat JOIN web_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN `web_content` AS i ON i.`catid` = c.id AND i.state = 1 WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=9 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft

Get in Touch



Board No. : +91 11 43930000

Marketing: +91 11 43930004






Ascomp Technologies Pvt. Ltd.

1203, Padma Tower 1,
5, Rajendra Place,
New Delhi - 110 008