mariovaldez.net

Perhaps this is in the wrong forum. I installed the version with php-based connection. (0.4.1, build 632).

No products found withing the kategories.
this field is not found within the db. --> products_subimage1

This is the query..

SELECT products.products_id, products.products_quantity, products.products_model, products.products_price, products.products_weight, products.manufacturers_id, products_description.products_name, products.products_status, products_description.products_description, products_description.products_url, products.products_image, specials.specials_new_products_price, products_description.language_id, products.products_tax_class_id, products_description.products_viewed, DATE_FORMAT( products.products_date_available, "%Y-%m-%d %H:%i:%S" ) , DATE_FORMAT( products.products_date_added, "%Y-%m-%d %H:%i:%S" ) , DATE_FORMAT( products.products_last_modified, "%Y-%m-%d %H:%i:%S" ) , products_subimage1, products_subimage2, products_subimage3, products_subimage4, products_subimage5, products_subimage6
FROM (
products, products_description, products_to_categories
)
LEFT JOIN specials ON products.products_id = specials.products_id
WHERE products.products_id = products_description.products_id
AND products_to_categories.products_id = products.products_id
AND products_to_categories.categories_id =51
ORDER BY products_description.products_name
LIMIT 0 , 30