[solved] goto admin/structure/views/settings

Btw I wished I could delete my own posts - the solution was found on these forums anyway.

Original:
In Drupal 6 I can always see the results and SQL query at the bottom of the view. But in Views 3 only the results are displayed, but theSQL query is not. Is there a method to see the actual query of the view ?

Comments

You don't to delete your post, otherwise Google will be blind :)

Don't delete your post! It worked for me.

Jeb Bushell

it helped me too.

+1. Thanks for posting your solution.

fureigh.com
fureigh on twitter, irc, skype and g.d.o.

Your post helped me to. No need to delete it, friend.

"Be the URL"

It helped me too

Thanks lot... Its worked for me.....

:P

Rakesh James

version of views I have is 7.x-3.0-rc1 and I do not see any option at the below url to enable seeing sql.
what am I doing wrong?

Instead of visiting that URL, try just clicking the 'Update preview' button on the edit page for your view (/admin/structure/views/view/NAMEOFYOURVIEW).

fureigh.com
fureigh on twitter, irc, skype and g.d.o.

You need to enable the option to display the SQL query on the (very well hidden) Views settings page (admin/structure/views/settings). It's easy to jump to looking at the list of views without noticing the setting tab.

It worked on me...

Always show: Query No query was run

I have the same issue. Even after I enable show sql queries in the settings AND get results, I always get a "No query was run" message instead of the actual sql query that was run. ?

Lynn Taylor

It help me also, Thanks

Thanks it helped me also

Thanks,
Raghu.

1st place in google with:
"how to see drupal query views" :P

The impossibility to delete your post saved me time to find the answer.

You need to enable the option to display the SQL query on the (very well hidden) Views settings page (admin/structure/views/settings). It's easy to jump to looking at the list of views without noticing the setting tab.
where you will many setting related to view

A k Rawat

Google considers you an authority on "how to display the SQL query". Saved my time. Thank you.

Best wishes,
Andrei.

Thanks it's help me too!

It saved my time!

This helps. Thanks.

you saved my day !!
thanks .. don't delete it :)

Hussain Alhaddad
www.sharedtech.com.sa

enable "Show the SQL query" into views setting . It's works

Thanks
Mayur Pimple
www.mayurpimple.com