SELECT price.col1         AS col1 ,
        price.col2         AS col2 ,
        price.col3         AS col3 ,
        MAX ( price.col4 ) AS col4 ,
        MAX ( price.col5 ) AS col5 ,
        MAX ( price.col6 ) AS col6 ,
        MAX ( price.col7 ) AS col7
   FROM table_1 t1 ,
        table_2 t2
  WHERE col1                    = col2
        AND column_1            = small_column
        AND column_3411        <= column_12_sup
        AND col1                = 'Test Run'
        AND column_4532         = c1.dert
        AND librarystat.column2 = library.column2
        OR
        (
                librarystat.column4     = library.column4
                AND librarystat.column5 = library.column5
        )
        AND
        (
                librarystat.column5    = 'I'
                OR librarystat.column4 = 'Gold'
                OR librarystat.column5 = 'Bold'
        )
        AND librarystat.column6 <= 'Z74'

 SELECT price.col1         AS col1 ,
        price.col2         AS col2 ,
        price.col3         AS col3 ,
        MAX ( price.col4 ) AS col4 ,
        MAX ( price.col5 ) AS col5 ,
        MAX ( price.col6 ) AS col6 ,
        MAX ( price.col7 ) AS col7
   FROM table_1 t1 ,
        table_2 t2
  WHERE col1                = col2
    AND column_1            = small_column
    AND column_3411        <= column_12_sup
    AND col1                = 'Test Run'
    AND column_4532         = c1.dert
    AND librarystat.column2 = library.column2
     OR
        (
                librarystat.column4 = library.column4
            AND librarystat.column5 = library.column5
        )
    AND
        (
                librarystat.column5 = 'I'
             OR librarystat.column4 = 'Gold'
             OR librarystat.column5 = 'Bold'
        )
    AND librarystat.column6 <= 'Z74'