SELECT *
FROM (`content`)
LEFT JOIN `content_category` ON `content_category`.`content_category_id` = `content`.`content_category_id`
WHERE `content`.`content_type_id` = '1'
AND `content_price` > '0'
AND `content_in_shop` = '1'
LIMIT 730, 10
JagdRevier vadászbolt