plant_search.sql

SELECT [Plant_ID] AS [id], [Plant_Active] AS [active], [Plant_Changed] AS [updatedAt], 
[Plant_Created] AS [createdAt], [Plant_Changer] AS [updatedBy], [Plant_No] AS [no], [Plant_Name] AS [name], 
[Plant_Moo] AS [moo], [Plant_District] AS [district], [Plant_Province] AS [province], 
[Plant_SubDistrict] AS [subdistrict], [Plant_Latitude] AS [lat], [Plant_Longitude] AS [long], 
[Plant_AreaRai] AS [areaAsRai], [Plant_AreaShape] AS [areaFromShape], [Quota_ID] AS [quotaId], 
[Plant_CreateBy] AS [createdBy], [Plant_GeoLocation] AS [geoLocation], CONVERT(varchar(max),
[Plant_GeoLocation]) AS [geoLocation] FROM [tb_opr_Plant] AS [Plant] 
WHERE [Plant].[Plant_Active] = 1 ORDER BY [Plant].[Plant_ID] OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY;