'show_valid'=>Array('label'=>'la_Text_Valid','on_sql'=>'','off_sql'=>'%1$s.ValidationStatus != '.LINK_VALIDATION_VALID.' OR %1$s.ValidationStatus IS NULL'),
'show_invalid'=>Array('label'=>'la_Text_Invalid','on_sql'=>'','off_sql'=>'%1$s.ValidationStatus != '.LINK_VALIDATION_INVALID.' OR %1$s.ValidationStatus IS NULL'),
'show_not_validated'=>Array('label'=>'la_Text_Not_Validated','on_sql'=>'','off_sql'=>'%1$s.ValidationStatus != '.LINK_VALIDATION_NOT_VALIDATED.' OR %1$s.ValidationStatus IS NOT NULL'),
)
),
'ListSQLs'=>Array(
''=>' SELECT %1$s.* %2$s
FROM '.TABLE_PREFIX.'Link l
LEFT JOIN %1$s ON %1$s.LinkId = l.LinkId
LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON ci.ItemResourceId = l.ResourceId
LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId',
),
'ListSortings'=>Array(
''=>Array(
'Sorting'=>Array('LinkValidationId'=>'desc'),
)
),
'CalculatedFields'=>Array(
''=>Array(
'ForeignLinkId'=>'l.LinkId',
'LinkName'=>'l.Name',
'LinkUrl'=>'l.Url',
'LinkCreatedOn'=>'l.CreatedOn',
'LinkStatus'=>'l.Status',
'LinkValidationStatus'=>'IF(%1$s.ValidationStatus IS NULL, '.LINK_VALIDATION_NOT_VALIDATED.', %1$s.ValidationStatus)',
'formatter'=>'kOptionsFormatter','options'=>Array(200=>'200 OK',301=>'301 Moved Permanently',302=>'302 Found',400=>'400 Bad Request',403=>'403 Forbidden',404=>'404 Not Found',500=>'500 Internal Server Error'),