I have installed draggable View and it working fine in view but when i copy that query from view and use as db_query in my code, its not working properly query is given below

SELECT node.nid AS nid, node.title AS node_title, node.status AS node_status, draggableviews_structure.weight AS draggableviews_structure_weight
FROM 
{node} node
LEFT JOIN {draggableviews_structure} draggableviews_structure ON node.nid = draggableviews_structure.entity_id AND draggableviews_structure.view_name = 'view_videos' AND draggableviews_structure.view_display = 'page' AND draggableviews_structure.args = '{\"status\":\"1\",\"title\":\"\"}'
WHERE (( (node.type IN  ('suno_video')) AND (node.status = '1') ))
ORDER BY draggableviews_structure_weight ASC
LIMIT 50 OFFSET 0

This query working fine in MySQl and Views but not ordering properly in my code...

Thanks for advance...

Comments

maddyvora created an issue.