SQL fail: Unknown column 'p.mark' in 'field list' Query: select l.*, s.header as subotr_header, o.header as otr_header, u.firm, u.email, u.contact, (now() between startdate and stopdate) as can_offer, (now()<startdate) as offer_future, (now()>stopdate) as offer_end, (now()<t_start) as trade_future, (now()>t_end) as trade_end, (now() between t_start and t_end) as can_trade, p.mark, p.volume, p.usl_volume, volume_types.header as v_type,p.pricecap, valutes.header as valute_name, usl_opl_types.header as o_type, usl_post_types.header as p_type, u.show_name from katalog_1 as l left join subotr as s on l.subotr=s.id left join otr as o on l.otr=o.id left join owner as u on l.owner_id=u.owner_id left join lot as p on l.product=p.product left join volume_types on p.usl_volume=volume_types.id left join valutes on l.valuta=valutes.id left join usl_opl_types on l.usl_opl=usl_opl_types.id left join usl_post_types on l.usl_post=usl_post_types.id where l.product='5560693' at /www/trade.su-2010/htdocs/bidding.pl line 160
For help, please send mail to the webmaster (sysadmin@trade.su), giving this error message and the time and date of the error.