Public Group Page List

 
400
Bad Request Your request couldn't be processed by the server!...
 
404
The page you requested cannot be found.
 
409
Your reque...
 
ad_program_terms
Terms and Conditions
 
advertise
Monetization on Yioop Yioop supports keyword advertising...
 
bot
A Brief Description of Yioop Bot
 
captcha_time_out
Account Timeout A large number of captcha refres...
 
 
 
Old_Blog_Page
Old PHP Search Engine Blog Describes what crawls Yi...
 
Old_Yioop_Free_Code_Entry
Old Yioop Free Code Entry This is the ...
 
 
presentation
Title Slide Item Slide Item ...
 
 
 
privacy
What information is collected by Yioop ...
 
register_time_out
Account Timeout A number of incorrect captcha res...
 
Syntax
Yioop Wiki Syntax  ...
 
terms
Terms of Service Welcome to Yioop! These terms of service (&q...
 
 
[X ]

Query Statistics

https://www.yioop.com/p/pages

Total Elapsed Time for Queries: 0.2968540191650391 seconds.
SELECT LOCALE_NAME, WRITING_MODE FROM LOCALE WHERE LOCALE_TAG ='en-US'
Time: 0.002418994903564453 seconds.
SELECT COUNT(DISTINCT G.GROUP_ID) AS NUM FROM GROUPS G, USER_GROUP UG, USERS O WHERE G.GROUP_ID='2'
Time: 0.2840631008148193 seconds.
SELECT * FROM GROUPS G, USER_GROUP UG, USERS O WHERE G.GROUP_ID='2' LIMIT 1 OFFSET 0
Time: 0.001302957534790039 seconds.
SELECT G.GROUP_ID AS GROUP_ID, G.GROUP_NAME AS GROUP_NAME, G.OWNER_ID AS OWNER_ID, O.USER_NAME AS OWNER, REGISTER_TYPE, UG.STATUS AS STATUS, G.MEMBER_ACCESS AS MEMBER_ACCESS, G.VOTE_ACCESS AS VOTE_ACCESS, G.POST_LIFETIME AS POST_LIFETIME, UG.JOIN_DATE AS JOIN_DATE, G.ENCRYPTION AS ENCRYPTION FROM GROUPS G, USERS O, USER_GROUP UG WHERE (UG.USER_ID = :user_id OR G.REGISTER_TYPE IN (3,4)) AND UG.GROUP_ID= :group_id AND UG.GROUP_ID=G.GROUP_ID AND OWNER_ID = O.USER_ID LIMIT 1
Array ( [:group_id] => 2 [:user_id] => 2 )
Time: 0.0007290840148925781 seconds.
SELECT STATUS FROM USER_GROUP WHERE USER_ID=? AND GROUP_ID=? LIMIT 1
Array ( [0] => 2 [1] => 2 )
Time: 0.0003638267517089844 seconds.
SELECT COUNT(*) AS TOTAL FROM GROUP_PAGE WHERE GROUP_ID = ? AND LOCALE_TAG= ? AND LENGTH(PAGE) > 0
Array ( [0] => 2 [1] => en-US )
Time: 0.005764961242675781 seconds.
SELECT TITLE, PAGE AS DESCRIPTION FROM GROUP_PAGE WHERE GROUP_ID = ? AND LOCALE_TAG= ? AND LENGTH(PAGE) > 0 ORDER BY LOWER(TITLE) ASC LIMIT 50 OFFSET 0
Array ( [0] => 2 [1] => en-US )
Time: 0.002211093902587891 seconds.