Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
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 studying the Monastery: (6)
As of 2014-09-03 03:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (35 votes), past polls