Главная

Интернет-магазин электроинструментов и садовой техники

Makita Hitachi Bosch
Table 'apittools.action' doesn't exist --> select a.id as act_id, a.img as act_img, a.name as act_name, o.catalog_id as menu, o.vendor_id as ven, o.*, d.t_name, v.name as v_name, m.p1, FLOOR(coalesce(o.cur_price, o.last_price) * (SELECT IF(a.`type` = 'P',apitcomp.inc_perc(a.dollar,a.p_nal_cbr),a.nal_stat) as nal FROM (SELECT i.*,u.`dollar` FROM apitcomp.`usd_info` i, apitcomp.`usd` u ORDER BY u.`index` DESC LIMIT 1) a )) as cur_rub,count(ss.id) as lim from apittools.action a inner join apittools.super s on s.act = a.id inner join apitcomp.store o on o.id = s.id and o.status < 'C' left join apittools.store_desc d on d.id = o.id left join apittools.vendor v on v.id = o.vendor_id left join apitcomp.menu_tools m on m.id = o.catalog_id inner join apittools.super ss on ss.act = a.id and s.id <= ss.id inner join apitcomp.store oo on oo.id = ss.id and oo.status < 'C' where a.active > 0 group by a.id, s.id having lim <= 3 order by a.id