SELECT * FROM ( SELECT *,(select market from market where id=price_arrivals.market_id) AS marketname2 ,(select state_code from master_state where state_id=price_arrivals.state_id) AS statecode FROM price_arrivals where price_date >='2021-09-02' and price_date<= '2022-09-02' and market_id='30' and commodity_id= and modal_price>0 and source='' ORDER BY price_date DESC ) Var1 ORDER BY price_dateYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and modal_price>0 and source='' ORDER BY price_date DESC ) Var1 ORDER ...' at line 2