| Categories: |
|
| |
Include Subcategories |
 |
| Manufacturers: |
|
|
| Price From: |
|
| Price To: |
|
|
| Date From: |
|
| Date To: |
|
1054 - Unknown column 'pr.properties_id' in 'on clause'
select pc.categories_id, pcd.categories_name, pr.properties_id, pr.properties_type, prd.properties_name, pr.additional_info, prd.properties_description, prd.possible_values from properties pr, properties_description prd left join properties_to_properties_categories p2pc on p2pc.properties_id = pr.properties_id left join properties_categories pc on p2pc.categories_id = pc.categories_id left join properties_categories_description pcd on pc.categories_id = pcd.categories_id and pcd.language_id = '1' where pr.properties_id = prd.properties_id and prd.language_id = '1' and INSTR(pr.mode, 'search') and pr.properties_type in (0, 1, 2, 3, 4) order by pc.sort_order, pcd.categories_name, pr.sort_order, prd.properties_name
[TEP STOP]
|