Icon : мотокуртки, мотоботы (мотообувь) 7 8 8.5 11 13 36 3XL

Db error: Column 'Resource' in where clause is ambiguous

Error code: 1052

Query: SELECT catalog_actions.ID,catalog_actions.Name,catalog_actions.Code,catalog_actions.Type,catalog_actions.Image,catalog_actions.Image2,catalog_actions.H,catalog_actions.SortIndex,catalog_actions.Hide,catalog_actions.DateStart,catalog_actions.DateFinish,catalog_actions.DiscountID,catalog_actions.Title,catalog_actions.Keywords,catalog_actions.Description,catalog_actions.SalesNotes,catalog_actions.Domains,IF(DateFinish IS NULL, 1, 0) as IsInfinite FROM catalog_actions INNER JOIN catalog_actions_to_cats ON catalog_actions_to_cats.ActionID = catalog_actions.ID LEFT JOIN user_filters ON user_filters.Resource='iCatalogAction' AND user_filters.ResourceID=catalog_actions.ID WHERE (DateStart IS NULL OR DateStart <= CURRENT_DATE) AND (DateFinish IS NULL OR DateFinish >= CURRENT_DATE) AND ( user_filters.ID IS NULL OR (user_filters.ID > 0 AND ((user_filters.`Groups` = '' OR FIND_IN_SET('6', user_filters.`Groups`)))) ) AND `Resource` = ? AND `ResourceID` = ? AND (catalog_actions.Domains = '' OR FIND_IN_SET('72', catalog_actions.Domains)) AND catalog_actions.Hide = ? ORDER BY IsInfinite ASC, DateFinish ASC LIMIT 1

Params:

Array
(
    [0] => iCatalogBrand
    [1] => 9307
    [2] => 
)

Db error: Column 'Resource' in where clause is ambiguous

Error code: 1052

Query: SELECT catalog_actions.ID,catalog_actions.Name,catalog_actions.Code,catalog_actions.Type,catalog_actions.Image,catalog_actions.Image2,catalog_actions.H,catalog_actions.SortIndex,catalog_actions.Hide,catalog_actions.DateStart,catalog_actions.DateFinish,catalog_actions.DiscountID,catalog_actions.Title,catalog_actions.Keywords,catalog_actions.Description,catalog_actions.SalesNotes,catalog_actions.Domains FROM catalog_actions INNER JOIN catalog_actions_to_cats ON catalog_actions_to_cats.ActionID = catalog_actions.ID LEFT JOIN user_filters ON user_filters.Resource='iCatalogAction' AND user_filters.ResourceID=catalog_actions.ID WHERE DateStart > CURRENT_DATE AND ( user_filters.ID IS NULL OR (user_filters.ID > 0 AND ((user_filters.`Groups` = '' OR FIND_IN_SET('6', user_filters.`Groups`)))) ) AND `Resource` = ? AND `ResourceID` = ? AND (catalog_actions.Domains = '' OR FIND_IN_SET('72', catalog_actions.Domains)) AND catalog_actions.Hide = ? ORDER BY DateStart ASC LIMIT 1

Params:

Array
(
    [0] => iCatalogBrand
    [1] => 9307
    [2] => 
)