Dig Deeper

Here are in-depth how-to's on topics that SPIN farmers want to - or should - know more about. 

To preview any of the learning guides, click on Preview to view a Table of Contents.

Order these pdf’s for immediate download.

An unexpected error occurred.

mysql error: [3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'spinfarm_c5.pr.prName' which is not in SELECT list; this is incompatible with DISTINCT] in EXECUTE("SELECT distinct pr.productID, (select max(prspDisplayOrder) from CoreCommerceProductSetProducts where productID = pr.productID and prsID in (5)) as prspDisplayOrder, if(prSpecialPrice > 0 and prSpecialPrice <> prPrice, prSpecialPrice, prPrice) as prCurrentPrice from CoreCommerceProducts pr left join Pages on Pages.cID = pr.cID left join CoreCommerceProductSearchIndexAttributes on (pr.productID = CoreCommerceProductSearchIndexAttributes.productID) left join CoreCommerceProductSetProducts prsl on prsl.productID = pr.productID where 1=1 and pr.prStatus = '1' and prsl.productID IN (SELECT DISTINCT productID FROM CoreCommerceProductSetProducts WHERE prsID = '5') order by prName asc limit 0,10 ")

< Back to Home