Caught exception: SELECT SQL_CALC_FOUND_ROWS *
FROM brand_type
INNER JOIN brand ON brand_type_brand_id = brand_id
INNER JOIN mobile ON mobile_brand_type_id = brand_type_id
LEFT JOIN brand_type_image ON brand_type_image_brandtype_id = brand_type_id
WHERE brand_type_archived=0 AND brand_type_phone_type < 6 and brand_type_price_device >100 AND brand_type_price_device <=200
GROUP BY mobile_brand_type_id
ORDER BY brand_type_totalrating DESC
LIMIT 30
Mobiele telefoons van 100 tot 200 euro gesorteerd op score