Error
  • The RokSprocket Module needs the RokSprocket Component enabled.
  • Can't create/write to file '/tmp/#sql_121b_2.MYI' (Errcode: 122) SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM t6rs9_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM t6rs9_content AS a LEFT JOIN t6rs9_categories AS c ON c.id = a.catid LEFT JOIN t6rs9_users AS ua ON ua.id = a.created_by LEFT JOIN t6rs9_users AS uam ON uam.id = a.modified_by LEFT JOIN t6rs9_categories as parent ON parent.id = c.parent_id LEFT JOIN t6rs9_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM t6rs9_categories AS cat JOIN t6rs9_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 INNER JOIN t6rs9_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-08-28 02:19:07') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-08-28 02:19:07') ORDER BY a.featured DESC, fp.ordering, a.created DESC LIMIT 0, 2 Can't create/write to file '/tmp/#sql_121b_2.MYI' (Errcode: 122) SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM t6rs9_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM t6rs9_content AS a LEFT JOIN t6rs9_categories AS c ON c.id = a.catid LEFT JOIN t6rs9_users AS ua ON ua.id = a.created_by LEFT JOIN t6rs9_users AS uam ON uam.id = a.modified_by LEFT JOIN t6rs9_categories as parent ON parent.id = c.parent_id LEFT JOIN t6rs9_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM t6rs9_categories AS cat JOIN t6rs9_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 INNER JOIN t6rs9_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2016-08-28 02:19:07') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-08-28 02:19:07') ORDER BY a.featured DESC, fp.ordering, a.created DESC
Construction
Construction Division undertakes new build and refurbishment works across a wide range of sectors and project values, and has developed a reputation for successfully delivering numerous high profile schemes, many for repeat customers. Read more...
Roads & Infrastructure
Roads and Infrastructure Division capabilities include utilities, road works, civils works and operation of a large and modern fleet of plant and equipment as well as two asphalt plants. Read more...
Interiors
Khansaheb Interiors is a leading specialist fit out contractor with a large pool of skilled craftsmen delivering work of the highest standard in the hospitality, retail and commercial office markets. Read more...
Joinery
Khansaheb Joinery manufactures premium quality products from a purpose built 100,00sq ft factory equipped with state of the art machinery and skilled craftsmen. These products are installed in many of the UAE’s 5 star hotels, retail malls and corporate offices. Read more...
Architectural & Structural Metal
Khansaheb Metals designs, fabricates and installs architectural and structural metalwork products from a well equipped factory in Dubai, with a highly trained and skilled team of engineers and tradesmen. Read more...
Building Services
Khansaheb Building Services specializes in mechanical, electrical and plumbing works for both new build and refurbishment projects. In addition, temporary works installations for power and water are also undertaken. Read more...
Property Services
Khansaheb Property Services delivers construction services to a number of our customers on smaller value, fast track projects. These services cover new build extensions, renovation refurbishment and fit out, backed by Khansaheb’s reputation for high quality on time delivery to the highest safety standards. Read more...
Facilities Management
Khansaheb Facilities Management is a market leading FM and support services company delivering international best practice solutions to a wide range of clients across hospitality, retail, defence, residential and industrial property. Read more...
Waste Water Management
Bionest is a technology based system for purifying domestic waste water in a highly efficient and cost beneficial manner. The above or below ground system is both noiseless and odourless, robust and easy to maintain. Read more...