Query: SELECT *, (SELECT shop_properties_items_table.shop_properties_items_value 
            FROM shop_properties_items_table
            WHERE shop_properties_items_table.shop_list_of_properties_id = 45
            AND shop_properties_items_table.shop_items_catalog_item_id = shop_items_catalog_table.shop_items_catalog_item_id
            LIMIT 0,1) as url
            FROM shop_items_catalog_table 
            WHERE shop_items_catalog_table.shop_groups_id IN (  )
            AND shop_items_catalog_table.shop_items_catalog_is_active = 1  ORDER BY shop_items_catalog_table.shop_items_catalog_price
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 ')
            AND shop_items_catalog_table.shop_items_catalog_is_active = 1  ORD' at line 7