Выборка характеристик с английским языком по умолчанию.
|
1 2 3 4 5 |
SELECT * FROM ps_feature_value_lang, ps_feature_product WHERE <a href="http://vk.com/away.php?to=http%3A%2F%2Fps_feature_value_lang.id&post=-32470023_401" target="_blank">ps_feature_value_lang.id</a>_lang =1 AND <a href="http://vk.com/away.php?to=http%3A%2F%2Fps_feature_value_lang.id&post=-32470023_401" target="_blank">ps_feature_value_lang.id</a>_feature_value = <a href="http://vk.com/away.php?to=http%3A%2F%2Fps_feature_product.id&post=-32470023_401" target="_blank">ps_feature_product.id</a>_feature_value ORDER BY [crayon-661e554b03570871908718 inline="true" ]ps_feature_product |
. id_feature ASC[/crayon] Выборка товаров с характеристиками, по умолчанию язык английский, выборка характеристик только с 16 id
|
1 2 3 4 5 6 |
SELECT * FROM ps_feature_value_lang, ps_feature_product, ps_product WHERE <a href="http://vk.com/away.php?to=http%3A%2F%2Fps_feature_value_lang.id&post=-32470023_401" target="_blank">ps_feature_value_lang.id</a>_lang =1 AND <a href="http://vk.com/away.php?to=http%3A%2F%2Fps_feature_value_lang.id&post=-32470023_401" target="_blank">ps_feature_value_lang.id</a>_feature_value = <a href="http://vk.com/away.php?to=http%3A%2F%2Fps_feature_product.id&post=-32470023_401" target="_blank">ps_feature_product.id</a>_feature_value AND <a href="http://vk.com/away.php?to=http%3A%2F%2Fps_feature_product.id&post=-32470023_401" target="_blank">ps_feature_product.id</a>_feature =16 AND <a href="http://vk.com/away.php?to=http%3A%2F%2Fps_product.id&post=-32470023_401" target="_blank">ps_product.id</a>_product = <a href="http://vk.com/away.php?to=http%3A%2F%2Fps_feature_product.id&post=-32470023_401" target="_blank">ps_feature_product.id</a>_product ORDER BY [crayon-661e554b03579928253330 inline="true" ]ps_feature_product |
. id_feature ASC[/crayon]