- select *,(k_get_node_weigth(node_id,user_id)*k) as weight_k from nodes where k>0
- and node_created>now()-interval day_int day order by weight_k desc;
-
+ select nodes.node_id,
+ nodes.node_name,
+ nodes.node_creator,
+ nodes.node_content,
+ nodes.k,
+ nodes.node_parent,(k_get_node_weigth(nodes.node_id,user_id)*nodes.k) as weight_k,
+ users.login as creator_name,
+ parent.node_name as parent_name
+ from nodes
+ left join users on users.user_id=nodes.node_creator
+ left join nodes as parent on nodes.node_parent=parent.node_id
+ where nodes.k>0 and nodes.node_created>now()-interval day_int day
+ order by weight_k desc;
+