|
| 最新車輛 |
 |
|
 |
1109 - Unknown table 'p' in order clause
select CONCAT('3098_', p.products_id) products_id, pd.products_name, CONCAT('3098/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from 3098_products p left join 3098_manufacturers m on (p.manufacturers_id = m.manufacturers_id), 3098_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('6car_', p.products_id) products_id, pd.products_name, CONCAT('6car/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from 6car_products p left join 6car_manufacturers m on (p.manufacturers_id = m.manufacturers_id), 6car_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('_', p.products_id) products_id, pd.products_name, CONCAT('/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from _products p left join _manufacturers m on (p.manufacturers_id = m.manufacturers_id), _products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('chengchang_', p.products_id) products_id, pd.products_name, CONCAT('chengchang/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from chengchang_products p left join chengchang_manufacturers m on (p.manufacturers_id = m.manufacturers_id), chengchang_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('ckcar_', p.products_id) products_id, pd.products_name, CONCAT('ckcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from ckcar_products p left join ckcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), ckcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('cwhcar_', p.products_id) products_id, pd.products_name, CONCAT('cwhcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from cwhcar_products p left join cwhcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), cwhcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('dvcar_', p.products_id) products_id, pd.products_name, CONCAT('dvcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from dvcar_products p left join dvcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), dvcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('fcar_', p.products_id) products_id, pd.products_name, CONCAT('fcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from fcar_products p left join fcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), fcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('fiveroad2_', p.products_id) products_id, pd.products_name, CONCAT('fiveroad2/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from fiveroad2_products p left join fiveroad2_manufacturers m on (p.manufacturers_id = m.manufacturers_id), fiveroad2_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('flcars_', p.products_id) products_id, pd.products_name, CONCAT('flcars/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from flcars_products p left join flcars_manufacturers m on (p.manufacturers_id = m.manufacturers_id), flcars_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('gocar_', p.products_id) products_id, pd.products_name, CONCAT('gocar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from gocar_products p left join gocar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), gocar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('goodcar_', p.products_id) products_id, pd.products_name, CONCAT('goodcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from goodcar_products p left join goodcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), goodcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('handsomecar_', p.products_id) products_id, pd.products_name, CONCAT('handsomecar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from handsomecar_products p left join handsomecar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), handsomecar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('hmcar_', p.products_id) products_id, pd.products_name, CONCAT('hmcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from hmcar_products p left join hmcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), hmcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('honkuo_', p.products_id) products_id, pd.products_name, CONCAT('honkuo/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from honkuo_products p left join honkuo_manufacturers m on (p.manufacturers_id = m.manufacturers_id), honkuo_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('hscar_', p.products_id) products_id, pd.products_name, CONCAT('hscar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from hscar_products p left join hscar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), hscar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('jscar_', p.products_id) products_id, pd.products_name, CONCAT('jscar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from jscar_products p left join jscar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), jscar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('kdcar_', p.products_id) products_id, pd.products_name, CONCAT('kdcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from kdcar_products p left join kdcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), kdcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('kjcar_', p.products_id) products_id, pd.products_name, CONCAT('kjcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from kjcar_products p left join kjcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), kjcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('lccar_', p.products_id) products_id, pd.products_name, CONCAT('lccar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from lccar_products p left join lccar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), lccar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('lecar_', p.products_id) products_id, pd.products_name, CONCAT('lecar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from lecar_products p left join lecar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), lecar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('longcar_', p.products_id) products_id, pd.products_name, CONCAT('longcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from longcar_products p left join longcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), longcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('mlcar_', p.products_id) products_id, pd.products_name, CONCAT('mlcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from mlcar_products p left join mlcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), mlcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('rtcar_', p.products_id) products_id, pd.products_name, CONCAT('rtcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from rtcar_products p left join rtcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), rtcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('samplecar_', p.products_id) products_id, pd.products_name, CONCAT('samplecar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from samplecar_products p left join samplecar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), samplecar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('sanlicar_', p.products_id) products_id, pd.products_name, CONCAT('sanlicar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from sanlicar_products p left join sanlicar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), sanlicar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('sccar_', p.products_id) products_id, pd.products_name, CONCAT('sccar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from sccar_products p left join sccar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), sccar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('shui_', p.products_id) products_id, pd.products_name, CONCAT('shui/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from shui_products p left join shui_manufacturers m on (p.manufacturers_id = m.manufacturers_id), shui_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('socar_', p.products_id) products_id, pd.products_name, CONCAT('socar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from socar_products p left join socar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), socar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('sucar_', p.products_id) products_id, pd.products_name, CONCAT('sucar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from sucar_products p left join sucar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), sucar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('supercar_', p.products_id) products_id, pd.products_name, CONCAT('supercar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from supercar_products p left join supercar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), supercar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('swcar_', p.products_id) products_id, pd.products_name, CONCAT('swcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from swcar_products p left join swcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), swcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('tdacar_', p.products_id) products_id, pd.products_name, CONCAT('tdacar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from tdacar_products p left join tdacar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), tdacar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('togh_', p.products_id) products_id, pd.products_name, CONCAT('togh/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from togh_products p left join togh_manufacturers m on (p.manufacturers_id = m.manufacturers_id), togh_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('ufcar_', p.products_id) products_id, pd.products_name, CONCAT('ufcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from ufcar_products p left join ufcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), ufcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('uscar_', p.products_id) products_id, pd.products_name, CONCAT('uscar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from uscar_products p left join uscar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), uscar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('usedcar_', p.products_id) products_id, pd.products_name, CONCAT('usedcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from usedcar_products p left join usedcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), usedcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('usedmotors_', p.products_id) products_id, pd.products_name, CONCAT('usedmotors/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from usedmotors_products p left join usedmotors_manufacturers m on (p.manufacturers_id = m.manufacturers_id), usedmotors_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('utcars_', p.products_id) products_id, pd.products_name, CONCAT('utcars/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from utcars_products p left join utcars_manufacturers m on (p.manufacturers_id = m.manufacturers_id), utcars_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('v2hscar_', p.products_id) products_id, pd.products_name, CONCAT('v2hscar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from v2hscar_products p left join v2hscar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), v2hscar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('v2sccar_', p.products_id) products_id, pd.products_name, CONCAT('v2sccar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from v2sccar_products p left join v2sccar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), v2sccar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('whcar_', p.products_id) products_id, pd.products_name, CONCAT('whcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from whcar_products p left join whcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), whcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('wormar_', p.products_id) products_id, pd.products_name, CONCAT('wormar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from wormar_products p left join wormar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), wormar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('yili1_', p.products_id) products_id, pd.products_name, CONCAT('yili1/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from yili1_products p left join yili1_manufacturers m on (p.manufacturers_id = m.manufacturers_id), yili1_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('ylcar_', p.products_id) products_id, pd.products_name, CONCAT('ylcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from ylcar_products p left join ylcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), ylcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('yuanlong_', p.products_id) products_id, pd.products_name, CONCAT('yuanlong/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from yuanlong_products p left join yuanlong_manufacturers m on (p.manufacturers_id = m.manufacturers_id), yuanlong_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('yuecar_', p.products_id) products_id, pd.products_name, CONCAT('yuecar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from yuecar_products p left join yuecar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), yuecar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('yungcar_', p.products_id) products_id, pd.products_name, CONCAT('yungcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from yungcar_products p left join yungcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), yungcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('zcar_', p.products_id) products_id, pd.products_name, CONCAT('zcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from zcar_products p left join zcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), zcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('zdcar_', p.products_id) products_id, pd.products_name, CONCAT('zdcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from zdcar_products p left join zdcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), zdcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' UNION select CONCAT('zlcar_', p.products_id) products_id, pd.products_name, CONCAT('zlcar/images/', p.products_image) products_image, p.products_price, p.products_tax_class_id, p.products_last_modified, p.products_date_added, m.manufacturers_name from zlcar_products p left join zlcar_manufacturers m on (p.manufacturers_id = m.manufacturers_id), zlcar_products_description pd where p.products_status = '1' and p.products_image is not null and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_price desc, p.products_last_modified desc, pd.products_name limit 0, 10
[TEP STOP]
| |
