select W.*,WP.price,WP.flag_action,T.koeficient,T.sdesc as dphtext,U.sdesc as unit_text from ware W,ware_price WP,taxes T,units U where W.group_id in () and W.status=1 and WP.price_c_id = 1 and WP.ware_id = W.id and T.id=W.taxe_id and U.id=W.unit_id order by W.sdesc asc LIMIT 0,50
|