|
|
|
 |
|
|
|
|
1109 - Unknown table 'p.p' in order clause
select p.products_image, p.products_model, pd.products_name, m.manufacturers_name, p.products_id , p.manufacturers_id, p.products_price, 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
, pdt.actress_names, pd.products_description
from products_description pd
, products p
left join manufacturers m on p.manufacturers_id = m.manufacturers_id
left join specials s on p.products_id = s.products_id
left join products_details pdt on p.products_id = pdt.products_id
where p.products_status = '1'
and p.products_id = pd.products_id
and pd.language_id = '4'
and pdt.language_id = '4' and pdt.fetishism <> 'another-hole' and pdt.mosaic = '無修正' order by p.p.products_id
[TEP STOP]
| | |
