s.google_category AS `Campaigns__google_category`, Campaigns.color AS `Campaigns__color`, Campaigns.material AS `Campaigns__material`, Campaigns.pattern AS `Campaigns__pattern`, Campaigns.owner_id AS `Campaigns__owner_id`, Clients.id AS `Clients__id`, Clients.address_id AS `Clients__address_id`, Clients.university_id AS `Clients__university_id`, Clients.organization_id AS `Clients__organization_id`, Clients.organization AS `Clients__organization`, Clients.contact AS `Clients__contact`, Clients.email AS `Clients__email`, Clients.phone AS `Clients__phone`, Clients.owner_id AS `Clients__owner_id`, Clients.category_id AS `Clients__category_id`, Clients.stage_id AS `Clients__stage_id`, Clients.status_id AS `Clients__status_id`, Clients.next_meeting AS `Clients__next_meeting`, Clients.newsletter AS `Clients__newsletter`, Clients.fb_tracking AS `Clients__fb_tracking`, Clients.notes AS `Clients__notes`, Clients.created AS `Clients__created`, Clients.modified AS `Clients__modified`, Types.id AS `Types__id`, Types.name AS `Types__name` FROM campaigns Campaigns LEFT JOIN clients Clients ON Clients.id = (Campaigns.client_id) INNER JOIN types Types ON Types.id = (Campaigns.type_id) ORDER BY id asc LIMIT 20 OFFSET 0

You can see the:

    ORDER BY id asc

At the end, which is the cause.
<issue_comment>username_2: I can fix that. The paginator should be adding the alias when possible.
<issue_comment>username_2: I tried to reproduce this with 3.0.5, and I wasn't able to. I started with a baked app, and added `contain` options.  Sorting by a duplicate column (id) did not generate a SQL error as the sort column was prefixed correctly.
<issue_comment>username_0: Hey @username_2 - anything I could do to provide this in more detail?  Can you give me an indication where this is in the CakePHP library, I will try to debug this myself and see if I can find anything.

Thanks again.
<issue_comment>username_3: Reproduction steps.

I suggest to have a look what the options are [where the find call is](https://github.com/cakephp/cakephp/blob/master/src/Controller/Component/PaginatorComponent.php#L163-L167) - then determine why in your case [this isn't executed](https://github.com/cakephp/cakephp/blob/master/src/Controller/Component/PaginatorComponent.php#L333-L349) - or if it is, the reason the order clause is generated without an alias.
<issue_comment>username_3: If 3.0.5 is doing it correctly - in what version is there an error?
<issue_comment>username_0: They @username_3 - the issue is with 3.05.
<issue_comment>username_3: @username_0 that isn't a valid version number, branch or tag.
<issue_comment>username_1: The only thing I could imagine happening, would be https://github.com/cakephp/cakephp/blob/master/src/Controller/Component/PaginatorComponent.php#L336-L337
That you have some custom sort on top with a numeric index which makes the prefixing skip.

Do you have any special setup on top?
<issue_comment>username_0: Hey @username_1 - found the issue.

I have my sorWhiteList as:

    public $paginate = [
       'sortWhitelist' => [
            'id', 'title', 'Clients.organization', 'created', 'Vendors.name', 'Designers.name', 'Users.username'
        ]
    ];

If I set it as the following:

    public $paginate = [
       'sortWhitelist' => [
            'Campaigns.id', 'title', 'Clients.organization', 'created', 'Vendors.name', 'Designers.name', 'Users.username'
        ]
    ];

Then it works.

But if I do NOT prefix the 'id' in the sortWhitelist, then it throws that error.

Does this help at all?
<issue_comment>username_1: Yes, that information would have helped in the first place ;)

And I found the issue, preparing a PR now: https://github.com/cakephp/cakephp/compare/master-pagination
<issue_comment>username_1: That change breaks a few tests, and so does https://github.com/cakephp/cakephp/compare/master-pagination-fix.

I guess we either have to auto-prefix the whitelist before comparing, too. Or we have to expect devs to always manually prefix the whitelist fields here. I would prefer option one.
<issue_comment>username_0: @username_1 - I would definitely prefer option 1 if possible.

Glad we found the issue, apologies for not sending that through earlier!<issue_closed>
<issue_comment>username_1: I think I got it :)
Closing as a PR is now open.Is it ok to mark your every post as pillar content?
Marking every piece of content as pillar content defeats the purpose of this feature and you should refrain from doing that.
Pillar content should contain the most important articles on your website and pieces of content that are considered evergreen, meaning that they are bound to answer age-old questions.
Marking a page as pillar content doesn’t have any benefit on SEO by itself. It’s simply creates an easy way to setup internal links when you’re creating content.
Yes. It is ok in the sense that it does not affect anything related to Google. It is just a tool for you when doing SEO for your articles.
In this webinar I will discuss how I use podcasts and documentaries at senior cycle in the English classroom. I will talk about why they are worth studying as a non-fiction text and how they can be used to create engaging writing activities. I will also look at how they can be used as a flipped learning activity to promote engaged and educated discussion, deep thinking, and to build background knowledge and cultural capital.
Podcasts and documentaries: flipped learning- building background knowledge, cultural capital and looking at controversial issues.
Hi Marja - I love how you say you want to change your thinking. That is exactly what we should do because we humans limit God's power in us when we don't.
So true Tracy, we need to widen our horizon!
God is amazing...there is nothing He cannot do! Things He does are often beyond our imagination and understanding, but I am trusting Him.
God is amazing indeed Joan. Not that I always understand Him, but that doesn't change the fact that awe is in place.
Thank you, Marja, I SO needed this during this time. All that I thought I knew has been shaken up and now so many questions weigh me down. This reminds me of how limited our natural mind is and that our peace remains when we put our confidence in One who is unlimited and knows no impossibility. Thank you again.
Glad you drooled over the chili. hehehe If you lived next door I'd take you a bowl.
An inpirational post! Thanks!
Hi Lisa, thanks for your visit, always good to see you!
When we stop measuring God against humanity and start measuring ourselves against Him, we get a glimmer of how powerful He is.
Quietspirit, changing our thinking is an ongoing process. Sometimes I feel I am heading nowhere and at other times I know I am on the right track!
Amen Susan, very well spoken. Thanks!
It is interesting to think about where we've come from. I have a journal that I've been meaning to dig out and see where I was some years ago.
So special that you share your intimate thoughts. I'm sorry I haven't commented lately. I'm so behind on comments. Forgive me! Everything IS possible with God! Amen! Thank you, Marja! Bless you!
Had to read this again today. I walk away with the words "practice unlimited thinking" echoing in my mind. I love it.
Don't worry Lynn, we're both behind on reading/responding for several reasons. As long as I see your pretty face pop up here and there, I'm happy!
Inspiring, isn't it Marcia?!International World Missions Director Dr. David M. Griffis and Assistant Director Dr. M. Thomas Propes urge ongoing prayer for Send the Light to the Cities, and especially for Georgetown, Guyana.
Georgetown is listed within the field area of the Caribbean. As the capital city of Guyana, her estimated population claims 773,808. It is unfortunate that Ge