SELECT products.id, products.images, products.price, products.price_offer, products.new_flag, products.new_start, products.new_end, products.offer_start, products.offer_end, language_text.title, slug.slug_url AS url, (CASE WHEN (products.price_offer > 0 AND products.price > 0) THEN ((1 - (products.price_offer/products.price))*100) ELSE NULL END) as discount, products_vs_attributes.products_sizes_id, (SELECT COUNT(id) FROM products_vs_attributes WHERE products_vs_attributes.products_id = products.id AND products_vs_attributes.quantity>0) AS count_rows, (SELECT MIN(products_vs_attributes.price) FROM products_vs_attributes WHERE products_vs_attributes.products_id = products.id AND products_vs_attributes.quantity>0) AS min_extra_price, (SELECT MAX(products_vs_attributes.price) FROM products_vs_attributes WHERE products_vs_attributes.products_id = products.id AND products_vs_attributes.quantity>0) AS max_extra_price FROM products INNER JOIN products_vs_products_categories ON products_vs_products_categories.products_id=products.id INNER JOIN products_vs_attributes ON products_vs_attributes.products_id=products.id INNER JOIN language_text ON language_text.type_id=products.id AND language_text.type='products' INNER JOIN slug ON slug.type='products' AND slug.type_id=products.id AND slug.language_id='5' WHERE language_text.language_id = '5' AND products.pub='1' AND products_vs_products_categories.products_categories_id='139' GROUP BY products.id order by products_vs_products_categories.order ASC limit 0,36