SELECT *, 0 AS relevance_score
FROM findplantsdb
LEFT JOIN specialfeaturesdb ON findplantsdb.Name = specialfeaturesdb.sfname
WHERE (findplantsdb.Name LIKE ? OR findplantsdb.Common LIKE ? OR findplantsdb.Type LIKE ? OR findplantsdb.Color LIKE ? OR findplantsdb.Series LIKE ? OR findplantsdb.Light LIKE ? OR findplantsdb.Pltno LIKE ? OR findplantsdb.Lastword LIKE ? OR findplantsdb.Genus LIKE ? OR specialfeaturesdb.sffoliagecolor LIKE ? OR specialfeaturesdb.sfflowercolor LIKE ? OR specialfeaturesdb.sffallcolor LIKE ? OR specialfeaturesdb.sffruitcolor LIKE ? OR specialfeaturesdb.native LIKE ? OR specialfeaturesdb.deerresistant LIKE ? OR specialfeaturesdb.droughttolerant LIKE ? OR specialfeaturesdb.salttolerant LIKE ? OR specialfeaturesdb.driedflower LIKE ? OR specialfeaturesdb.fragrant LIKE ? OR specialfeaturesdb.forwildlife LIKE ? OR specialfeaturesdb.bark LIKE ? OR findplantsdb.Name IN (SELECT name FROM plantsdb WHERE (size LIKE ? OR type LIKE ?) AND (yard > 0 OR heelin > 0 OR field > 0 OR soon > 0))) AND (findplantsdb.Name LIKE ? OR findplantsdb.Common LIKE ? OR findplantsdb.Type LIKE ? OR findplantsdb.Color LIKE ? OR findplantsdb.Series LIKE ? OR findplantsdb.Light LIKE ? OR findplantsdb.Pltno LIKE ? OR findplantsdb.Lastword LIKE ? OR findplantsdb.Genus LIKE ? OR specialfeaturesdb.sffoliagecolor LIKE ? OR specialfeaturesdb.sfflowercolor LIKE ? OR specialfeaturesdb.sffallcolor LIKE ? OR specialfeaturesdb.sffruitcolor LIKE ? OR specialfeaturesdb.native LIKE ? OR specialfeaturesdb.deerresistant LIKE ? OR specialfeaturesdb.droughttolerant LIKE ? OR specialfeaturesdb.salttolerant LIKE ? OR specialfeaturesdb.driedflower LIKE ? OR specialfeaturesdb.fragrant LIKE ? OR specialfeaturesdb.forwildlife LIKE ? OR specialfeaturesdb.bark LIKE ? OR findplantsdb.Name IN (SELECT name FROM plantsdb WHERE (size LIKE ? OR type LIKE ?) AND (yard > 0 OR heelin > 0 OR field > 0 OR soon > 0)))
-- GROUP BY must come before HAVING in SQL syntax
GROUP BY findplantsdb.Name
ORDER BY relevance_score DESC, findplantsdb.Name ASCBound Parameters:Array
(
[0] => %warwick%
[1] => %warwick%
[2] => %warwick%
[3] => %warwick%
[4] => %warwick%
[5] => %warwick%
[6] => %warwick%
[7] => %warwick%
[8] => %warwick%
[9] => %warwick%
[10] => %warwick%
[11] => %warwick%
[12] => %warwick%
[13] => %warwick%
[14] => %warwick%
[15] => %warwick%
[16] => %warwick%
[17] => %warwick%
[18] => %warwick%
[19] => %warwick%
[20] => %warwick%
[21] => %warwick%
[22] => %warwick%
[23] => %comet%
[24] => %comet%
[25] => %comet%
[26] => %comet%
[27] => %comet%
[28] => %comet%
[29] => %comet%
[30] => %comet%
[31] => %comet%
[32] => %comet%
[33] => %comet%
[34] => %comet%
[35] => %comet%
[36] => %comet%
[37] => %comet%
[38] => %comet%
[39] => %comet%
[40] => %comet%
[41] => %comet%
[42] => %comet%
[43] => %comet%
[44] => %comet%
[45] => %comet%
)
Parameter Types: ssssssssssssssssssssssssssssssssssssssssssssssSearch Results for "WARWICK COMET" ✏️ Edit
Found 1 matching plant
Protected Series:
If Acorn Farms has current availability, you will see it listed below.
con = containers - available now
Galena (Ready to Go!) Plants that are above ground and available now.
Additional (More Plants!) Plants are not in Galena, but in a remote location which is easily accessible. Call your rep for info. They will not be in the Shop.
Dig (In-Ground Field) Plants are still in the ground. Please call your sales rep to place a Dig Order. They will not be in the Shop.
Soon (Coming Soon) Plants are not quite ready but coming soon. Call your rep to inquire. They will not be in the Shop.
| IMAGE | AVAILABLE | SIZE | TYPE | GALENA | ADD'L | DIG | SOON |
|
| con 1 | 1 | 0 | 0 | 0 |
★ ON SALE ★
