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 
  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 
WHERE 
  t0.nameCanonical = ? 
LIMIT 
  1

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 WHERE t0.nameCanonical = 'analysis-of-performance-and-evaluation' LIMIT 1;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.cost AS cost3, 
  t0.description AS description4, 
  t0.leaderboard AS leaderboard5, 
  t0.amazon AS amazon6, 
  t0.nameCanonical AS nameCanonical7, 
  t0.downloadFile AS downloadFile8, 
  t0.downloadLimit AS downloadLimit9, 
  t0.image AS image10, 
  t0.colour AS colour11, 
  t0.sample AS sample12, 
  t0.visible AS visible13, 
  t0.active AS active14, 
  t0.price AS price15, 
  t0.priceCD AS priceCD16, 
  t0.pricePrint AS pricePrint17, 
  t0.additional_files AS additional_files18, 
  t0.pinned AS pinned19, 
  t0.imageGallery AS imageGallery20 
FROM 
  Product t0 
WHERE 
  t0.nameCanonical = ? 
  AND t0.active = ? 
LIMIT 
  1

SELECT t0.id AS id1, t0.name AS name2, t0.cost AS cost3, t0.description AS description4, t0.leaderboard AS leaderboard5, t0.amazon AS amazon6, t0.nameCanonical AS nameCanonical7, t0.downloadFile AS downloadFile8, t0.downloadLimit AS downloadLimit9, t0.image AS image10, t0.colour AS colour11, t0.sample AS sample12, t0.visible AS visible13, t0.active AS active14, t0.price AS price15, t0.priceCD AS priceCD16, t0.pricePrint AS pricePrint17, t0.additional_files AS additional_files18, t0.pinned AS pinned19, t0.imageGallery AS imageGallery20 FROM Product t0 WHERE t0.nameCanonical = 'rugby-league---evaluation-sheets---passing' AND t0.active = 1 LIMIT 1;

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 = 2057;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.cost AS cost3, 
  t0.description AS description4, 
  t0.leaderboard AS leaderboard5, 
  t0.amazon AS amazon6, 
  t0.nameCanonical AS nameCanonical7, 
  t0.downloadFile AS downloadFile8, 
  t0.downloadLimit AS downloadLimit9, 
  t0.image AS image10, 
  t0.colour AS colour11, 
  t0.sample AS sample12, 
  t0.visible AS visible13, 
  t0.active AS active14, 
  t0.price AS price15, 
  t0.priceCD AS priceCD16, 
  t0.pricePrint AS pricePrint17, 
  t0.additional_files AS additional_files18, 
  t0.pinned AS pinned19, 
  t0.imageGallery AS imageGallery20 
FROM 
  Product t0 
  INNER JOIN product_category ON t0.id = product_category.product_id 
WHERE 
  product_category.category_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.cost AS cost3, t0.description AS description4, t0.leaderboard AS leaderboard5, t0.amazon AS amazon6, t0.nameCanonical AS nameCanonical7, t0.downloadFile AS downloadFile8, t0.downloadLimit AS downloadLimit9, t0.image AS image10, t0.colour AS colour11, t0.sample AS sample12, t0.visible AS visible13, t0.active AS active14, t0.price AS price15, t0.priceCD AS priceCD16, t0.pricePrint AS pricePrint17, t0.additional_files AS additional_files18, t0.pinned AS pinned19, t0.imageGallery AS imageGallery20 FROM Product t0 INNER JOIN product_category ON t0.id = product_category.product_id WHERE product_category.category_id = 3;

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 = 2057;

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_tag p2_ ON p0_.id = p2_.product_id 
  LEFT JOIN Tag t1_ ON t1_.id = p2_.tag_id 
WHERE 
  p0_.visible = 1 
  AND p0_.active = 1 
  AND t1_.id IN (?) 
LIMIT 
  12

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_tag p2_ ON p0_.id = p2_.product_id LEFT JOIN Tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.visible = 1 AND p0_.active = 1 AND t1_.id IN (4) LIMIT 12;

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 = 282;

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 = 286;

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 = 288;

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 = 291;

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 = 294;

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 = 296;

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 = 297;

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 = 298;

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 = 300;

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 = 302;

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 = 303;

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 = 304;

