Database error: Invalid SQL: create table myprice_tmp.product_tmp_15 ENGINE = MyISAM select p.id as id,p.manufacturerid as manufacturerid,p.series_id as series_id,p.name as name,p.regdate as regdate,p.release_date as release_date,o.submit_date as submit_date,o.grade as grade,sp.price as price,p.stop as stop,IF(sp.price,1,0) as ifprice,h.hits as hits from products p left outer join product_editor_opinion o on p.id=o.productid left outer join shop_product_tmp sp on sp.productid=p.id left outer join product_hits_statistics h on h.product_id=p.id and h.interval_day=30 where p.subcategoryid=15 and p.stop=0 and p.confirm=1 group by p.id
MySQL Error: 1050 (Table 'product_tmp_15' already exists)
Session halted.