Query: SELECT st.*, stf1.value AS image, stf2.value AS intro, stf3.value AS link FROM site_text st LEFT JOIN site_text_extra_fields stf1 ON (stf1.parent_id = st.id AND stf1.code = "image") LEFT JOIN site_text_extra_fields stf2 ON (stf2.parent_id = st.id AND stf2.code = "intro") LEFT JOIN site_text_extra_fields stf3 ON (stf3.parent_id = st.id AND stf3.code = "link") WHERE st.parent_id = 45 AND st.pos_show = "y" ORDER BY st.sort_order, st.date DESC LIMIT 0, 3
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