Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $t_query = 'SELECT
- pov.products_options_values_id,
- pov.products_options_values_name,
- pov.gm_filename,
- pa.attributes_model,
- pa.options_values_price,
- pa.price_prefix,
- pa.attributes_stock,
- pa.attributes_model,
- pa.products_vpe_id,
- pa.gm_vpe_value
- FROM
- ' . TABLE_PRODUCTS_ATTRIBUTES . ' pa,
- ' . TABLE_PRODUCTS_OPTIONS_VALUES . ' pov
- LEFT JOIN products_vpe pvpe
- ON pa.products_vpe_id = pvpe.products_vpe_id
- WHERE
- pa.products_id = "' . $this->coo_product->data['products_id'] . '"
- AND pa.options_id = "' . $p_row['products_options_id'] . '"
- AND pa.options_values_id = pov.products_options_values_id
- AND pov.language_id = "' . $this->language_id . '"
- ' . $t_attributes_stock_check . '
- ORDER BY
- pa.sortorder';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement