sql is SELECT DISTINCT(a.id), PROD.product_catid as product_category_id, PROD.customproduct_id, CUSTPROD.base_product_id as cust_base_product_id, a.*
FROM `ilogo_saveddesign` a
LEFT JOIN ilogo_product AS PROD ON PROD.ID = a.product_id
LEFT JOIN ilogo_customproduct AS CUSTPROD ON CUSTPROD.id = PROD.customproduct_id
LEFT JOIN ilogo_product AS BASEPROD ON BASEPROD.ID = CUSTPROD.base_product_id
LEFT JOIN ilogo_category AS CAT ON CAT.category_id = BASEPROD.product_catid
LEFT JOIN ilogo_createproduct_price AS PRICE ON PRICE.id = CUSTPROD.material
WHERE PROD.customproduct_id > 0 && CUSTPROD.id IS NOT NULL && a.design_ideas = 1 && a.design_category > 0 ORDER BY CAT.display_sorting ASC
LIMIT 2800 , 20
Tailor-Made T-Shirt Designs in Canada with colour combinations and cloth choices
Watch your price decrease with each additional item in your order.
1284 INS-Sahyadri-%F%-crest-Women%s-Polo-Full-Sleeves-With-Buttons T-ShirtiLogo231673WhiteINS Sahyadri %2528F49%2529 crest Women%2527s Polo Full Sleeves With Buttons
Watch your price decrease with each additional item in your order.
1284 INS-Sindhuraj-%S%-emblem-Women%s-Polo-Raglan-Full-Sleeves-With-Buttons T-ShirtiLogo231677WhiteINS Sindhuraj %2528S57%2529 emblem Women%2527s Polo Raglan Full Sleeves With Buttons
Watch your price decrease with each additional item in your order.
1284 INS-Sandhayak-%J-%-emblem-Women%s-Polo-Raglan-Double-Tip-With-Side-Panel T-ShirtiLogo231682WhiteINS Sandhayak %2528J 18%2529 emblem Women%2527s Polo Raglan Double Tip With Side Panel
Watch your price decrease with each additional item in your order.
1284 INS-Satpura-%F%-crest-Women%s-Polo-Raglan-Double-Tip-With-Side-Panel T-ShirtiLogo231683WhiteINS Satpura %2528F48%2529 crest Women%2527s Polo Raglan Double Tip With Side Panel
Watch your price decrease with each additional item in your order.
1284 INS-Tir-emblem-Women%s-Polo-Raglan-Full-Sleeves-With-Buttons T-ShirtiLogo231692WhiteINS Tir emblem Women%2527s Polo Raglan Full Sleeves With Buttons
Watch your price decrease with each additional item in your order.
1284 INS-Tir-emblem-Women%s-Polo-Raglan-Full-Sleeves-With-Buttons T-ShirtiLogo231693WhiteINS Tir emblem Women%2527s Polo Raglan Full Sleeves With Buttons
Watch your price decrease with each additional item in your order.
1284 INS-Sahyadri-%F%-crest-Women%s-Polo-Full-Sleeves-With-Buttons T-ShirtiLogo231694WhiteINS Sahyadri %2528F49%2529 crest Women%2527s Polo Full Sleeves With Buttons
