All users name query

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

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;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results