SELECT p1.products_id as pID, p1.products_quantity, p1.products_model, p1.products_image, p1.products_image_med, p1.products_image_lrg, p1.products_image_sm_1, p1.products_image_xl_1, p1.products_image_sm_2, p1.products_image_xl_2, p1.products_image_sm_3, p1.products_image_xl_3, p1.products_image_sm_4, p1.products_image_xl_4, p1.products_image_sm_5, p1.products_image_xl_5, p1.products_image_sm_6, p1.products_image_xl_6, p1.products_price, p1.products_cost, p1.products_msrp, p1.products_date_added, p1.products_last_modified, p1.products_date_available, p1.products_weight, p1.products_status, p1.products_tax_class_id, p1.manufacturers_id, p1.products_ordered, p1.products_parent_id, p1.products_price1, p1.products_price2, p1.products_price3, p1.products_price4, p1.products_price5, p1.products_price6, p1.products_price7, p1.products_price8, p1.products_price9, p1.products_price10, p1.products_price11, p1.products_price1_qty, p1.products_price2_qty, p1.products_price3_qty, p1.products_price4_qty, p1.products_price5_qty, p1.products_price6_qty, p1.products_price7_qty, p1.products_price8_qty, p1.products_price9_qty, p1.products_price10_qty, p1.products_price11_qty, p1.products_qty_blocks, p1.products_group_access, p1.products_nav_access, p1.sort_order, p1.vendors_id, p1.vendors_product_price, p1.vendors_prod_id, p1.vendors_prod_comments, p1.products_qty_days, p1.products_qty_years, p1.parent_model, p1.products_quantity_order_min, p1.products_strict_inventory, p1.products_text_for_madetoorder, p1.products_text_for_outofstock, p1.products_text_for_upc, p2.*, p3.*, p4.*, p5.*, (SELECT GROUP_CONCAT(categories_id) FROM products_to_categories WHERE products_id = p1.products_id) as ProductCategories FROM products as p1
JOIN products_groups as p2
ON p1.products_id = p2.products_id
JOIN products_description as p3
ON p1.products_id = p3.products_id
LEFT JOIN products_attributes as p4
ON p1.products_id = p4.products_id
LEFT JOIN products_options_values as p5
ON p4.options_values_id = p5.products_options_values_id
ORDER BY p1.products_parent_id ASC