以下示例是关于Text中包含找到所有已填好选项的产品用法的示例代码,想了解找到所有已填好选项的产品的具体用法?找到所有已填好选项的产品怎么用?找到所有已填好选项的产品使用的例子?那么可以参考以下相关源代码片段来学习它的具体使用方法。
SELECT p.products_id, pd.products_name, po.products_options_name, pov.products_options_values_name FROM products_attributes pa inner join products p on p.products_id = pa.products_id inner join products_description pd on pd.products_id = p.products_id inner join products_options po on po.products_options_id = pa.options_id inner join products_options_values pov on pov.products_options_values_id = pa.options_values_id WHERE pa.options_id = 7 /*and p.products_quantity > 0 and p.products_status = 1*/ and pd.language_id = 1 and po.language_id = 1 and pov.language_id = 1
本文地址:https://www.itbaoku.cn/snippets/785400.html