Log message #3882003

# At Username Text
# May 28th 2016, 08:58 birdy247 who built the front end?
# May 28th 2016, 08:58 birdy247 nice
# May 28th 2016, 08:57 savant a few of the primaries go live today, and the rest over the coming week or so :slightly_smiling_face:
# May 28th 2016, 08:57 savant not just the main site
# May 28th 2016, 08:57 savant all the websites are being relaunched
# May 28th 2016, 08:57 birdy247 Oh my!
# May 28th 2016, 08:56 savant try going to http://cakephp.org|cakephp.org
# May 28th 2016, 08:56 birdy247 what are the new site launches?
# May 28th 2016, 08:55 savant missed this year, had a few personal things to get through
# May 28th 2016, 08:55 birdy247 ah, long way to go
# May 28th 2016, 08:55 savant im in nyc
# May 28th 2016, 08:55 savant no
# May 28th 2016, 08:55 birdy247 are you at cakefest?
# May 28th 2016, 08:55 savant hai
# May 28th 2016, 08:55 birdy247 @savant: morning
# May 28th 2016, 08:29 phpcoder yes it works perfectly!
# May 28th 2016, 08:27 savant basically exactly what you thought it might be :slightly_smiling_face:
# May 28th 2016, 08:27 savant good to know you can change an alias
# May 28th 2016, 08:27 savant :)
# May 28th 2016, 08:27 savant look at you, looking at docs
# May 28th 2016, 08:26 savant oh fancy
# May 28th 2016, 08:26 phpcoder @savant http://api.cakephp.org/3.2/class-Cake.Database.Query.html#_from
# May 28th 2016, 08:17 phpcoder ) no problem @savant
# May 28th 2016, 08:17 phpcoder i am writing the code let see if it works
# May 28th 2016, 08:17 savant sorry, quite late for me, not running on all my batteries right now :(
# May 28th 2016, 08:17 savant interesting. not sure, maybe @lorenzo might know (though he's probably a bit asleep atm)
# May 28th 2016, 08:16 phpcoder the same table twice savant
# May 28th 2016, 08:16 phpcoder i have to use it twice
# May 28th 2016, 08:16 phpcoder yes
# May 28th 2016, 08:11 savant Which one of those is it?
# May 28th 2016, 08:11 savant or if you want to select from another table completely
# May 28th 2016, 08:10 savant If you just want to use Agents in there twice
# May 28th 2016, 08:09 savant whats the overall query you want to get?
# May 28th 2016, 08:08 phpcoder but with a different alias because i use it in a query on select() (on the main query)
# May 28th 2016, 08:08 savant so just use that code?
# May 28th 2016, 08:08 phpcoder the same as TableRegistry::get('Agents')->find()->select()->where()->all()
# May 28th 2016, 08:06 savant what is the exact query you want
# May 28th 2016, 08:06 phpcoder ?
# May 28th 2016, 08:06 phpcoder should i set it using ->from()
# May 28th 2016, 08:05 phpcoder i do not need to use "Agents" alias
# May 28th 2016, 08:05 phpcoder if i do TableRegistry::get('Agents')->find()->select()->where()->all()