SELECT 
  t0.id AS id1, 
  t0.cKey AS cKey2, 
  t0.value AS value3 
FROM 
  Config t0 
WHERE 
  t0.cKey = ? 
LIMIT 
  1

SELECT t0.id AS id1, t0.cKey AS cKey2, t0.value AS value3 FROM Config t0 WHERE t0.cKey = 'security_authentication_method' LIMIT 1;

SELECT 
  p0_.id AS id0, 
  p0_.name AS name1, 
  p0_.cost AS cost2, 
  p0_.description AS description3, 
  p0_.leaderboard AS leaderboard4, 
  p0_.amazon AS amazon5, 
  p0_.nameCanonical AS nameCanonical6, 
  p0_.downloadFile AS downloadFile7, 
  p0_.downloadLimit AS downloadLimit8, 
  p0_.image AS image9, 
  p0_.colour AS colour10, 
  p0_.sample AS sample11, 
  p0_.visible AS visible12, 
  p0_.active AS active13, 
  p0_.price AS price14, 
  p0_.priceCD AS priceCD15, 
  p0_.pricePrint AS pricePrint16, 
  p0_.additional_files AS additional_files17, 
  p0_.pinned AS pinned18, 
  p0_.imageGallery AS imageGallery19 
FROM 
  Product p0_ 
  LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id 
  LEFT JOIN Category c1_ ON c1_.id = p2_.category_id 
WHERE 
  p0_.visible = 1 
  AND p0_.active = 1 
ORDER BY 
  p0_.pinned DESC, 
  p0_.price DESC, 
  p0_.name ASC

SELECT p0_.id AS id0, p0_.name AS name1, p0_.cost AS cost2, p0_.description AS description3, p0_.leaderboard AS leaderboard4, p0_.amazon AS amazon5, p0_.nameCanonical AS nameCanonical6, p0_.downloadFile AS downloadFile7, p0_.downloadLimit AS downloadLimit8, p0_.image AS image9, p0_.colour AS colour10, p0_.sample AS sample11, p0_.visible AS visible12, p0_.active AS active13, p0_.price AS price14, p0_.priceCD AS priceCD15, p0_.pricePrint AS pricePrint16, p0_.additional_files AS additional_files17, p0_.pinned AS pinned18, p0_.imageGallery AS imageGallery19 FROM Product p0_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN Category c1_ ON c1_.id = p2_.category_id WHERE p0_.visible = 1 AND p0_.active = 1 ORDER BY p0_.pinned DESC, p0_.price DESC, p0_.name ASC;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 2098;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 2098;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 378;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 378;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 381;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 381;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 1867;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 1867;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 387;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 387;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 395;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 395;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 402;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 402;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 408;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 408;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 1864;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 1864;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 1868;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 1868;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 419;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 419;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 416;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 416;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 426;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 426;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 427;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 427;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 1865;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 1865;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.tab AS tab4 FROM Tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = 431;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.description AS description3, 
  t0.leaderboard AS leaderboard4, 
  t0.amazon AS amazon5, 
  t0.nameCanonical AS nameCanonical6, 
  t0.position AS position7, 
  t0.bgColour AS bgColour8, 
  t0.downloadFile AS downloadFile9, 
  t0.deleted AS deleted10, 
  t0.ds_visibility AS ds_visibility11, 
  t0.parentCategory AS parentCategory12 
FROM 
  Category t0 
  INNER JOIN product_category ON t0.id = product_category.category_id 
WHERE 
  product_category.product_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.description AS description3, t0.leaderboard AS leaderboard4, t0.amazon AS amazon5, t0.nameCanonical AS nameCanonical6, t0.position AS position7, t0.bgColour AS bgColour8, t0.downloadFile AS downloadFile9, t0.deleted AS deleted10, t0.ds_visibility AS ds_visibility11, t0.parentCategory AS parentCategory12 FROM Category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = 431;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.tab AS tab4 
FROM 
  Tag t0 
  INNER JOIN product_tag ON t0.id = product_tag.tag_id 
WHERE 
  product_tag.product_id = ?