<cfquery name="q.data.product" datasource="#application.settings.datasource.dsn#" username="#application.settings.datasource.dbusername#" password="#application.settings.datasource.dbpassword#">
				SELECT
		            p.id,
		            p.foldername,
		            p.thumb,
					p.tinyimage,
					p.bigimage,
		            p.[NAME] AS productName,
		            p.description,
					p.credits,
		            p.code,
					p.cddetail,
					p.textused,
					p.commercial,
		            p.sdate,
		            p.sales,
					p.weeksales,
					p.removecard,
					p.kit,
		            p.landscape,
		            p.subcat,
		            p.price,
					p.isDesignerSpecial AS specialoffer,
					<!---0 AS retiring,--->
					<!---(CASE WHEN EXISTS (SELECT * FROM designerdetails ddd WHERE ddd.designerid = p.designerid AND (p.code = ddd.special OR p.code = ddd.specialkit)) THEN 1 ELSE 0 END
					) AS specialoffer,--->
					p.topcatid,
					p.hiddenkeywords,
					p.userkeywords,
					p.designerid,
					p.urlstub AS productURLStub,
		            d.[NAME] AS designerName,
					d.destype AS designerType,
					d.urlstub AS designerURLStub,
					dd.pic AS designerPic,
					dd.scterms,
					dd.cfterms,
					dd.drterms,
					dd.knterms,
		            mc.id AS maincatid,
		            mc.[name] AS maincatname,
					mc.urlstub AS maincatURLStub,
		            c.id AS subcatid,
		            c.[name] AS subcatname,
					c.urlstub AS subcatURLStub,
		            p.cardshopid,
		            cs.[name] AS cardshopname,
					cs.urlstub AS cardshopURLStub,
					cs.versecountr AS cardshopversecounter,
					cs.verseurlstub AS verseurlstub,
					csc.[catname] AS cardshopcatname,
					csc.urlstub AS cardshopcatURLStub,
					tc.[name] AS topcatName,
					tc.urlstub AS topcatURLStub,
		            p.parent,
					( ISNULL( COUNT(ll.id), 0 ) ) AS likecount,
					( CASE WHEN LEN(p.multiPacket) > 0 THEN 1 ELSE 0 END ) AS hasDupeParent,
					( CASE WHEN LEN(p.multiPacket) > 0 THEN 1 ELSE 0 END ) AS hasDupeCode,
		            <!---( CASE WHEN EXISTS ( SELECT *
		                                 FROM   product p1
		                                 WHERE  p1.code = p.parent ) THEN 1
		                   ELSE 0
		              END ) AS hasDupeParent,
		            ( CASE WHEN EXISTS ( SELECT *
		                                 FROM   product p1
		                                 WHERE  p1.parent = p.code ) THEN 1
		                   ELSE 0
		              END ) AS hasDupeCode,--->
					 <!--- p.inCardGallery,--->
		            ( CASE WHEN EXISTS ( SELECT *
		                                 FROM   cardgallery cg1
		                                 WHERE  cg1.code = p.code
		                                        AND cg1.quarantine = 0 AND cg1.holding = 0 ) THEN 1
		                   ELSE 0
		              END ) AS inCardGallery,
		              p.multiPacket
			FROM      product p WITH (NOLOCK)
			          INNER JOIN designers d ON p.designerid = d.id
			          INNER JOIN categories c ON p.subcat = c.id
			          INNER JOIN maincategories mc ON c.parent = mc.id
					  INNER JOIN topcats tc ON mc.topcatid = tc.id
					  LEFT OUTER JOIN likes ll ON p.id = ll.likeproductid
					  LEFT OUTER JOIN designerdetails dd ON d.id = dd.designerid
			          LEFT OUTER JOIN cardshop cs ON p.cardshopid = cs.id
					  LEFT OUTER JOIN cardshopcats csc ON cs.topcat = csc.id
			WHERE     <cfif val(arguments.id)>
					  p.id = <cfqueryparam value="#val(arguments.id)#" cfsqltype="cf_sql_integer">
					  <cfelse>
					  p.code = <cfqueryparam value="#arguments.code#" cfsqltype="cf_sql_varchar">
					  </cfif>
					  and p.validationdate IS NOT NULL
					  <!---AND p.holding = 0
			          AND p.quarantine = 0--->
			</cfquery>