Markus Andree

I have something similar but I'm not sure if it's related. It is on SB2: I shut it down and when I want to power or back on it stucks...

It's not the solution, but FluentPDOs smart join functionality is probably the cause fir your problem. You can try to use `$query = $fpdo->from('views')->disableSmartJoin();` as a work around.

Found the problem: the table in _program_.id isn't known and therefor FluentPDO tries to join it. Use program_id instead. This is not a bug.

Ok, tried the [regex](https://github.com/envms/fluentpdo/blob/9fdade2f9734fa87b89ee3e2866bbff0ee2b2ada/FluentPDO/CommonQuery.php#L283) of 9fdade2f and it looks like the new regex allows tablenames starting with a number. That means it parses 0.00 as a table name. That actually...

@cbornhoft wrote: > Should it ever be a table name? Probably never; but it is allowed for whatever reason. Any SQL dialect I know of needs to escape this kind...

This is probably related to #199 and should have been fixed with #200 but looks like it isn't. If you have this problem with a group by query, you're fix...

@cbornhoft then I guess a fast fix would be to document that count() doesn't work properly on grouped queries.

There is a very good overview of possible [result limitations on wikipedia](https://en.wikipedia.org/wiki/Select_(SQL)#Result_limits). How about implementing some of them and allow to configure the behaviour to use from php on the...

Only a guess while investing the source, but the id for a floating rift should be `dimdoors.rift` as set [here](https://github.com/DimensionalDevelopment/DimDoors/blob/d613019752e3f2141abf4c489f509018bcae0fc7/src/main/java/org/dimdev/dimdoors/shared/blocks/BlockFloatingRift.java#L30).

Is this still an active use case?