0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Joomla! administrators, users, developers and designers

/*select count(Id) as Users from Users;
select count(Id) as Questions from Posts
where PostTypeId = 1;
select count(Id) as Answers from Posts
where PostTypeId = 2;*/

select * from
(select count(Id) as Users from Users) Users,
(select count(Id) as Questions from Posts
where PostTypeId = 1) Questions,
(select count(Id) as Answers from Posts
where PostTypeId = 2) Answers,
(select count(Id) as Tags from Tags) Tags

fork query

edited dec 10 18

created dec 10 18 anonymous