Query
Template: /consoleAssets/farmTheme/plants/dsp_plantDetail.cfm:37
Execution Time: 6.47 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
select p.friendlyURL as myval
from tb_users_plants p
where p.isactive and p.displayOnWebsite = 1 and isnull(p.deleteDate) and userID = 3829
and p.type = 'Vegetable'
group by p.friendlyURL
order by p.NameLine2, p.nameLine1
myval
1Lycopersicon-esculentum-Vine-Ripened-Tomato
Vine Ripened Tomato - Lycopersicon esculentum from Landscaper Theme Two

Lycopersicon esculentum

Vine Ripened Tomato
per pound - $2.99
  • Summary
  • Additional Details

  • »  Fresh off the vine!
  • »  Great plain and in salads
  • »  Great tasting and good for you

Height
18 - 24 in
Spread
18 - 24 in
Color
Red
Categories
Vegetable
Tags
ContainerEdibleFull SunAverage Water

  • 128 Raleigh St, Holly Springs, NC 27540