Query: st.*, stf0.value AS articul, stf1.value AS size, stf2.value AS sostav, stf3.value AS made, stf4.value AS discount, stf5.value AS type, stf6.value AS cost FROM site_text st LEFT JOIN site_text_extra_fields stf0 ON (stf0.parent_id = st.id AND stf0.code = "articul") LEFT JOIN site_text_extra_fields stf1 ON (stf1.parent_id = st.id AND stf1.code = "size") LEFT JOIN site_text_extra_fields stf2 ON (stf2.parent_id = st.id AND stf2.code = "sostav") LEFT JOIN site_text_extra_fields stf3 ON (stf3.parent_id = st.id AND stf3.code = "made") LEFT JOIN site_text_extra_fields stf4 ON (stf4.parent_id = st.id AND stf4.code = "discount") LEFT JOIN site_text_extra_fields stf5 ON (stf5.parent_id = st.id AND stf5.code = "type") LEFT JOIN site_text_extra_fields stf6 ON (stf6.parent_id = st.id AND stf6.code = "cost") WHERE st.parent_id = 698 AND st.pos_show = "y" LIMIT 0, 1
Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay