SQL ERROR: Not unique table/alias: 'colors'
SQL: SELECT ROUND(PRICE *1.00 * (1 + IFNULL(MARKUP, 0)/100),2) AS PRICE2 FROM shop_item as si INNER JOIN shop_item_lang as sil USING(SID) INNER JOIN shop_item_component as sic USING(SID) INNER JOIN shop_item_category as category USING(SID) INNER JOIN shop_item_category as main_category ON si.SID = main_category.SID AND main_category.CMAIN = 1 INNER JOIN shop_categories as sc ON sc.CID = main_category.CID INNER JOIN shop_categories_lang as scl ON sc.CID = scl.CID AND scl.LANG='lv' LEFT JOIN shop_categories as sc2 ON sc2.CID = sc.PARENT LEFT JOIN shop_categories_lang as scl2 ON sc2.CID = scl2.CID AND scl2.LANG='lv' LEFT JOIN manufacturer ON manufacturer.MID = si.MID AND manufacturer.ST = 1 LEFT JOIN manufacturer_category_stock ON manufacturer_category_stock.MID = si.MID AND manufacturer_category_stock.CID = main_category.CID LEFT JOIN shop_item_stock ON shop_item_stock.SID = si.SID LEFT JOIN markups ON markups.MID = si.MID AND markups.CID = main_category.CID LEFT JOIN colors as colors ON colors.CLID = sic.CLID LEFT JOIN colors_lang as colors_lang ON colors.CLID = colors_lang.CLID AND colors_lang.LANG ='lv' LEFT JOIN colors ON colors.CLID = sic.CLID LEFT JOIN colors_lang ON colors.CLID = colors_lang.CLID AND colors_lang.COLINK IN("victory_rokturi-titans_f9") AND colors_lang.LANG = 'lv' WHERE sil.LANG='lv' AND si.ST = 1 AND sic.ST = 1 AND sc.ST = 1 AND (sc2.ST = 1 OR sc2.ST IS NULL) AND sic.HIDE IN(0,2) AND (colors_lang.LANG IS NOT NULL) AND category.CID = 27 ORDER BY PRICE2
at /home2/divizion/public_html/nplogi.lv/shop/inc/_list_products.php line 908

SQL ERROR: Not unique table/alias: 'colors'
SQL: SELECT ROUND(PRICE *1.00 * (1 + IFNULL(MARKUP, 0)/100),2) AS PRICE2 FROM shop_item as si INNER JOIN shop_item_lang as sil USING(SID) INNER JOIN shop_item_component as sic USING(SID) INNER JOIN shop_item_category as category USING(SID) INNER JOIN shop_item_category as main_category ON si.SID = main_category.SID AND main_category.CMAIN = 1 INNER JOIN shop_categories as sc ON sc.CID = main_category.CID INNER JOIN shop_categories_lang as scl ON sc.CID = scl.CID AND scl.LANG='lv' LEFT JOIN shop_categories as sc2 ON sc2.CID = sc.PARENT LEFT JOIN shop_categories_lang as scl2 ON sc2.CID = scl2.CID AND scl2.LANG='lv' LEFT JOIN manufacturer ON manufacturer.MID = si.MID AND manufacturer.ST = 1 LEFT JOIN manufacturer_category_stock ON manufacturer_category_stock.MID = si.MID AND manufacturer_category_stock.CID = main_category.CID LEFT JOIN shop_item_stock ON shop_item_stock.SID = si.SID LEFT JOIN markups ON markups.MID = si.MID AND markups.CID = main_category.CID LEFT JOIN colors as colors ON colors.CLID = sic.CLID LEFT JOIN colors_lang as colors_lang ON colors.CLID = colors_lang.CLID AND colors_lang.LANG ='lv' LEFT JOIN colors ON colors.CLID = sic.CLID LEFT JOIN colors_lang ON colors.CLID = colors_lang.CLID AND colors_lang.COLINK IN("victory_rokturi-titans_f9") AND colors_lang.LANG = 'lv' WHERE sil.LANG='lv' AND si.ST = 1 AND sic.ST = 1 AND sc.ST = 1 AND (sc2.ST = 1 OR sc2.ST IS NULL) AND sic.HIDE IN(0,2) AND (colors_lang.LANG IS NOT NULL) AND category.CID = 27 ORDER BY PRICE2 DESC
at /home2/divizion/public_html/nplogi.lv/shop/inc/_list_products.php line 927

SQL ERROR: Not unique table/alias: 'colors'
SQL: SELECT COUNT(DISTINCT si.SID) as QTY FROM shop_item as si INNER JOIN shop_item_lang as sil USING(SID) INNER JOIN shop_item_component as sic USING(SID) INNER JOIN shop_item_category as category USING(SID) INNER JOIN shop_item_category as main_category ON si.SID = main_category.SID AND main_category.CMAIN = 1 INNER JOIN shop_categories as sc ON sc.CID = main_category.CID INNER JOIN shop_categories_lang as scl ON sc.CID = scl.CID AND scl.LANG='lv' LEFT JOIN shop_categories as sc2 ON sc2.CID = sc.PARENT LEFT JOIN shop_categories_lang as scl2 ON sc2.CID = scl2.CID AND scl2.LANG='lv' LEFT JOIN manufacturer ON manufacturer.MID = si.MID AND manufacturer.ST = 1 LEFT JOIN markups ON markups.MID = si.MID AND markups.CID = main_category.CID LEFT JOIN colors as colors ON colors.CLID = sic.CLID LEFT JOIN colors_lang as colors_lang ON colors.CLID = colors_lang.CLID AND colors_lang.LANG ='lv' LEFT JOIN colors ON colors.CLID = sic.CLID LEFT JOIN colors_lang ON colors.CLID = colors_lang.CLID AND colors_lang.COLINK IN("victory_rokturi-titans_f9") AND colors_lang.LANG = 'lv' WHERE sil.LANG='lv' AND si.ST = 1 AND sic.ST = 1 AND sc.ST = 1 AND (sc2.ST = 1 OR sc2.ST IS NULL) AND sic.HIDE IN(0,2) AND (colors_lang.LANG IS NOT NULL) AND category.CID = 27
at /home2/divizion/public_html/nplogi.lv/shop/inc/_list_products.php line 954

SQL ERROR: Not unique table/alias: 'colors'
SQL: SELECT DISTINCT HIDE,colors_lang.COLINK, PLINK, si.SID, sic.COMID,ROUND(PRICE *1.00 * (1 + IFNULL(MARKUP, 0)/100),2) AS PRICE,TITLE,if(sic.FILE<>'',sic.FILE,si.FILE) AS FILE, if(sic.FILE2<>'',sic.FILE2,si.FILE2) AS FILE2, main_category.CID, sil.DESCRIPTION, scl2.CLINK AS CLINK_PARENT_REQUEST, scl.CLINK AS CLINK_REQUEST, scl.ADD_TXT_URL, scl.ADD_TXT, ROUND(OPRICE *1.00 * (1 + IFNULL(MARKUP, 0)/100),2) AS POPRICE, IFNULL(shop_item_stock.ISTOCK , manufacturer_category_stock.ISTOCK) AS ISTOCK, IFNULL(shop_item_stock.ISTOCK2 , manufacturer_category_stock.ISTOCK2) AS ISTOCK2, IFNULL(shop_item_stock.RECOMMEND , manufacturer_category_stock.RECOMMEND) AS RECOMMEND,si.DZ, NEW, TOP, MINDATE, MINDATENUM,colors_lang.COTITLE FROM shop_item as si INNER JOIN shop_item_lang as sil USING(SID) INNER JOIN shop_item_component as sic USING(SID) INNER JOIN shop_item_category as category USING(SID) INNER JOIN shop_item_category as main_category ON si.SID = main_category.SID AND main_category.CMAIN = 1 INNER JOIN shop_categories as sc ON sc.CID = main_category.CID INNER JOIN shop_categories_lang as scl ON sc.CID = scl.CID AND scl.LANG='lv' LEFT JOIN shop_categories as sc2 ON sc2.CID = sc.PARENT LEFT JOIN shop_categories_lang as scl2 ON sc2.CID = scl2.CID AND scl2.LANG='lv' LEFT JOIN manufacturer ON manufacturer.MID = si.MID AND manufacturer.ST = 1 LEFT JOIN manufacturer_category_stock ON manufacturer_category_stock.MID = si.MID AND manufacturer_category_stock.CID = main_category.CID LEFT JOIN shop_item_stock ON shop_item_stock.SID = si.SID LEFT JOIN markups ON markups.MID = si.MID AND markups.CID = main_category.CID LEFT JOIN colors as colors ON colors.CLID = sic.CLID LEFT JOIN colors_lang as colors_lang ON colors.CLID = colors_lang.CLID AND colors_lang.LANG ='lv' LEFT JOIN colors ON colors.CLID = sic.CLID LEFT JOIN colors_lang ON colors.CLID = colors_lang.CLID AND colors_lang.COLINK IN("victory_rokturi-titans_f9") AND colors_lang.LANG = 'lv' WHERE sil.LANG='lv' AND si.ST = 1 AND sic.ST = 1 AND sc.ST = 1 AND (sc2.ST = 1 OR sc2.ST IS NULL) AND sic.HIDE IN(0,2) AND (colors_lang.LANG IS NOT NULL) AND category.CID = 27 ORDER BY POPRICE/PRICE DESC,si.DZ DESC, sic.DZ DESC LIMIT 0,100
at /home2/divizion/public_html/nplogi.lv/shop/inc/_list_products.php line 977