Community Forum

Welcome to our user to user community. If you need support for a product, please open a support ticket.


Topic-icon Unique item per author not sorting Last added first option.

  • Belzunces
  • Belzunces's Avatar Topic Author
  • Offline
  • New Member
  • New Member
9 months 1 week ago - 9 months 1 week ago #525 by Belzunces
Belzunces created the topic: Unique item per author not sorting Last added first option.
Submitted support ticket on 04th May and no answer yet, I paste the content of the ticket within this post.

Filter not ordering correctly with unique item per author selected.
Mayo 04, 2017 04:33
In JoomlaXTC K2 Content Wall v 1.38.0 When you order by (Last added first) and field "Unique item per Author" is Yes, the result is not ordered by Created date. It shows the first item created by each author, not the last one. Here you are the sql query yo create:

SELECT,,, i.access, i.introtext, i.fulltext, i.title, i.featured, UNIX_TIMESTAMP(i.created) as created, UNIX_TIMESTAMP(i.modified) as modified, UNIX_TIMESTAMP(i.publish_up) as publish_up, UNIX_TIMESTAMP(i.publish_down) as publish_down, i.catid, i.extra_fields, i.created_by, i.hits, i.params, cc.params as cat_params, as cat_title, cc.image as cat_image, cc.description as cat_description, cc.alias as cat_alias, u.username as author, as authorname, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(":",, i.alias) ELSE END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":",, cc.alias) ELSE END as catslug, kr.rating_sum , kr.rating_count, kr.lastip FROM ilvk6_k2_items AS i LEFT JOIN ilvk6_k2_rating AS kr ON kr.itemID =, ilvk6_k2_categories AS cc, ilvk6_users AS u WHERE = i.catid AND = i.created_by AND i.published = 1 AND i.trash = 0 AND cc.published = 1 AND cc.trash = 0 AND i.access IN (1,1,5) AND i.catid IN(93,79,110,91,81,76,102,107) GROUP BY i.created_by ORDER BY i.created DESC

This query is not correct, due to a problem in the structure of Group by nested into a Group By.
Is this error solved in a future version? Is there any patch to solve this?

PD: "ilvk6" is the prefix of my tables on db.

Last Edit: 9 months 1 week ago by Belzunces.

Please Log in or Create an account to join the conversation.