Icon серые летние для очень жаркой погоды Icon Basehawk2 Icon Hooligan Icon Mesh AF Leather CE Icon Motorhead3 Icon Patrol3 WP CE Icon Tuscadero2 CE Wmn Icon Uparmor Covec Icon Uparmor

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] => 
)