<font color="#000000"><b>1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10, 5' at line 32<br><br>SELECT a.*, 
                (SELECT 
                    min(aptp.price) FROM appartmentPriceTables as apt 
                LEFT JOIN 
                    appartmentPriceTablePrices as aptp 
                ON 
                    apt.tableId = aptp.tableId
                WHERE 
                    apt.appartmentId=a.appartmentId
               ) as price,
               (SELECT 
                    fileName 
                FROM 
                    appartmentImages 
                WHERE 
                    appartmentId=a.appartmentId 
                ORDER BY 
                    priority 
                LIMIT 1) as image
            FROM 
                appartments as a 
            WHERE 
                a.recommend = '1'
            AND
                a.publish = '1'
            ORDER BY
             (SELECT min(aptp.price) 
                              FROM appartmentPriceTables as apt 
                              LEFT JOIN appartmentPriceTablePrices as aptp 
                              ON apt.tableId = aptp.tableId
                              WHERE apt.appartmentId=a.appartmentId
                              ) ASC LIMIT -10, 5 <br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>