Admin order.php when search products receiving SQL Error:
1054 Unknown column 'o.orders_id' in 'on clause'
in:
[select count(distinct o.orders_id) as total from (orders o, orders_status s left join orders_products op on (op.orders_id = o.orders_id) ) left join orders_total ot on (o.orders_id = ot.orders_id) where (o.orders_status = s.orders_status_id and s.language_id = '2' and ot.class = 'ot_total') and (op.products_model like '%ttt%' or op.products_name like 'ttt%')]

MySQL 5.1.22-rc-log
5.2.5 (Zend: 2.2.0)
Zen Cart 1.3.8a
v1.3.8 [2008-04-10 13:05:03] (Fresh Installation)
Fresh installation - no any modules.

Line 720-721, 732-733, 744-745
Code:
                            TABLE_ORDERS_STATUS . " s " .
                            $new_table . ")
replace by
Code:
                            TABLE_ORDERS_STATUS . " s )" .
                            $new_table . "