「参照方法」とは、*.php での SELECT といった観点でしょうか?

FROM ((dtb_products t1 RIGHT JOIN (SELECT dtb_products_class.product_id AS product_id_sub, min(dtb_products_class.price01) AS price01_min,
max(dtb_products_class.price01) AS price01_max, min(dtb_products_class.price02) AS price02_min, max(dtb_products_class.price02) AS price02_max, min(dtb_products_class.stock) AS stock_min, max(dtb_products_class.stock) AS stock_max, min(dtb_products_class.stock_unlimited) AS stock_unlimited_min, max(dtb_products_class.stock_unlimited) AS stock_unlimited_max FROM dtb_products_class GROUP BY dtb_products_class.product_id) t2 ON ((t1.product_id = t2.product_id_sub))) t3 LEFT JOIN (SELECT dtb_category.rank AS category_rank, dtb_category.category_id AS sub_category_id FROM dtb_category) t4 ON ((t3.category_id = t4.sub_category_id)));

SELECT DISTINCT product_id FROM vw_products_allclass AS allcls WHERE del_flg = 0 AND status = 1
DB Error: no such field

SELECT DISTINCT product_id FROM vw_products_allclass AS allcls WHERE del_flg = 0 AND status = 1 [DB Error: no such field]

SELECT DISTINCT product_id FROM vw_products_allclass AS allcls WHERE del_flg = 0 AND status = 1 AND ( name ILIKE ? OR comment3 ILIKE ?)
DB Error: no such field

SELECT DISTINCT product_id FROM vw_products_allclass AS allcls WHERE del_flg = 0 AND status = 1 AND ( name ILIKE '%TEST%' OR comment3 ILIKE '%TEST%') [DB Error: no such field]