An Error Was Encountered

Error Number: 1146

Table 'posuda_new.indx_prod_in_cat' doesn't exist

SELECT (SELECT group_concat(concat(m.manufName,'||',m.manufUrl) order by if(bt.manufID is not null,1000000+indx_prod_in_cat.prodRealCount,indx_prod_in_cat.prodRealCount) DESC) as m from indx_prod_in_cat join manufacturers m on (m.manufID = indx_prod_in_cat.manufID) left join brands_type bt on m.manufID=bt.manufID and bt.brandTypeID=1 left join indx_brand_count ibc on ibc.manufID =m.manufID WHERE indx_prod_in_cat.catID=c.catID and indx_prod_in_cat.prodRealCount>ibc.brandCount ) as manufs, sc.cSeries as countSeries, m.manufID, m.manufUrl, m.manufName, ise.linkName as linkName, ise.linkType, ise.seoLinkID, c.catSeoLink, c.catID, iptca.totalCount, ipinc.prodRealCount as countAvailProd FROM indx_seolinks ise JOIN indx_seolink_to_cat istc ON istc.seoLinkID=ise.seoLinkID JOIN categories c ON ise.catID=c.catID left join manufacturers m on (m.manufID = ise.brandID) left join indx_brand_count ibc on ibc.manufID =m.manufID LEFT JOIN indx_prod_in_cat ipinc ON ipinc.manufID=m.manufID and ipinc.catID=c.catID and ibc.brandCount < ipinc.prodRealCount left JOIN indx_prod_to_cat_avail iptca ON c.catID = iptca.catID LEFT JOIN (select count(DISTINCT seriesID) cSeries, manufID from series where seriesPsevdo=0 GROUP BY manufID) sc ON sc.manufID=m.manufID WHERE istc.catID=197 GROUP BY ise.seoLinkID order by ise.linkType asc,iptca.totalCount desc

Memory usage: 1978832