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!=0 OR brand_type_bestoffer!=0 OR brand_type_secondhand!=0) and (brand_type_usps LIKE '%8 inch%' or brand_type_usps LIKE '%7.9 inch%' or brand_type_usps LIKE '%8.1 inch%' or brand_type_usps LIKE '%8.2 inch%' or brand_type_usps LIKE '%8.3 inch%' or brand_type_usps LIKE '%8.4 inch%' or brand_type_usps LIKE '%8.9 inch%') and brand_type_usps not LIKE '%.8 inch%' and brand_type_usps not LIKE '%12.7 inch%'
GROUP BY mobile_brand_type_id
ORDER BY brand_type_totalrating DESC
LIMIT 39
Alle tablets met een 7,9 of 8 inch scherm gesorteerd op score
