This version is outdated by a newer approved version.DiffThis version (2017/05/14 19:05) was approved by zdimension.The Previously approved version (2017/01/24 20:35) is available.Diff
HY000 1 no such column: data_item.rid:
SELECT data_item.rid AS rid,
data_item.pid AS PID,
data_item.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_item.col13 AS C0,
data_item.col1 AS C1,
data_item.col2 AS C2,
data_item.col5 AS C3,
data_item.col6 AS C4,
data_item.col7 AS C5,
data_item.col8 AS C6,
data_item.col9 AS C7,
data_item.col10 AS C8,
data_item.col11 AS C9,
STRUCT_JSON(data_item.col12, T6.title) AS C10,
data_item.col4 AS C11
   FROM 
data_item AS data_item
LEFT OUTER JOIN titles AS T6 ON data_item.col12 = T6.pid
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_item.pid != ''
                    AND data_item.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'item'
  WHERE  ( ( data_item.pid = '' OR ( GETACCESSLEVEL(data_item.pid) > 0 AND PAGEEXISTS(data_item.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_item.latest = 1 AND ( ( data_item.col13 != '' AND CAST(data_item.col13 AS DECIMAL) >= CAST('0' AS DECIMAL) ) ) )
GROUP BY data_item.pid,
data_item.rid,
C0,
C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8,
C9,
C10,
C11
ORDER BY data_item.col5 COLLATE NOCASE ASC
SQL execution failed for SELECT data_item.rid AS rid, data_item.pid AS PID, data_item.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_item.col13 AS C0, data_item.col1 AS C1, data_item.col2 AS C2, data_item.col5 AS C3, data_item.col6 AS C4, data_item.col7 AS C5, data_item.col8 AS C6, data_item.col9 AS C7, data_item.col10 AS C8, data_item.col11 AS C9, STRUCT_JSON(data_item.col12, T6.title) AS C10, data_item.col4 AS C11 FROM data_item AS data_item LEFT OUTER JOIN titles AS T6 ON data_item.col12 = T6.pid LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_item.pid != '' AND data_item.pid = schema_assignments.pid AND schema_assignments.tbl = 'item' WHERE ( ( data_item.pid = '' OR ( GETACCESSLEVEL(data_item.pid) > 0 AND PAGEEXISTS(data_item.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_item.latest = 1 AND ( ( data_item.col13 != '' AND CAST(data_item.col13 AS DECIMAL) >= CAST(? AS DECIMAL) ) ) ) GROUP BY data_item.pid, data_item.rid, C0, C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11 ORDER BY data_item.col5 COLLATE NOCASE ASC [Search.php:365]
HY000 1 no such column: data_item.rid:
SELECT data_item.rid AS rid,
data_item.pid AS PID,
data_item.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_item.col15 AS C0,
data_item.col1 AS C1,
data_item.col2 AS C2,
data_item.col5 AS C3,
data_item.col6 AS C4,
data_item.col7 AS C5,
data_item.col8 AS C6,
data_item.col9 AS C7,
data_item.col10 AS C8,
data_item.col11 AS C9,
STRUCT_JSON(data_item.col12, T7.title) AS C10,
data_item.col4 AS C11
   FROM 
data_item AS data_item
LEFT OUTER JOIN titles AS T7 ON data_item.col12 = T7.pid
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_item.pid != ''
                    AND data_item.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'item'
  WHERE  ( ( data_item.pid = '' OR ( GETACCESSLEVEL(data_item.pid) > 0 AND PAGEEXISTS(data_item.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_item.latest = 1 AND ( ( data_item.col15 != '' AND CAST(data_item.col15 AS DECIMAL) >= CAST('0' AS DECIMAL) ) ) )
GROUP BY data_item.pid,
data_item.rid,
C0,
C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8,
C9,
C10,
C11
ORDER BY data_item.col5 COLLATE NOCASE ASC
SQL execution failed for SELECT data_item.rid AS rid, data_item.pid AS PID, data_item.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_item.col15 AS C0, data_item.col1 AS C1, data_item.col2 AS C2, data_item.col5 AS C3, data_item.col6 AS C4, data_item.col7 AS C5, data_item.col8 AS C6, data_item.col9 AS C7, data_item.col10 AS C8, data_item.col11 AS C9, STRUCT_JSON(data_item.col12, T7.title) AS C10, data_item.col4 AS C11 FROM data_item AS data_item LEFT OUTER JOIN titles AS T7 ON data_item.col12 = T7.pid LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_item.pid != '' AND data_item.pid = schema_assignments.pid AND schema_assignments.tbl = 'item' WHERE ( ( data_item.pid = '' OR ( GETACCESSLEVEL(data_item.pid) > 0 AND PAGEEXISTS(data_item.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_item.latest = 1 AND ( ( data_item.col15 != '' AND CAST(data_item.col15 AS DECIMAL) >= CAST(? AS DECIMAL) ) ) ) GROUP BY data_item.pid, data_item.rid, C0, C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11 ORDER BY data_item.col5 COLLATE NOCASE ASC [Search.php:365]
HY000 1 no such column: data_item.rid:
SELECT data_item.rid AS rid,
data_item.pid AS PID,
data_item.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_item.col16 AS C0,
data_item.col1 AS C1,
data_item.col2 AS C2,
data_item.col5 AS C3,
data_item.col6 AS C4,
data_item.col7 AS C5,
data_item.col8 AS C6,
data_item.col9 AS C7,
data_item.col10 AS C8,
data_item.col11 AS C9,
STRUCT_JSON(data_item.col12, T8.title) AS C10,
data_item.col4 AS C11
   FROM 
data_item AS data_item
LEFT OUTER JOIN titles AS T8 ON data_item.col12 = T8.pid
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_item.pid != ''
                    AND data_item.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'item'
  WHERE  ( ( data_item.pid = '' OR ( GETACCESSLEVEL(data_item.pid) > 0 AND PAGEEXISTS(data_item.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_item.latest = 1 AND ( ( data_item.col16 != '' AND CAST(data_item.col16 AS DECIMAL) >= CAST('0' AS DECIMAL) ) ) )
GROUP BY data_item.pid,
data_item.rid,
C0,
C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8,
C9,
C10,
C11
ORDER BY data_item.col5 COLLATE NOCASE ASC
SQL execution failed for SELECT data_item.rid AS rid, data_item.pid AS PID, data_item.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_item.col16 AS C0, data_item.col1 AS C1, data_item.col2 AS C2, data_item.col5 AS C3, data_item.col6 AS C4, data_item.col7 AS C5, data_item.col8 AS C6, data_item.col9 AS C7, data_item.col10 AS C8, data_item.col11 AS C9, STRUCT_JSON(data_item.col12, T8.title) AS C10, data_item.col4 AS C11 FROM data_item AS data_item LEFT OUTER JOIN titles AS T8 ON data_item.col12 = T8.pid LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_item.pid != '' AND data_item.pid = schema_assignments.pid AND schema_assignments.tbl = 'item' WHERE ( ( data_item.pid = '' OR ( GETACCESSLEVEL(data_item.pid) > 0 AND PAGEEXISTS(data_item.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_item.latest = 1 AND ( ( data_item.col16 != '' AND CAST(data_item.col16 AS DECIMAL) >= CAST(? AS DECIMAL) ) ) ) GROUP BY data_item.pid, data_item.rid, C0, C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11 ORDER BY data_item.col5 COLLATE NOCASE ASC [Search.php:365]
HY000 1 no such column: data_item.rid:
SELECT data_item.rid AS rid,
data_item.pid AS PID,
data_item.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_item.col17 AS C0,
data_item.col1 AS C1,
data_item.col2 AS C2,
data_item.col5 AS C3,
data_item.col6 AS C4,
data_item.col7 AS C5,
data_item.col8 AS C6,
data_item.col9 AS C7,
data_item.col10 AS C8,
data_item.col11 AS C9,
STRUCT_JSON(data_item.col12, T9.title) AS C10,
data_item.col4 AS C11
   FROM 
data_item AS data_item
LEFT OUTER JOIN titles AS T9 ON data_item.col12 = T9.pid
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_item.pid != ''
                    AND data_item.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'item'
  WHERE  ( ( data_item.pid = '' OR ( GETACCESSLEVEL(data_item.pid) > 0 AND PAGEEXISTS(data_item.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_item.latest = 1 AND ( ( data_item.col17 != '' AND CAST(data_item.col17 AS DECIMAL) >= CAST('0' AS DECIMAL) ) ) )
GROUP BY data_item.pid,
data_item.rid,
C0,
C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8,
C9,
C10,
C11
ORDER BY data_item.col5 COLLATE NOCASE ASC
SQL execution failed for SELECT data_item.rid AS rid, data_item.pid AS PID, data_item.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_item.col17 AS C0, data_item.col1 AS C1, data_item.col2 AS C2, data_item.col5 AS C3, data_item.col6 AS C4, data_item.col7 AS C5, data_item.col8 AS C6, data_item.col9 AS C7, data_item.col10 AS C8, data_item.col11 AS C9, STRUCT_JSON(data_item.col12, T9.title) AS C10, data_item.col4 AS C11 FROM data_item AS data_item LEFT OUTER JOIN titles AS T9 ON data_item.col12 = T9.pid LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_item.pid != '' AND data_item.pid = schema_assignments.pid AND schema_assignments.tbl = 'item' WHERE ( ( data_item.pid = '' OR ( GETACCESSLEVEL(data_item.pid) > 0 AND PAGEEXISTS(data_item.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_item.latest = 1 AND ( ( data_item.col17 != '' AND CAST(data_item.col17 AS DECIMAL) >= CAST(? AS DECIMAL) ) ) ) GROUP BY data_item.pid, data_item.rid, C0, C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11 ORDER BY data_item.col5 COLLATE NOCASE ASC [Search.php:365]
HY000 1 no such column: data_item.rid:
SELECT data_item.rid AS rid,
data_item.pid AS PID,
data_item.rev AS rev,
schema_assignments.assigned AS ASSIGNED,
data_item.col18 AS C0,
data_item.col1 AS C1,
data_item.col2 AS C2,
data_item.col5 AS C3,
data_item.col6 AS C4,
data_item.col7 AS C5,
data_item.col8 AS C6,
data_item.col9 AS C7,
data_item.col10 AS C8,
data_item.col11 AS C9,
STRUCT_JSON(data_item.col12, T10.title) AS C10,
data_item.col4 AS C11
   FROM 
data_item AS data_item
LEFT OUTER JOIN titles AS T10 ON data_item.col12 = T10.pid
LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_item.pid != ''
                    AND data_item.pid = schema_assignments.pid
                    AND schema_assignments.tbl = 'item'
  WHERE  ( ( data_item.pid = '' OR ( GETACCESSLEVEL(data_item.pid) > 0 AND PAGEEXISTS(data_item.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_item.latest = 1 AND ( ( data_item.col18 != '' AND CAST(data_item.col18 AS DECIMAL) >= CAST('0' AS DECIMAL) ) ) )
GROUP BY data_item.pid,
data_item.rid,
C0,
C1,
C2,
C3,
C4,
C5,
C6,
C7,
C8,
C9,
C10,
C11
ORDER BY data_item.col5 COLLATE NOCASE ASC
SQL execution failed for SELECT data_item.rid AS rid, data_item.pid AS PID, data_item.rev AS rev, schema_assignments.assigned AS ASSIGNED, data_item.col18 AS C0, data_item.col1 AS C1, data_item.col2 AS C2, data_item.col5 AS C3, data_item.col6 AS C4, data_item.col7 AS C5, data_item.col8 AS C6, data_item.col9 AS C7, data_item.col10 AS C8, data_item.col11 AS C9, STRUCT_JSON(data_item.col12, T10.title) AS C10, data_item.col4 AS C11 FROM data_item AS data_item LEFT OUTER JOIN titles AS T10 ON data_item.col12 = T10.pid LEFT OUTER JOIN schema_assignments AS schema_assignments ON data_item.pid != '' AND data_item.pid = schema_assignments.pid AND schema_assignments.tbl = 'item' WHERE ( ( data_item.pid = '' OR ( GETACCESSLEVEL(data_item.pid) > 0 AND PAGEEXISTS(data_item.pid) = 1 AND (ASSIGNED = 1 OR ASSIGNED IS NULL) ) ) AND data_item.latest = 1 AND ( ( data_item.col18 != '' AND CAST(data_item.col18 AS DECIMAL) >= CAST(? AS DECIMAL) ) ) ) GROUP BY data_item.pid, data_item.rid, C0, C1, C2, C3, C4, C5, C6, C7, C8, C9, C10, C11 ORDER BY data_item.col5 COLLATE NOCASE ASC [Search.php:365]

Catalogues

This page contains reference catalogues of different game models.

Tomb Raider 1

Tomb Raider 2

Tomb Raider 3

Tomb Raider 4

Tomb Raider 5

Catalogue editor

The editor is now located here.

catalogues/catalogues.txt · Last modified: 2017/02/04 17:36 (external edit)
Back to top
CC Attribution-Share Alike 4.0 International
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0