| show per page: 20 | style: detailed |
| Displaying 1 to 20 (of 22 products) |
Result Pages: 1 |
1054 - Unknown column 'pd.products_price' in 'order clause'
select /* index.php 22 */ p.products_status, p.products_image, pd.products_name, pd.products_description_short, m.manufacturers_name, m.multi_author_ids, m.all_author_ids, p.products_date_added, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p2c.categories_id, count(distinct pa.options_values_id) as arg_count from products p left join products_attributes pa on (p.products_id=pa.products_id) left join products_to_categories p2c on (p.products_id = p2c.products_id), products_description pd, manufacturers m where p.products_status >= '1' and pd.products_id = p.products_id and p.manufacturers_id = m.manufacturers_id and (m.manufacturers_id in (4959,34529,40378,56106,61006,63355,204142)) group by p.products_id order by pd.products_price limit 0, 20
[TEP STOP]
|
