MySQL error: SQLSTATE[HY093]: Invalid parameter number: Columns/Parameters are 1-based
SELECT c . id, l . value as name FROM s_colors c LEFT JOIN s_language l ON l . item_id = c . id AND l . tables = 6 AND l . lang =:lang WHERE 1 AND c . id in(:19720,:19721,:19722,:19723,:19724,:19725,:19726,:19727,:19728,:19729,:197210,:197211,:197212,:197213,:197214,:197215,:197216,:197217,:197218,:197219,:197220,:197221,:197222,:197223,:197224,:197225,:197226,:197227,:197228,:197229,:197230,:197231,:197232,:197233,:197234,:197235,:197236,:197237,:197238,:197239,:197240,:197241,:197242,:197243,:197244,:197245,:197246,:197247,:197248,:197249,:197250,:197251,:197252,:197253,:197254,:197255,:197256,:197257,:197258,:197259,:197260,:197261,:197262,:197263,:197264,:197265,:197266,:197267,:197268,:197269,:197270,:197271,:197272,:197273,:197274,:197275,:197276,:197277,:197278,:197279,:197280,:197281,:197282,:197283,:197284,:197285,:197286,:197287,:197288,:197289,:197290,:197291,:197292,:197293)