SELECT 
  p0_.id AS id0, 
  p0_.name AS name1, 
  p0_.deleted AS deleted2, 
  p0_.active AS active3, 
  p0_.description AS description4, 
  p0_.price AS price5, 
  p0_.slug AS slug6, 
  p0_.createdAt AS createdAt7, 
  p0_.updatedAt AS updatedAt8, 
  p0_.colour AS colour9, 
  p0_.image AS image10, 
  p0_.imageGallery AS imageGallery11 
FROM 
  ProductBundle p0_ 
  LEFT JOIN productbundle_tag p2_ ON p0_.id = p2_.productbundle_id 
  LEFT JOIN Tag t1_ ON t1_.id = p2_.tag_id 
WHERE 
  p0_.deleted = 0 
  AND p0_.active = 1 
  AND t1_.id IN (?) 
LIMIT 
  12

SELECT p0_.id AS id0, p0_.name AS name1, p0_.deleted AS deleted2, p0_.active AS active3, p0_.description AS description4, p0_.price AS price5, p0_.slug AS slug6, p0_.createdAt AS createdAt7, p0_.updatedAt AS updatedAt8, p0_.colour AS colour9, p0_.image AS image10, p0_.imageGallery AS imageGallery11 FROM ProductBundle p0_ LEFT JOIN productbundle_tag p2_ ON p0_.id = p2_.productbundle_id LEFT JOIN Tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.deleted = 0 AND p0_.active = 1 AND t1_.id IN (4) LIMIT 12;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.cost AS cost3, 
  t0.description AS description4, 
  t0.leaderboard AS leaderboard5, 
  t0.amazon AS amazon6, 
  t0.nameCanonical AS nameCanonical7, 
  t0.downloadFile AS downloadFile8, 
  t0.downloadLimit AS downloadLimit9, 
  t0.image AS image10, 
  t0.colour AS colour11, 
  t0.sample AS sample12, 
  t0.visible AS visible13, 
  t0.active AS active14, 
  t0.price AS price15, 
  t0.priceCD AS priceCD16, 
  t0.pricePrint AS pricePrint17, 
  t0.additional_files AS additional_files18, 
  t0.pinned AS pinned19, 
  t0.imageGallery AS imageGallery20 
FROM 
  Product t0 
WHERE 
  t0.active = ? 
  AND t0.visible = ?

SELECT t0.id AS id1, t0.name AS name2, t0.cost AS cost3, t0.description AS description4, t0.leaderboard AS leaderboard5, t0.amazon AS amazon6, t0.nameCanonical AS nameCanonical7, t0.downloadFile AS downloadFile8, t0.downloadLimit AS downloadLimit9, t0.image AS image10, t0.colour AS colour11, t0.sample AS sample12, t0.visible AS visible13, t0.active AS active14, t0.price AS price15, t0.priceCD AS priceCD16, t0.pricePrint AS pricePrint17, t0.additional_files AS additional_files18, t0.pinned AS pinned19, t0.imageGallery AS imageGallery20 FROM Product t0 WHERE t0.active = 1 AND t0.visible = 1;

SELECT 
  s0_.id AS id0, 
  s0_.name AS name1, 
  s0_.db AS db2, 
  s0_.slug AS slug3, 
  s0_.dbHost AS dbHost4, 
  s0_.edClassActive AS edClassActive5, 
  s0_.enquiryToOrder AS enquiryToOrder6, 
  s0_.deleted AS deleted7, 
  s0_.oldID AS oldID8, 
  s0_.importStage AS importStage9, 
  s0_.importCountry AS importCountry10, 
  s0_.excludeReminders AS excludeReminders11, 
  s0_.trialStart AS trialStart12, 
  s0_.markingStart AS markingStart13, 
  s0_.trialEnd AS trialEnd14, 
  s0_.lat AS lat15, 
  s0_.lon AS lon16, 
  s0_.noContactUntil AS noContactUntil17, 
  s0_.letterhead AS letterhead18, 
  s0_.expectedLevels AS expectedLevels19, 
  s0_.dormant AS dormant20, 
  s0_.ofsted AS ofsted21, 
  s0_.useWonde AS useWonde22, 
  s0_.wondeSetupType AS wondeSetupType23, 
  s0_.wondeSetupReady AS wondeSetupReady24, 
  s0_.wondeImportComplete AS wondeImportComplete25, 
  s0_.wondeID AS wondeID26, 
  s0_.wondeSetupComplete AS wondeSetupComplete27, 
  s0_.curriculum_id AS curriculum_id28, 
  s0_.subscription_id AS subscription_id29, 
  s0_.statement_id AS statement_id30 
