SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published >= 1 AND access <= 0 ORDERBY ordering
SELECT * FROM jos_migration_backlinks WHERE url LIKE'view=artist&option=com\_profile&name=AnselmFernandes%'OR sefurl LIKE'view=artist&option=com\_profile&name=AnselmFernandes%'
SELECT template FROM jos_templates_menu WHERE client_id = 0 AND(menuid = 0OR menuid = 0) ORDERBY menuid DESC LIMIT0, 1
SELECT SQL_CALC_FOUND_ROWS u.id,u.name,u.username,u.email,u.usertype,u.username,u.block FROM jos_users AS u WHERE u.username ="AnselmFernandes"
SELECT id,user_id FROM`jos_profile` WHERE user_id = 0
SELECT id FROM`jos_profile_views` WHERE user_id = 316
SELECT id,update_date FROM`jos_profile_views` WHERE user_id = 316
UPDATE`jos_profile_views` SET`total_views` = `total_views` + 1 WHERE user_id = 316
SELECT SQL_CALC_FOUND_ROWS content FROM jos_board WHERE user_id=316 AND published = 1
SELECT SQL_CALC_FOUND_ROWS id,user_id,title,file,description,created FROM jos_photos WHERE published=1 AND user_id=316 ORDERBY created DESC LIMIT0, 9
SELECT FOUND_ROWS();
SELECT id,today_views,total_views,user_id,update_date FROM`jos_profile_views` WHERE user_id = 316
SELECT SQL_CALC_FOUND_ROWS id FROM jos_favorites WHERE(listener_id=0 AND artist_id=316) LIMIT0,1
SELECT SQL_CALC_FOUND_ROWS id,user_id,profile_id,is_pending,created FROM jos_friends WHERE(user_id=0 AND profile_id=316)OR(user_id=316 AND profile_id=0) LIMIT0,1
SELECT SQL_CALC_FOUND_ROWS v.id,v.title,v.video_type,v.user_id,v.description, v.created,
v.published, v.ordering,yv.youtube_id,yv.feed_user_name, yv.image , dv.id AS desktopid,dv.image AS desktopimage,dv.user_image,dv.video_id
FROM
jos_videos AS v
LEFTJOIN jos_youtube_videos AS yv
ON v.id = yv.video_id
LEFTJOIN jos_desktop_videos AS dv
ON v.id = dv.video_id
WHERE
v.published=1
AND v.user_id = 316
ORDERBY v.created DESC LIMIT0, 9
SELECT FOUND_ROWS();
SELECT SQL_CALC_FOUND_ROWS id,user_id,title,date,summary,content,created FROM jos_blog WHERE published=1 AND user_id=316 ORDERBY created DESC LIMIT0, 9
SELECT FOUND_ROWS();
SELECT SQL_CALC_FOUND_ROWS p.id,p.user_id,p.gender,p.dob,p.country,p.zipcode,p.genre1,p.genre2,u.id,u.name,u.name,u.registerDate,u.usertype,p.website_url,p. merch_url,p.contact_email,p.booking_contact FROM jos_profile AS p, jos_users AS u WHERE u.id = p.user_id AND p.user_id=316
SELECT SQL_CALC_FOUND_ROWS website_url,merch_url,contact_email,booking_contact FROM jos_profile WHERE user_id=316
SELECT SQL_CALC_FOUND_ROWS id,user_id,country,city,cost,description,venue,show_date,show_time,cost,created,image FROM jos_shows WHERE user_id=316 LIMIT0, 9
SELECT FOUND_ROWS();
SELECT SQL_CALC_FOUND_ROWS pc.id,u.id AS uid,u.username,u.name,u.usertype,pc.profile_id,pc.user_id,pc.comment,pc.posted_on,pc.is_allow FROM jos_user_comments AS pc,jos_users AS u WHERE pc.profile_id = 316 AND pc.user_id=u.id AND pc.is_allow=1 ORDERBY pc.posted_on DESC LIMIT0, 9
SELECT FOUND_ROWS();
SELECT SQL_CALC_FOUND_ROWS id,user_id,name,alias,file,release_date,created FROM jos_albums WHERE published=1 AND user_id =316 LIMIT0, 9
SELECT FOUND_ROWS();
SELECT SQL_CALC_FOUND_ROWS f.id,f.artist_id,f.listener_id,f.submitted_date,u.id AS uid,u.username,u.name,u.usertype,u.registerDate FROM jos_favorites AS f ,jos_users AS u WHERE f.listener_id = u.id AND f.artist_id=316 AND u.block=0 ORDERBY f.submitted_date DESC LIMIT0, 9
SELECT FOUND_ROWS();
SELECT SQL_CALC_FOUND_ROWS f.id,f.user_id,f.profile_id,f.is_pending,f.created FROM jos_friends AS f,jos_users AS u WHERE(f.profile_id = 316OR f.user_id=316) AND f.is_pending = 0 AND f.profile_id = u.id AND u.block=0 ORDERBY f.created DESC LIMIT0, 9
SELECT FOUND_ROWS();
SELECT id,user_id,updated_date,allow_photo_comments,allow_album_comments,allow_profile_comments,allow_blog_comments,allow_friends,message_notification,comments_notification,friend_notification,allow_video_comments,profile_background_content,profile_background_type,profile_theme FROM jos_user_settings WHERE user_id =316
SELECT FOUND_ROWS();
SELECT id,today_views,total_views,video_id,update_date FROM`jos_video_views` WHERE video_id=131
SELECT id,today_views,total_views,video_id,update_date FROM`jos_video_views` WHERE video_id=130
SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFTJOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id = 0 AND( mm.menuid = 0OR mm.menuid = 0) ORDERBY position, ordering
SELECT p.id,p.user_id,p.title,p.file,p.description,p.created,u.name,u.username,u.usertype FROM jos_photos AS p,jos_users AS u WHERE p.published=1 AND u.block=0 AND u.id = p.user_id ORDERBY p.created DESC LIMIT0, 4
SELECT SQL_CALC_FOUND_ROWS v.id,v.title,v.video_type,v.user_id,v.description, v.created,
v.published, v.ordering,yv.youtube_id,yv.feed_user_name, yv.image , vv.today_views, dv.id AS desktopid,dv.image AS desktopimage,dv.user_image,dv.video_id
FROM
jos_videos AS v
LEFTJOIN jos_youtube_videos AS yv
ON v.id = yv.video_id
LEFTJOIN jos_video_views AS vv
ON vv.video_id=v.id
LEFTJOIN jos_desktop_videos AS dv
ON v.id = dv.video_id
WHERE
v.published=1
AND vv.update_date='2024 04 18'
ORDERBY vv.today_views DESC LIMIT0, 10
SELECT a.id,a.user_id,a.name,a.alias,a.file,a.release_date,a.description,a.created,av.today_views FROM jos_albums AS a,jos_album_views AS av WHERE av.album_id = a.id AND av.update_date='2024 04 18' ORDERBY av.today_views DESC LIMIT0, 10
SELECT v.id,v.user_id,v.title,v.description,
yv.image,yv.youtube_id FROM jos_videos AS v, jos_youtube_videos AS yv WHERE v.id = yv.video_id AND v.published=1 LIMIT0, 5
SELECT id,name,username,email FROM jos_users WHERE id=289
SELECT id,name,username,email FROM jos_users WHERE id=289
SELECT id,name,username,email FROM jos_users WHERE id=298
SELECT id,name,username,email FROM jos_users WHERE id=301
SELECT id,name,username,email FROM jos_users WHERE id=303