{if segment_3 =="services"} {embed="_includes/pull_static" cat_id="32"} {if:elseif segment_3 =="experience"} {embed="_includes/pull_static" cat_id="33"}

Current Projects

{exp:query sql="SELECT title, url_title, field_id_34 as prj_sector, field_id_33 as prj_loc FROM exp_weblog_titles LEFT JOIN exp_weblog_data ON exp_weblog_titles.entry_id = exp_weblog_data.entry_id WHERE exp_weblog_titles.entry_id IN(129,130,18,114,115,116,123,124,125,126,186,190,192,191,189,188,187,185,184,183,182,181,180,177,176,174,173,165,166,167,168,169,195,196,224,222,218,217,225,226,234,235,237) AND exp_weblog_titles.status = 'open' AND field_id_34 LIKE '%Project%' Order BY prj_prj_sector asc LIMIT 1"} {if no_results}

There are no current projects to show

{/if} {/exp:query} MySQL ERROR:

Error Number: 1054

Description: Unknown column 'prj_prj_sector' in 'order clause'

Query: SELECT title, url_title, field_id_34 as prj_sector, field_id_33 as prj_loc FROM exp_weblog_titles LEFT JOIN exp_weblog_data ON exp_weblog_titles.entry_id = exp_weblog_data.entry_id WHERE exp_weblog_titles.entry_id IN(129,130,18,114,115,116,123,124,125,126,186,190,192,191,189,188,187,185,184,183,182,181,180,177,176,174,173,165,166,167,168,169,195,196,224,222,218,217,225,226,234,235,237) AND exp_weblog_titles.status = 'open' AND field_id_34 LIKE '%Project%' Order BY prj_prj_sector asc LIMIT 100

{if segment_4 =="" AND segment_5 =="" OR segment_4 =="title" AND segment_5 =="asc"}Title {if:elseif segment_4 !="title" OR segment_4 =="title" AND segment_5 =="desc"}Title {/if}	{if segment_4 !="prj_loc" OR segment_4 =="prj_loc" AND segment_5 =="desc"}Location{if:else}Location{/if}	{if segment_4 !="prj_prj_sector" OR segment_4 =="prj_prj_sector" AND segment_5 =="desc"}Division{if:else}Division{/if}

Corderoy

Current Projects