Table 'subkcodb.zyhro_k2_comments' doesn't exist SQL=SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.published, a.access, a.created, a.modified, a.extra_fields, a.extra_fields_search, a.created_by, a.created_by_alias, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.ordering, a.language, a.metakey, a.metadesc, a.metadata,c.name AS category_title, c.image AS category_image, c.alias as category_alias,CONCAT_WS(",", f.id) AS field_ids, CONCAT_WS(",", f.name) AS field_names,CONCAT_WS(",", t.id) AS tag_ids, CONCAT_WS(",", t.name) AS tag_names,COUNT(co.id) AS comment_count,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
FROM zyhro_k2_items as a
LEFT JOIN zyhro_k2_categories AS c ON c.id = a.catid
LEFT JOIN zyhro_k2_extra_fields_groups AS fg ON fg.id = c.extraFieldsGroup
LEFT JOIN zyhro_k2_extra_fields AS f ON f.group = fg.id
LEFT JOIN zyhro_k2_tags_xref AS tx ON tx.itemID = a.id
LEFT JOIN zyhro_k2_tags AS t ON t.id = tx.tagID
LEFT JOIN zyhro_k2_comments AS co ON co.itemID = a.id
LEFT JOIN zyhro_users AS ua ON ua.id = a.created_by
LEFT JOIN zyhro_users AS um ON um.id = a.modified_by
LEFT JOIN zyhro_k2_rating AS v ON a.id = v.itemID
LEFT JOIN zyhro_viewlevels AS vl ON a.access = vl.id
LEFT JOIN zyhro_languages AS l ON a.language = l.lang_code
LEFT OUTER JOIN (select rsi.provider_id, rsi.order from zyhro_roksprocket_items as rsi where module_id = 134) rsi on a.id = rsi.provider_id
WHERE ((a.access IN(1,1,5) AND a.trash = 0 AND a.published = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-05-22 15:21:59') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-05-22 15:21:59')) AND (a.catid IN (2)))
GROUP BY a.id
ORDER BY IF(ISNULL(rsi.order),1,0),rsi.order
Welcome To Our Services Page!
Subkco provides variety of services in its relative fields. Our wide of range of services are as follow. We are so much careful in our all types of services including customer services. Please feel free to contact us for any kind of inquiry.
Review our services & contact us for the relevant offers. Serving our clients with quality products & affordable prices is our main focus & target since beginning & through out the years we have magnificently achieved that target.
Spare-parts import – 10 years
Engine Services Center – 6 years
Oil & Additive – 3 years
Warrenting – 2 years
Car resellers – 8 years
Exclusive car services
We do provide online booking car engine services.
Subkco also deals with used & modified cars .
We are launching exclusive car assembling services in Libya, where you can make your own customized car!