We're here to serve you!
M-Th 9am - 5pm EST | Fri 9am - 1pm EST | Sun 11am - 3pm EST
sqlAttributes: select distinct avm.AttributeMappingID,AttributeName,av.AttributeNameId,AttributeValue, type,cssProperty, isnull(avm2.linkedto, 0) isLink, coalesce(spg.GroupName, spg1.GroupName) SubProductGroupName, coalesce(coalesce(spg.isMainGroup,spg1.isMainGroup),0) isMainGroup, av.AttributeValueId, attributeValueName, avm.isDefault, avm.Price, controlType, attributeGroup, Explanation, isnull(avm.linkedTo,0) linkedTo, an.sortOrder, avm.MappingId, avm.MapType, av.sortOrder valueSortOrder, coalesce(om.MappingId, avm.MappingId) OutlineMappingId from AttributeValuesMapping avm inner join AttributeValues av on avm.AttributeValueId = av.AttributeValueId inner join AttributeNames an on an.attributeNameId = av.attributenameid join SubProductGroups spg1 on spg1.productid = 175 and spg1.ismaingroup = 1 left join SubProductGroups spg on avm.MappingId = spg.GroupID and spg.ProductID = 175 left join AttributeValuesMapping avm2 on avm2.linkedto = av.AttributeValueId and avm2.MapType = 1 and avm2.ProductID IN (175,466) left join AttributeValuesMapping avm3 on (avm3.AttributeValueId = avm.linkedto and avm3.isDefault =1 and avm3.ProductID IN(175,466)) left join OutlineMapping om on om.outlinemapid = avm.MappingId and om.MapType = 2 and om.productID = 175 where avm.productid In(175,466) and avm.MapType = 1 /*and coalesce(isMainGroup,0) = 1*/ and (avm3.AttributeValueId is not null or isnull(avm.linkedto,0) = 0) order by an.sortOrder,an.attributeGroup,av.AttributeNameId, av.sortOrder
sqlAttributes: select distinct avm.AttributeMappingID,AttributeName,av.AttributeNameId,AttributeValue, an.type,cssProperty, isnull(avm2.linkedto, 0) isLink, sub.subproductname SubProductGroupName, 0 isMainGroup, av.AttributeValueId, attributeValueName, avm.isDefault, avm.Price, controlType, attributeGroup, Explanation, isnull(avm.linkedTo,0) linkedTo, an.sortOrder, avm.MappingId, avm.MapType, av.sortOrder valueSortOrder, coalesce(om.MappingId, avm.MappingId) OutlineMappingId from AttributeValuesMapping avm inner join AttributeValues av on avm.AttributeValueId = av.AttributeValueId inner join AttributeNames an on an.attributeNameId = av.attributenameid inner join SubProducts sub on sub.SubProductId = avm.MappingId inner join SubProductGroups spg on sub.GroupID = spg.GroupID left join AttributeValuesMapping avm2 on avm2.linkedto = av.AttributeValueId and avm2.ProductID IN (175,466) left join AttributeValuesMapping avm3 on (avm3.AttributeValueId = avm.linkedto and avm3.isDefault =1 and avm3.MapType = 2 and avm3.ProductID IN (175,466)) left join OutlineMapping om on om.outlinemapid = avm.MappingId and om.MapType = 2 and om.productID = 175 where avm.productid IN (175,466) and avm.MapType = 2 and sub.Required = 1 order by coalesce(om.MappingId,avm.MappingId), an.sortOrder,an.attributeGroup,av.AttributeNameId, av.sortOrder

Custom Design SKU: M1834

Production Time: 2-3 weeks 
Need it faster? Contact us at 732.947.3597
I’d like to custom design my invitation. Please contact me to discuss.
Name:
Email:
Phone Number:
Hebrew Keyboard
Choose Options
Missing Information
Please enter your personal details in the highlighted fields. Verify that all wording is accurate.
© 2021 - BP Print Group - All Rights Reserved