Repository navigation
Issue with comma with multi FROM #76
Description
Hello,
We have this example:
SELECT COUNT(B.*) FROM (SELECT tags.id FROM tags,
(SELECT t.* FROM tags t WHERE t.id IN (0,1,2)) as childTag
WHERE tags.lft < childTag.lft AND tags.rgt > childTag.rgt AND tags.depth = 2) as BSo we see that we are using 2 tables in the FROM and after MagicQuery it's removing the comma.
Response from MQ:
SELECT
COUNT( `B`.*)
FROM (SELECT
`tags`.`id`
FROM `tags` (SELECT
`t`.*
FROM `tags` `t`
WHERE `t`.`id` IN ( 0, 1, 2)) `childTag`
WHERE ( `tags`.`lft` < `childTag`.`lft`)
AND ( `tags`.`rgt` > `childTag`.`rgt`)
AND ( `tags`.`depth` = 2)) `B`Do you have any solution ?
Thank you.
Activity