|
|
Guts kits, installed PCMs, and spare parts:The Roadrunner 16-Bit Emulator is currently unavailable. |
 |
|
 |
| Displaying 1 to 5 (of 5 products) |
Result Pages: 1 |
1030 - Got error 28 from storage engine
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, pd.products_info, p.products_price, p.products_downloadable, p.products_tax_class_id, IF (s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF (s.status, s.specials_new_products_price, p.products_price) as final_price
from products_description pd
inner join products p
on p.products_id = pd.products_id
inner join products_to_categories p2c
on p2c.products_id = pd.products_id
left outer join manufacturers m
on m.manufacturers_id = p.manufacturers_id
left outer join specials s
on s.products_id = p.products_id
where p.products_status = 1
and p.products_carrot <> 1
and (p.visible_to is null or p.visible_to = ''
)
and pd.language_id = '1'
and p2c.categories_id = '56' order by p2c.rank, pd.products_name asc limit 0, 200
[TEP STOP]
| | |
