使用UNION与LIMIT的MySQL操作指南
所以，我手头有这个问题。
我必须从不同的表中使用内连接获取多个记录，并使用UNION或UNION ALL进行分页，下面的代码是用于获取所有记录和计数的。这是我的宿敌：
(SELECT pp.id as id, pp.*, i.name, p.name as plans_name, u.username,u.email,u.phone, DATE_ADD(pp.init_date, INTERVAL pp.avaliable_days DAY) as end_date FROM property_purchase pp
inner join users u ON pp.users_id $username
inner join inn_oficial i ON i.photo_id = pp.property_id
left join plans p ON pp.plans_id = p.id
WHERE (pp.type = 1 or pp.type = 2)
$where )
UNION
(SELECT pp.id as id, pp.*, i.model as name, p.name as plans_name, u.username,u.email,u.phone, DATE_ADD(pp.init_date, INTERVAL pp.avaliable_days DAY) as end_date FROM property_purchase pp
inner join users u ON pp.users_id $username
inner join rent_oficial i ON i.photo_id = pp.property_id
left join plans p ON pp.plans_id = p.id
WHERE pp.type = 3
$where)
UNION
(SELECT pp.id as id, pp.*, i.name, p.name as plans_name, u.username,u.email,u.phone, DATE_ADD(pp.init_date, INTERVAL pp.avaliable_days DAY) as end_date FROM property_purchase pp
inner join users u ON pp.users_id $username
inner join fish_pay_oficial i ON i.photo_id = pp.property_id
left join plans p ON pp.plans_id = p.id
WHERE pp.type = 4
$where )
UNION
(SELECT pp.id as id, pp.*, i.name, p.name as plans_name, u.username,u.email,u.phone, DATE_ADD(pp.init_date, INTERVAL pp.avaliable_days DAY) as end_date FROM property_purchase pp
inner join users u ON pp.users_id $username
inner join stores_oficial i ON i.photo_id = pp.property_id
left join plans p ON pp.plans_id = p.id
WHERE pp.type = 5
$where)
UNION
(SELECT pp.id as id, pp.*, i.name, p.name as plans_name, u.username,u.email,u.phone, DATE_ADD(pp.init_date, INTERVAL pp.avaliable_days DAY) as end_date FROM property_purchase pp
inner join users u ON pp.users_id $username
inner join transfer_oficial i ON i.photo_id = pp.property_id
inner join plans p ON pp.plans_id = p.id
WHERE pp.type = 6
$where)
GROUP BY pp.id
ORDER BY pp.id
我从13.2.9.3 UNION Clause中获取了这个例子，并在脚本上尝试了一下
当我尝试运行代码时，它报错了
在第1行的'GROUP BY id ORDER BY id LIMIT 0.25'旁边，你的SQL语法有错误
对不起，我的英语很糟糕，这不是我的母语
