Pulling your hair out because of errors like so: "ERROR 1248 (42000): Every derived table must have its own alias" ?

If you have several complicated unioned queries that you want to use in a sub query try encapsulating them like so:

SELECT col1,col2,col3 FROM
(

SELECT * FROM
(
SELECT col1,col2,col3 FROM myTable WHERE ... etc.
) AS DerivedTable1

UNION

SELECT * FROM
(
SELECT col1,col2,col3 FROM myTable WHERE ... etc.
) AS DerivedTable2

) AS MainTable GROUP BY... HAVING... ORDER BY... LIMIT... etc.

This method of aliasing will add years to your life by providing the unique distinction required of derived tables in sub queries without having to spend a bunch of time trying to alias every table and field while continuing to get "derived table" errors. Thanks goes to David Fells for helping me keep some of my hair over this one!

Have fun.

... I have decided to just post my nuggets that I have taken away from Robert B. Laughlin's The Crime of Reason.

...

Most entertainment is the celebration of disposable knowledge. In fact, when we are relaxing we avoid useful information. This is why some people do not like my Facebook posts and Twitter updates. They are on these technologies to relax and I am confronting them with potential useful information. (Sorry, but I do not plan to stop. Just unfriend or unfollow me, I am really OK with it.) Let me quote from the book, "Soap operas are enjoyable because their intellectual maintenance costs are low."

All advertising is information you do not want to see. "Advertising is Fun's evil twin brother. The two go everywhere together." If you want to enjoy yourself from free you have to accept advertising.

...in their use of the commons, the Itza' break free of the textbook ‘resource exploitation' frame by means of one of the fundamental orientations of human cognition: the tendency to believe in supernatural entities. (See Atran's 2002 book In Gods we Trust.) Atran and Medin show that the Itza' do not treat forest resources as mere ‘objects of a payoff matrix' (as perhaps some of their neighbours do), but rather ‘as intentional, relational entities, like friends or enemies'. For the Itza', the spirits of the forest have supernatural powers of knowledge. Villagers believe that if they fail to respect the kind of reciprocal relationship with these spirits that would be expected of any human social relationship, they risk being punished. These beliefs are reflected in behaviour patterns that turn out to be the most sustainable of these three neighbouring ethnic groups.

          

          Tagged by mshook under 
         
6,

december,

2009,

a,

judell,

good,

listened,

church,

xml,

database,

social,

book,

fcc,

spectrum,

scarcity,

radio,

wireless,

cognitive,

game,

flickr,

xslt,

server,

pantry,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Sun, 06 Dec 2009 07:41:00 -0500
      
    
      
      
      


  
    
  
  
  


      
        
        
        pointed to data which shows that though organized religion has collapsed in much of Europe, the slack has been taken up more by unaffiliated theism than atheism. The star in The Faith Instinct is the horizontal and integrative dimension of religion, but it seems that in the developed world a combination of rampant pluralism as well as a general weakening of organized religions is breaking bonds which tie people together in a sacred body. Rather, it is a more atomistic faith instinct on the individual level which persists once the communal aspect is stripped away, a world of ghosts, energies and spirits. The future may be Sedona and not Ethical Culture
          

          Tagged by mshook under 
         
book,

review,

religion,

via,

scottatran,

search,

dawkins,

good,

links,

faith,

belief,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Sat, 05 Dec 2009 10:54:00 -0500
      
    
      
      
      


  
    
  
  
  


      
        
        
        DITA also recognized ... that a small topic-specific DTD is easier to use and to validate than a big generic document-oriented DTD like DocBook. But the problem ... is, how do you manage the relationship between the DTDs, and how do you add a new DTD without having to rewrite your whole tool chain?

... First, it uses a simple mapping mechanism to create a new DTD as a "specialization" of an existing DTD. Second, it uses a trick based on the way XSLT works to enable a transform written for the base DTD to also work for the specialized DTD, and to allow you to write a transform for the specific properties of the new DTD that inherits transforms written for the old DTD without change.
DITA thus limits you in two ways. First, the relationship between new DTDs and existing DTDs can only be expressed by a very simple mapping mechanism. ... Also, existing XSLT transforms cannot be incorporated into the DITA tool chain; they have to be specifically written for DITA.
          

          Tagged by mshook under 
         
dita,

docbook,

critique,

dtd,

xml,

why,

comparison,

documentation,

how,

xslt,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Sat, 05 Dec 2009 08:05:00 -0500
      
    
      
      
      


  
    
  
  
  


      
        
        
        

          Tagged by mshook under 
         
json,

feed,

sidewiki,

atom,

api,

annotation,

note,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Sat, 05 Dec 2009 04:26:00 -0500
      
    
      
      
      


  
    
  
  
  


      
        
        
        

          Tagged by mshook under 
         
local,

swh,

southwestharbor,

art,

betsie,

eben,

painting,

watercolor,

card,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Sat, 05 Dec 2009 10:41:00 -0500
      
    
      
      
      


  
    
  
  
  


      
        
        
        
                                     MARY
                         Murr, have you noticed anything funny 
                         with the teletype machine this 
                         morning? I sure hope there's something 
                         wrong with it.

                                     MURRAY
                         Why?

                                     MARY
                         Because if there isn't President 
                         Ford just held up a liquor store 
                         with a water pistol.