![]() ![]() select "collection".* from "collection_song" Left join song_top st on (s.id = st.song_id and st.date = (SELECT max(date) FROM song_top)) Join song s on s.id = sa.song_id and s.alias is not null and s.expire_at > now() Join song_author sa on a.id = sa.author_id and sa.type_id = 3 a.external_id _a_external_id,a.name _a_name,a.urlkey _a_urlkey,a.alias _a_alias,a.song_count _a_song_count,a.created_at _a_created_at,a.updated_at _a_updated_at,a.content_updated_at _a_content_updated_at,a.image_id _a_image_id,a.image_version _a_image_version,a.id _a_id, s.external_id _s_external_id,s.title _s_title,s.lyrics _s_lyrics,s.created_at _s_created_at,s.updated_at _s_updated_at,s.expire_at _s_expire_at,s.copyrights _s_copyrights,s.sort _s_sort,s.urlkey _s_urlkey,s.alias _s_alias,s.can_sing _s_can_sing,s.duration _s_duration,s.has_minus _s_has_minus,s.text_updated_at _s_text_updated_at,s.age_limit _s_age_limit,s.file_dat_id _s_file_dat_id,s.file_dat_version _s_file_dat_version,s.is_free _s_is_free,s.id _s_id, sa.is_main_author _is_main ![]() SQL Запросы select "page".* from "page" where (url = '/artists/usher/song/confessions-pt-2/')
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |