Please don't suggest query builder, this is the single query I need run from my custom module with passing arguments.

I create a View with desire fields and copy/past the query in phpMyAdmin the query is not showing the actual values for columns instead showing value as NODE :(

Is there any way to achieve this?


  • Do you mean it contains something like SELECT 'node' as entity_type? If so, that's normal
    – Clive
    Feb 5, 2014 at 9:31
  • It is hard to work out what your exact problem is without more information. Can you add the full query to your original post as that may help work out your problem?
    – rooby
    Feb 24, 2014 at 13:30

1 Answer 1


Goto admin/structure/views/settings and enable the setting

Show other queries run during render during live preview

enter image description here

As the help text for the setting reads, probably during the view rendering time there are some changes that could be happening. Enabling this setting will give you an insight into what is happening.

  • It didn't work, tnx btw
    – Zafar S
    Feb 5, 2014 at 8:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.