Query
Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38
Execution Time: 10.9 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 Three

Lycopersicon esculentum

Vine Ripened Tomato

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

per pound - $2.99
Vine Ripened Tomato Details
Height 18 - 24 in
Spread 18 - 24 in
Color Red
Categories Vegetable

Check back soon for additional information on Vine Ripened Tomato.

Check back soon for more in-depth details on Vine Ripened Tomato.