|
|
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /var/www/vhosts/iphoneaccessories.ca/httpdocs/includes/functions/database.php on line 47
1370 - execute command denied to user 'iphone-acc'@'%' for routine 'master_db.product_in_stock_quantity'
select pm.name as brand_name,p.products_id,pd.products_name_prefix,pd.products_name,pd.products_viewed, pd.products_description,
p.products_model, p.products_os, p.products_quantity, p.product_thumb_image, p.products_image, color.color_name,pd.products_url,
p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.products_os,
p.manufacturers_id, p.barcode, c.parent_id,
details.products_feature_1, details.products_feature_2,details.products_feature_3,details.products_feature_4,details.products_feature_5,
details.products_feature_6,details.products_comp,master_db.product_in_stock_quantity(12479) as in_stock
from master_db.products p
join master_db.products_description pd on p.products_id = pd.products_id
left join products_to_categories pc on p.products_id = pc.products_id
left join categories c on c.categories_id = pc.categories_id
left join master_db.products_manufacturers pm on pm.id = p.products_manufacturer_id
left outer join master_db.products_details details on details.products_id = p.products_id
left outer join master_db.colors color on color.color_id = pd.products_color
where p.products_id = 12479
and pd.language_id = '1'
[TEP STOP]
|
