public static string SelectList(bool limitOffset) => QueryFormat.Select(ColList, Tables, Filter, GroupBy, OrderBy, !limitOffset);
public static string ImageList(IList <long> ids)
=> QueryFormat.Select(@"ITEMID as 'Key',MIN(FILELOCATION) AS 'Value'", "IMAGELOCATION",
$"ITEMID IN({string.Join(",", ids) ?? "0"})", "ITEMID");
public static string SelectList(bool limitOffset) => QueryFormat.Select(OuterList,
$"({QueryFormat.Select(InnerList, Tables, Filter, InnerGroup)}) compo",
null,
OuterGroup,
OuterOrder,
limitOffset);