Mark LewisMagician, Svengali pitchman, and cold reader.
Mark Lewis products
1054 - Unknown column 'pd.products_price' in 'order clause'
|Displaying 1 to 7 (of 7 products)
||Result Pages: 1
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 (70610)) group by p.products_id order by pd.products_price limit 0, 20