Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

de-merphq's scratchpad

by de-merphq (Beadle)
on Aug 02, 2004 at 17:34 UTC ( #379341=scratchpad: print w/ replies, xml ) Need Help??

select distinct node.*, note.*, original_author, weight , votetime, considernodes.considernodes_id, considernodes.description as considertext from node left join note on note_id = node_id left join vote on (vote_id = node_id and voter_user = 108447) left join considernodes on considernodes_id = node_id left join contributor on contributor_id = node_id where type_nodetype in (7487 , 1036 , 115 , 120 , 23614 , 121 , 1584 , 1588 , 1042 , 956 , 31663 , 31670 , 1823 , 1857 , 1888 , 1980 , 1748 , 1440 , 389544 , 4,5 , 106924 , 14 , 397475 , 112733 , 356170 , 17338 , 370024 , 11 , 15) and createtime >= DATE_ADD('2006-03-31 16:00:14' , INTERVAL -1 DAY) and createtime <= '2006-03-31 16:00:14' limit 2000
node range typecreatetime,type typecreatetime 12   353 Using where; Using temporary
note eq_ref PRIMARY PRIMARY 4 node.node_id 1  
vote eq_ref PRIMARY,voter_user_idx PRIMARY 8 node.node_id,const 1 Using where
considernodes eq_ref PRIMARY PRIMARY 4 node.node_id 1  
contributor eq_ref PRIMARY PRIMARY 4 node.node_id 1  
select node.*, note.*, original_author, weight , votetime, considernodes.considernodes_id, considernodes.description as considertext from node left join note on node_id = note_id left join considernodes on considernodes_id = node_id left join contributor on contributor_id = node_id left join vote on (vote_id = node_id and voter_user = 108447) where node_id in ( 68307, 458233, 504328, 532692, 538243, 539202, 539324, 539575, 539619, 539653, 539720, 539816, 539829, 539862, 539903, 540025, 540053, 540080, 540136, 540167, 540182, 540184, 540231, 540237, 540253, 540262, 540263, 540267, 540276 ) and type_nodetype in (7487 , 1036 , 115 , 120 , 23614 , 121 , 1584 , 1588 , 1042 , 956 , 31663 , 31670 , 1823 , 1857 , 1888 , 1980 , 1748 , 1440 , 389544 , 4,5 , 106924 , 14 , 397475 , 112733 , 356170 , 17338 , 370024 , 11 , 15)
node range PRIMARY,typecreatetime,type PRIMARY 4   29 Using where
note eq_ref PRIMARY PRIMARY 4 node.node_id 1  
considernodes eq_ref PRIMARY PRIMARY 4 node.node_id 1  
contributor eq_ref PRIMARY PRIMARY 4 node.node_id 1  
vote eq_ref PRIMARY,voter_user_idx PRIMARY 8 node.node_id,const 1 Using where
select node.*, note.*, original_author, weight , votetime, considernodes.considernodes_id, considernodes.description as considertext from node , note left join considernodes on considernodes_id = node_id left join contributor on contributor_id = node_id left join vote on (vote_id = node_id and voter_user = 108447) where ( root_node in ( 68307, 458233, 504328, 532692, 538243, 539202, 539324, 539575, 539619, 539653, 539720, 539816, 539829, 539862, 539903, 540025, 540053, 540080, 540136, 540167, 540182, 540184, 540231, 540237, 540253, 540262, 540263, 540267, 540276, 540282, 540285, 540301, 540307, 540311, 540314, 540325, 540335, 540340, 540354, 540357, 540365, 540369, 540374, 540377, 540402, 540413, 540417, 540426, 540439, 540440, 540445, 540447, 540450, 540460, 540498, 540499, 540500, 540508, 540511, 540533, 540536 ) ) and not ( createtime >= DATE_ADD('2006-03-31 16:00:14' , INTERVAL -1 DAY) and createtime <= '2006-03-31 16:00:14' ) and node_id = note_id limit 2000
note range PRIMARY,root_node root_node 4   605 Using where
node eq_ref PRIMARY PRIMARY 4 note.note_id 1 Using where
considernodes eq_ref PRIMARY PRIMARY 4 node.node_id 1  
contributor eq_ref PRIMARY PRIMARY 4 node.node_id 1  
vote eq_ref PRIMARY,voter_user_idx PRIMARY 8 node.node_id,const 1 Using where
Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (16)
As of 2015-07-06 20:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (83 votes), past polls