You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (laststatus > "5") and and order by disporder, orders.id desc' at line 141
select
orders.id,
acctno,
client.company,
client.shortname,
client.taxgroup,
client.fs_ovrd,
client.billing_code,
from_name,
from_addr,
from_pc,
from_zone,
from_phone,
from_contact,
orderedby,
to_name,
to_addr,
to_pc,
to_zone,
to_phone,
to_attn,
service,
ordertm,
statusname,
deliverytm,
comments,
description,
message,
chargecode,
enteredby,
drivernum,
drivernum2,
price,
fs_rate,
fs_on_service,
fs_on_wait,
fs_on_xtra,
quoted_price_pickup,
quoted_price_delivery,
quoted_fromzone,
quoted_tozone,
quoted_price_weight,
quoted_price_pieces,
quoted_price_volume,
quoted_price_cb1,
quoted_price_cb2,
quoted_price_cb3,
quoted_price_svc1,
quoted_price_svc2,
quoted_price_svc3,
quoted_price_svc4,
quoted_price_svc5,
quoted_price_min_upchg,
quoted_price_discount,
ovrd_price_pickup,
ovrd_price_delivery,
ovrd_price_weight,
ovrd_price_pieces,
ovrd_price_volume,
ovrd_price_cb1,
ovrd_price_cb2,
ovrd_price_cb3,
ovrd_price_svc1,
ovrd_price_svc2,
ovrd_price_svc3,
ovrd_price_svc4,
ovrd_price_svc5,
ovrd_price_min_upchg,
ovrd_price_discount,
weight,
pieces,
pieces_type,
volume,
req_vehicle,
calc_vehicle,
pickuptm,
laststatus,
checkbox1,
checkbox2,
checkbox3,
xtra1,
xtra2,
xtra3,
xtra4,
xtra5,
`return`,
nosig,
wait_time,
wait_charges,
invoiceno,
additional,
additional_desc,
additional2,
additional2_desc,
additional3,
additional3_desc,
wait_auth,
commission_adj,
commission_adj_desc,
commission_svc_pct ,
commission_wait_pct,
commission_xtra_pct,
commission_fs_pct,
ovrd_commission_svc_pct,
ovrd_commission_wait_pct,
ovrd_commission_xtra_pct,
ovrd_commission_fs_pct,
commission_adj2,
commission_adj_desc2,
commission_svc_pct2,
commission_wait_pct2,
commission_xtra_pct2,
commission_fs_pct2,
ovrd_commission_svc_pct2,
ovrd_commission_wait_pct2,
ovrd_commission_xtra_pct2,
ovrd_commission_fs_pct2,
manual_wb,
pickup_by,
pickup_day,
pickup_time,
pickup_ampm,
pickup_date,
deliver_by,
deliver_day,
deliver_time,
deliver_ampm,
deliver_date,
pop,
pod,
invoice_goodtogo
from
orders,
status,
client
where
(orders.laststatus=status.id) and (orders.customer = client.id) and ( (ordertm >= '2012-02-23') or
( (laststatus = '4') or
(laststatus = '3') or
(laststatus = '1') or
(laststatus = '6') ) ) and (checkbox1 != 'R') and and (laststatus > "5") and and order by disporder, orders.id desc