FROM 
  SchoolLink s0_ 
WHERE 
  s0_.deleted = 0

SELECT s0_.id AS id0, s0_.name AS name1, s0_.db AS db2, s0_.slug AS slug3, s0_.dbHost AS dbHost4, s0_.edClassActive AS edClassActive5, s0_.enquiryToOrder AS enquiryToOrder6, s0_.deleted AS deleted7, s0_.oldID AS oldID8, s0_.importStage AS importStage9, s0_.importCountry AS importCountry10, s0_.excludeReminders AS excludeReminders11, s0_.trialStart AS trialStart12, s0_.markingStart AS markingStart13, s0_.trialEnd AS trialEnd14, s0_.lat AS lat15, s0_.lon AS lon16, s0_.noContactUntil AS noContactUntil17, s0_.letterhead AS letterhead18, s0_.expectedLevels AS expectedLevels19, s0_.dormant AS dormant20, s0_.ofsted AS ofsted21, s0_.useWonde AS useWonde22, s0_.wondeSetupType AS wondeSetupType23, s0_.wondeSetupReady AS wondeSetupReady24, s0_.wondeImportComplete AS wondeImportComplete25, s0_.wondeID AS wondeID26, s0_.wondeSetupComplete AS wondeSetupComplete27, s0_.curriculum_id AS curriculum_id28, s0_.subscription_id AS subscription_id29, s0_.statement_id AS statement_id30 FROM SchoolLink s0_ WHERE s0_.deleted = 0;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.deleted AS deleted3, 
  t0.active AS active4, 
  t0.description AS description5, 
  t0.price AS price6, 
  t0.slug AS slug7, 
  t0.createdAt AS createdAt8, 
  t0.updatedAt AS updatedAt9, 
  t0.colour AS colour10, 
  t0.image AS image11, 
  t0.imageGallery AS imageGallery12 
FROM 
  ProductBundle t0 
WHERE 
  t0.active = ? 
  AND t0.deleted = ? 
LIMIT 
  12

SELECT t0.id AS id1, t0.name AS name2, t0.deleted AS deleted3, t0.active AS active4, t0.description AS description5, t0.price AS price6, t0.slug AS slug7, t0.createdAt AS createdAt8, t0.updatedAt AS updatedAt9, t0.colour AS colour10, t0.image AS image11, t0.imageGallery AS imageGallery12 FROM ProductBundle t0 WHERE t0.active = 1 AND t0.deleted = 0 LIMIT 12;

SELECT 
  t0.id AS id1, 
  t0.name AS name2, 
  t0.cost AS cost3, 
  t0.description AS description4, 
  t0.leaderboard AS leaderboard5, 
  t0.amazon AS amazon6, 
  t0.nameCanonical AS nameCanonical7, 
  t0.downloadFile AS downloadFile8, 
  t0.downloadLimit AS downloadLimit9, 
  t0.image AS image10, 
  t0.colour AS colour11, 
  t0.sample AS sample12, 
  t0.visible AS visible13, 
  t0.active AS active14, 
  t0.price AS price15, 
  t0.priceCD AS priceCD16, 
  t0.pricePrint AS pricePrint17, 
  t0.additional_files AS additional_files18, 
  t0.pinned AS pinned19, 
  t0.imageGallery AS imageGallery20 
FROM 
  Product t0 
  INNER JOIN productbundle_product ON t0.id = productbundle_product.product_id 
WHERE 
  productbundle_product.productbundle_id = ?

SELECT t0.id AS id1, t0.name AS name2, t0.cost AS cost3, t0.description AS description4, t0.leaderboard AS leaderboard5, t0.amazon AS amazon6, t0.nameCanonical AS nameCanonical7, t0.downloadFile AS downloadFile8, t0.downloadLimit AS downloadLimit9, t0.image AS image10, t0.colour AS colour11, t0.sample AS sample12, t0.visible AS visible13, t0.active AS active14, t0.price AS price15, t0.priceCD AS priceCD16, t0.pricePrint AS pricePrint17, t0.additional_files AS additional_files18, t0.pinned AS pinned19, t0.imageGallery AS imageGallery20 FROM Product t0 INNER JOIN productbundle_product ON t0.id = productbundle_product.product_id WHERE productbundle_product.productbundle_id = 1;