View 'opony_4oponki.rating' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
SELECT SQL_CALC_FOUND_ROWS `products`.*, `ps`.`iProduct` `iProductSatis`, `promoted`.`iPromotedMin`, `producers`.`sName` AS `prodsName`, `producers`.`sLogoUrl` AS `prodsLogoUrl`, `prodgroups`.`sName` AS `prodsGroupName`, `prodgroups`.`sLogoUrl` AS `prodsGroupLogoUrl`, `producers`.`sType` AS `sProducersClass`, `products`.`TiAvailable` AS `iAvailable`, `ai`.*, `ai`.`iVal7` `iSezon`, `rating`.`fRatingAvg`, `rating`.`iCommentsCount`, `products`.`fPrice` AS `fCatalogPrice`, `vat`.`fVatValue`, ss11_pl_calculateProductPriceForUser( NULL, `products`.`iProduct`, 0 ) AS `fPrice`, LEAST( `products`.`TiCanBuy`, ss11_pl_getProductCanBuyForUser ( NULL, `products`.`iProduct` ) ) AS `iCanBuy`, `products`.`TiVariantsCount` AS `iVariantCount`, ss11_pl_getProductVisiblePriceForUser ( NULL, `products`.`iProduct` ) AS `iVisiblePrice` FROM `ss11_pl_products` AS `products` LEFT JOIN `opony_sklep`.`ss11_pl_products_attributes_flat` AS `ai` USING( `iProduct` ) LEFT JOIN ( SELECT MIN( `iPromoted` ) `iPromotedMin`, `iProduct` FROM `ss11_pl_products_promoted` GROUP BY `iProduct` ) `promoted` USING( `iProduct` ) INNER JOIN `ss11_vat` AS `vat` USING( `iVat` ) LEFT JOIN `ss11_pl_producers` AS `producers` USING( `iProducer` ) LEFT JOIN `ss11_pl_producers` AS `prodgroups` ON( prodgroups.`iProducer` = `producers`.`iProducersGroup` ) INNER JOIN `ss11_pl_products_variants` AS `pv` USING( `iProduct` ) LEFT JOIN `ss11_pl_products_attributes` AS `pa` ON( `pv`.`iProductVariant` = `pa`.`iProductVariant` AND `iAttributeValue` IN( 4, 5, 6 ) ) LEFT JOIN `ss11_pl_products_satis` AS `ps` ON( `products`.`iProduct` = `ps`.`iProduct` ) LEFT JOIN `rating` ON( `rating`.`iProducer` = `products`.`iProducer` AND `rating`.`iModel` = `iVal18` ) WHERE 1 AND `products`.`TiStock` >= 1 AND `products`.`TiCanBuy` >= 1 AND `products`.`iMainCategory` IN( 66, 67, 100, 1160, 3, 154, 155 ) AND `products`.`TiStock` >= 4 AND `products`.`iProduct` IN ( '129845', '129848', '129846', '158722', '36526', '129847', '159273', '167024' ) AND EXISTS ( SELECT 1 FROM `ss11_pl_products_pages` AS `products_pages` WHERE `products`.`iProduct` = `products_pages`.`iProduct` AND `products_pages`.`iPage` IN ( '1', '3', '1160', '66', '67', '100', '154', '155', '99', '134', '79', '133', '48', '49', '132', '131', '98', '102', '103', '80', '71', '106', '108', '107', '104', '105', '114', '110', '115', '116', '117', '118', '111', '119', '120', '121', '122', '123', '124', '125', '112', '109', '126', '113', '4', '5', '6', '7', '8', '17', '18', '19', '20', '70', '69', '2', '95', '87', '93', '85', '97', '90', '156', '158', '81', '74', '75', '127', '73', '157', '9', '89', '84', '92', '96', '86', '128', '83', '1171', '94', '91', '130', '129', '88', '77', '78', '10', '82', '11', '22', '12', '76', '1174', '1173', '1175', '13', '135', '1176', '14', '15', '1177', '72', '16', '1167', '1169', '1170', '1172', '1166', '59', '60', '61', '53', '55', '57', '56', '54', '62', '63', '64', '65', '58' ) LIMIT 1 ) AND ss11_pl_getProductVisibleForUser ( NULL, `products`.`iProduct` ) >= 1 AND `products`.`iStatus` >= 1 GROUP BY `products`.`iProduct` ORDER BY RAND() LIMIT 0,8