Testing

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 top 10 * from ReviewTaskTypes
--select top 10 * from ReviewTaskResultTypes
--select top 10 * from ReviewTaskStates
--select * from posts where id = 714656
select top 100 * from ReviewTaskResults b
inner join  ReviewTasks a 
on b.reviewtaskId = a.id
inner join posts p
on a.id = p.id and p.posttypeId = 2
--where b.reviewtaskId = 714656

--select top 10 * from ReviewTasks where id = 714656
--select top 10 * from ReviewTaskResults where reviewtaskId = 714656

Enter Parameters

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