規格ページの読み込み（遅延）エラー

EC-CUBE

---

$col = "class_id1, class_id2, name1, name2, rank1, rank2, ";
$col.= "product_class_id, product_id, T1_classcategory_id AS classcategory_id1, T2_classcategory_id AS classcategory_id2, ";
$col.= "product_code, stock, stock_unlimited, sale_limit, price01, price02, status";

$sql = "SELECT $col FROM ";

$sql.= "( ";
$sql.= "SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS T1_classcategory_id, T2.classcategory_id AS T2_classcategory_id, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2 ";
$sql.= "FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ";
$sql.= "WHERE T1.class_id IN (SELECT class_id1 FROM vw_cross_products_class AS crs_prd WHERE product_id = ? GROUP BY class_id1, class_id2) AND T2.class_id IN (SELECT class_id2 FROM vw_cross_products_class AS crs_prd WHERE product_id = ? GROUP BY class_id1, class_id2)";
$sql.= ") AS T1 ";

$sql.= "LEFT JOIN (SELECT * FROM dtb_products_class WHERE product_id = ?) AS T3 ";
$sql.= "ON T1_classcategory_id = T3.classcategory_id1 AND T2_classcategory_id = T3.classcategory_id2 ";
$sql.= "ORDER BY rank1 DESC, rank2 DESC";

---

$col = "class_id1, class_id2, name1, name2, rank1, rank2, ";
$col.= "product_class_id, product_id, T1_classcategory_id AS classcategory_id1, T2_classcategory_id AS classcategory_id2, ";
$col.= "product_code, stock, stock_unlimited, sale_limit, price01, price02, status";

$sql = "SELECT $col FROM ";

$sql.= "( ";
$sql.= "SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS T1_classcategory_id, T2.classcategory_id AS T2_classcategory_id, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2 ";
$sql.= "FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ";
$sql.= "WHERE T1.class_id IN (SELECT TTT1.class_id FROM (dtb_classcategory AS TTT1, dtb_classcategory AS TTT2) LEFT JOIN dtb_products_class AS TT2 ON TTT1.classcategory_id = TT2.classcategory_id1 AND TTT2.classcategory_id = TT2.classcategory_id2 WHERE TT2.product_id = ?)";
$sql.= " AND  T2.class_id IN (SELECT TSS2.class_id FROM (dtb_classcategory AS TSS1, dtb_classcategory AS TSS2) LEFT JOIN dtb_products_class AS TS2 ON TSS1.classcategory_id = TS2.classcategory_id1 AND TSS2.classcategory_id = TS2.classcategory_id2 WHERE TS2.product_id = ?)";
$sql.= ") AS T1 ";

$sql.= "LEFT JOIN (SELECT * FROM dtb_products_class WHERE product_id = ?) AS T3 ";
$sql.= "ON T1_classcategory_id = T3.classcategory_id1 AND T2_classcategory_id = T3.classcategory_id2 ";
$sql.= "ORDER BY rank1 DESC, rank2 DESC";