Views: How do you view the query? How do you view the query that a 'View' is using to gather data from the database?
Go to admin/structure/views/settings, check Show information and statistics about the view during live preview and then Show the SQL query checkbox that will appear below.