text:
We are closed to incoming submissions at this time.
Please take a look at the Reading Schedule below to see when we will next be open to new submissions.
Both new and established writers are encouraged to submit. Our guidelines are subject to change. Please review them prior to submitting.
Publication and Reading Schedule
We publish four issues a year—Spring, Summer, Autumn, and Winter.
We accept submissions in March, June, September, and December.
Poems are published online over the course of the season. Once the issue is complete, it is released in its entirety in print and as a free ebook.
During our submission windows, you can submit by using our form or email us at submissions@rustandmoth.com. If you submit via email, make sure the word "Submission" is in the subject line. Please submit only once per open reading window. Any submissions received outside our submission windows will be discarded. Before you submit, we encourage you to familiarize yourself with our previously published issues.
Submit up to three poems in any style. Additional poems will not be considered. Please send all poems in a group using the contact form below or as an email attachment (.pdf files only). Do not paste poems into the body of the email.
Please include a personal bio of no more than fifty words, written in the third person. If you submit by email, please include the bio in the body of the email, not in an attachment.
You may also send links to your Twitter account, Facebook page, and/or website to help fans better find you from your published works.
Simultaneous Submissions
Rust and Moth will happily consider simultaneous submissions, but please notify us immediately by email if your work is accepted elsewhere.
Rust and Moth will consider "remixed," found poetry, and other derivative submissions, but only provided that the poems therein meet the standard of "significant imaginative or intellectual transformation" laid out in the Code of Best Practices in Fair Use for Poetry. Any poems that borrow significantly from the structure, melody, or content of others' published works will not be considered for publication. Please note that, depending upon the severity and transparency of the borrowing, the submitting author risks being banned from further submissions to Rust and Moth. We will evaluate such matters on a case-by-case basis in close cooperation, when possible, with the original author.
We require that all derivative submissions (including "after" poems) be accompanied by links to or copies of the source material for comparison.
Rust and Moth expects writers to have their work finalized upon first submission, and we seldom grant requests for revision.
Rust and Moth uses a standard web publication line length of 45-75 characters. When submitting poetry, please be aware that poems with longer line lengths may need alteration to work in our format. Please reference our published works for examples.
For some helpful tips on how we format poems and artist bios, please see our Style Guide.
Rust and Moth places no hard limits on the number of times an author may submit new work. That said, please submit only once per open reading window. Authors who submit to us more than 4-5 times without an acceptance are asked to revisit our previous issues and consider goodness-of-fit before submitting again.
Publication Rights
Rust and Moth will publish no previously published works, unless we ourselves request them. Individual rights revert to authors upon publication. By submitting your work, you affirm you are the sole author and maintain all rights for your work. We request that any poem republished from Rust and Moth be properly cited. We reserve the right to nominate works published in Rust and Moth for honors such as the Pushcart Prize, Best of the Net, etc. Rust and Moth will inform authors of such nominations via email.
Upon Publication
While we would love to be able to provide financial remuneration and free issues to the artists whose work we publish, unfortunately we don't have the budget to do so at present. However, we do all we can to help you find your audience, including publication in print and on our website, promotion on our social media outlets, and a dedicated page with your bio and web links on our site. In addition, our editors sometimes write reviews of poetry chapbooks. These reviews are free to authors for use in the promotion of their work. Due to time constraints, we typically offer these reviews only to poets whom we have nominated for the Best of the Net or the Pushcart Prize.
What Not to Send
At this time, we publish only poetry. While we personally love fiction, art, photography, essays, and many other forms of expression, we ask that you do not send them as submissions.


HALIFAX, NOVA SCOTIA -- (CNW –July 06, 2011) - Terry Coughlan, President and CEO of GoGold Resources Inc., is pleased to announce further high grade underground samplings within crosscuts at the Breccia Hill Open Pit Target at its San Diego Project in Durango, Mexico.
The Company continues to find additional high grade structures within the Breccia Hill open pit target. To date, the zone mapped by company geologists extends 400 metres in length and is 160 metres wide and has a vertical relief up a hill for approximately 150m. The zone and is open along strike and to depth below the valley floor. Drilling this zone should commence in the next few weeks to confirm the size and grade of this first of many gold and silver targets currently identified at the San Diego Project.
The small hand-dug workings within the Breccia Hill open pit zone provides the company a three dimensional view within the deposit and present impressive gold and silver grades such as sample #SDL-28 which returned 7.84 metres of 13.25 g/t gold equivalent and sample #SDL-26 which returned 5.82 metres of 9.75 g/t gold equivalent and sample #SDL-14 which returned 4.86 metres of 5.93 g/t gold equivalent. All samples are true widths across high grade structures within the hill.
Note: SDL-09 and 10 were low-grade.
Note: Trenches are true width but do not entirely cut the 160m width of the zone.
Sampling has been completed on the surface in trenches and underground through cross cuts within small historic past producing hand-dug mines (reportedly dating back as far as the 1700's). Sampling is on-going and we await additional results from samples recently delivered to the lab.


Jc Toys 20 Inches La Baby by JC Toys Group, Inc.
Product prices and availability are accurate as of 2019-04-18 16:48:47 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.
Coolest Kids Toys are happy to stock the brilliant Jc Toys 20 Inches La Baby.
With so many on offer today, it is great to have a brand you can recognise. The Jc Toys 20 Inches La Baby is certainly that and will be a superb purchase.
For this reduced price, the Jc Toys 20 Inches La Baby comes widely respected and is always a regular choice for lots of people. JC Toys Group, Inc. have included some nice touches and this equals good value.


text:
»Bill Summaries: H 1034 SMALL BUSINESS EMERGENCY LOANS.
Bill H 1034 (2019-2020)
House committee substitute makes the following changes to the 1st edition.
Changes the act's long title. Makes organizational and technical changes throughout.
Combines the small business emergency loan program general provisions and appropriations provisions. Additionally, amends the appropriations provisions to now appropriate $75 million in nonrecurring funds from the Coronavirus Relief Fund to the Office of State Budget and Management (OSBM) to provide funds to Golden LEAF (previously, directed OSBM to make $75 million available for Golden LEAF and appropriated the $75 million from the General Fund to OSBM for the 2019-20 fiscal year). Defines Coronavirus Relief Fund (Fund) to mean funds received by the State of North Carolina during the 2019-20 fiscal year from the Coronavirus Relief Fund created by the federal Coronavirus Aid, Relief, and Economic Security Act of 2020. Clarifies that the funds to Golden LEAF are to provide grants to entities for the purpose of making emergency loans (was, to entities capable of making emergency loans) to assist small businesses with business needs during the period of economic hardship occasioned by the COVID-19 epidemic. Makes conforming changes to require OSBM to deposit biannually remitted funds to the Fund, rather than the General Fund. Specifies that deposits into the Fund are receipts that do not constitute an appropriation made by law under Section 7 of Article V of the Constitution.
Amends the definition of net loan funds to mean the total authorized appropriation less administration costs, as previously specified, and the State's loan funds that are not recaptured (previously, referred to the State's proportionate share of loan funds that are not recaptured).
Business and Commerce, Government, Budget/Appropriations
APPROP
Directs the Office of State Budget and Management (OSBM) to make $75 million available for Golden LEAF to provide grants to entities capable of making emergency loans to assist small businesses during periods of economic hardship occasioned by the COVID-19 epidemic. Details nine requirements and criteria for the loans, including setting a maximum term of the loan to 66 months and a maximum amount of the loan at $50,000 per qualifying business, and barring the award of new loans using State funds appropriated in the act at six months following the date the state of emergency, defined by Executive Order No. 116 issued on March 10, 2020, ends. Additionally, directs Golden LEAF to require lenders to prioritize loans for establishments with 100 or fewer full-time equivalent employees as of the State of Emergency, and that are independently owned by a qualifying business. Sets forth seven defined terms. Defines a qualifying business to mean a business with a physical presence in the State that is able to show economic losses as a result of COVID-19.
Predicates the appropriations upon Golden LEAF matching State funds at $15 of non-State funds for every $75 of State funds appropriated by the act. Allows for matching by prior non-State fund expenditures as specified. Requires Golden LEAF to remit the net loan funds that have been received to OSBM every six months following the end of the state of emergency. Requires OSBM to deposit the funds into the General Fund.
Appropriates $75 million from the General Fund to OSBM for the 2019-20 fiscal year for the act's purposes.
Establishes biannual reporting requirements for Golden LEAF to report to specified NCGA committees and division on the program. Terminates the reporting requirement after submission of the report following remittance of the entirety of the net loan fund to OSBM. Details required contents of the reports, including the number of loans awarded and jobs retained, and the amount of loans repaid and defaulted to date.

redpajama_set_name: RedPajamaCommonCrawl


text:
SSA, NEO Garden and SG Cares Bring New Year Joy to families
SINGAPORE, 9 JANUARY 2021– The Singapore Swimming Association (SSA) today gave a gift of Curry Bombs to 500 families within the SG Cares Volunteer Centres and community partner networks as part of the association's Corporate Social Responsibility programme.
Working together with SSA's Official Food and Beverage partner, Neo Garden Catering, and Ministry for Culture, Community and Youth's (MCCY) SG Cares Office, more than 180 volunteers including national athletes from artistic swimming, diving, swimming, and water polo, national coaches, technical officials, parents and affiliates fanned across the island to varied locations such as Ang Mo Kio, Jalan Tenteram, North Bridge Road, Sin Ming, Tampines, Toa Payoh and Yishun during lunchtime to deliver Curry Bombs to these families.
Joining the volunteers in Yishun was Mr Eric Chua, Parliamentary Secretary of Ministry of Culture, Community and Youth & Ministry of Social and Family Development, who distributed Curry Bombs together with Mr Lee Kok Choy, President of SSA and Mr Jeffrey Liew, Executive Director of Neo Group to elderly beneficiaries from TOUCH Senior Activity Centre.
"A big thank you to the Singapore Swimming Association and Neo Garden for taking the lead in this project. I am also grateful for the many volunteers from our SG Cares Volunteer Centres, who have joined us in serving vulnerable Singaporeans. This initiative is clearly a demonstration of our kampong spirit; different organisations coming together to 'pay it forward'. In spite of these trying times, let's continue to grow the spirit of SG Cares for a better Singapore tomorrow!" said Mr Chua.
Other recipients of the Curry Bombs today included families and seniors from organisations such as AMKFSC Community Services, Care Corner FSC, Peace-Connect, and Whampoa FSC. A further 500 curry bombs will be delivered to other organisations by the end of January.
National swimmer, Jonathan Tan, who was among the volunteers in Yishun, said "I am very proud to be part of such a meaningful event. We should always lend a helping hand to those in need and I am grateful for the opportunity that SSA has given us to give back to the community. Hopefully this small gesture will go a long way in helping those in need and help build a more gracious society."
Mr Neo Kah Kiat, Chairman, Founder and CEO of Neo Group said, "We at Neo Garden are always delighted to be able to give back to the community. This event is especially meaningful as every Curry Bomb sold helps three groups of people, SSA, ST Pocket Fund and the residents who are gifted with the donated Curry Bomb. I would like to thank all donors and volunteers who have generously contributed their time and money to this event."
This was the second food distribution event by SSA and Neo Garden as part of the Neo Garden "Curry Bomb For A Good Cause" Campaign. Previously, the SSA's Men's and Women's National Water Polo teams partnered with Marine Parade Cluster, to distribute 200 Curry Bombs to families within the Kembangan-Chai Chee and Braddell Heights Constituencies together with Speaker of Parliament, Tan Chuan-Jin and Member of Parliament, Mr Seah Kian Peng.
The Neo Garden "Curry Bomb For A Good Cause" Campaign was launched in October 2020 and aims to sell 30,000 Curry Bombs for charity. To date, a total of 24603 Curry Bombs have been sold. All proceeds from the sale of these Curry Bombs will go to the Straits Times School Pocket Money Fund and the SSA's One Team Singapore Fund.
To order Curry Bombs for a good cause, visit neogarden.com.sg/currybomb.


Orient's Myles Judd is in the running to win the LFE Apprentice of the Year Award for League Two.
The 18-year-old has enjoyed a strong season both with the under-18s, being part of the side which made it through to the third round of the FA Youth Cup, as well as breaking into the first team.
The defender made his league debut for the O's this season in the 1-0 home defeat to Exeter City and has made 21 first-team appearances to date and to top it all off, the youngster also signed a two-year professional deal earlier in the season.
Judd is up against Plymouth Argyle's Alex Fletcher and Cambridge United's Leon Davies in League Two and the winner will be announced at the EFL Awards night on April 9 at London's The Hilton on Park Lane.


Applications are invited by IPE Hyderabad (Institute of Public Enterprise, Hyderabad) for admission to two years full-time Post Graduate Diploma in Management (PGDM) program in general, Retail Marketing (RM), Banking, Insurance & Financial services (BIF), International Business (IB) and Human Resource Management (HRM) for the commencing session 2016.
Merit Scholarships upto Rs. 75000 for students with score of 70 and above percentile in CAT/ XAT/ GMAT/ CMAT/ MAT/ ATMA are available.
o Applicants submitting online application need to net transfer Rs. 500 to SBH Ac no: 52198267621; IFSC Code: SBHY0020071; and need to furnish the details of UTR/ref transaciton ID in the payment details of online form.
o Applicants can also mail to [email protected] for a scanned copy of printed application form and can send in the filled in form along with a DD of Rs.500/- drawn in favour of 'Institute of Public Enterprise' payable at Hyderabad.
Short listed candidates will be called for Group Discussions (GD) and Personal Interviews (PI) to be held at IPE and at major cities / towns during February-March 2016. Final selection will be based on the performance of the candidates at the test, GD, PI and consistent academic record.
Last Date for filling up application: Thursday, December 31, 2015 (1st cycle).


text:
/**
 * Adds a Smush Now button and displays stats in Media Attachment Details Screen
 *
 *
 */
(function( $, _ ) {

	// Local reference to the WordPress media namespace.
	var smush_media = wp.media;

	if( 'undefined' != typeof smush_media.view &&
        'undefined' != typeof smush_media.view.Attachment.Details.TwoColumn ) {
        // Local instance of the Attachment Details TwoColumn used in the edit attachment modal view
        var smushMediaTwoColumn = smush_media.view.Attachment.Details.TwoColumn;

        /**
         * Add Smush details to attachment.
         */
        smush_media.view.Attachment.Details.TwoColumn = smushMediaTwoColumn.extend({

            render: function () {
                // Get Smush status for the image
                this.getSmushDetails(this.model.get('id'));
            },

            getSmushDetails: function (id) {
                wp.ajax.send('smush_get_attachment_details', {
                    data: {
                        _nonce: smush_vars.nonce.get_smush_status,
                        id: id
                    }
                }).done(_.bind(this.renderSmush, this));
            },

            renderSmush: function (response) {
                // Render parent media.view.Attachment.Details
                smushMediaTwoColumn.prototype.render.apply(this);

                this.renderSmushStatus(response);
            },

            renderSmushStatus: function (response) {
                if (!response) {
                    return;
                }
                var $detailsHtml = this.$el.find('.attachment-compat');
                var html = this.generateHTML(response);
                $detailsHtml.append(html);
            },

            generateHTML: function (response) {
                var template = _.template('<%= label %><%= value %>');
                var html = template({
                    label: smush_vars.strings['stats_label'],
                    value: response
                });

                return html;
            }
        });
    }

    // Local instance of the Attachment Details TwoColumn used in the edit attachment modal view
    var smushAttachmentDetails = smush_media.view.Attachment.Details;

    /**
     * Add Smush details to attachment.
     */
    smush_media.view.Attachment.Details = smushAttachmentDetails.extend( {

        render: function() {
            // Get Smush status for the image
            this.getSmushDetails( this.model.get('id') );
        },

        getSmushDetails: function( id ) {
            wp.ajax.send( 'smush_get_attachment_details', {
                data: {
                    _nonce: smush_vars.nonce.get_smush_status,
                    id: id
                }
            } ).done( _.bind( this.renderSmush, this ) );
        },

        renderSmush: function( response ) {
            // Render parent media.view.Settings.AttachmentDisplay
            smushAttachmentDetails.prototype.render.apply( this );

            this.renderSmushStatus( response );
        },

        renderSmushStatus: function( response ) {
            if ( ! response ) {
                return;
            }
            var $detailsHtml = this.$el.parent().find('.compat-item');
            var html = this.generateHTML( response );
            $detailsHtml.append( html );
        },

        generateHTML: function (response) {
            var template = _.template('<%= label %><%= value %>');
            var html = template({
                label: smush_vars.strings['stats_label'],
                value: response
            });

            return html;
        }
    } );

})( jQuery, _ );

redpajama_set_name: RedPajamaGithub


text:
Two Bills Strip Cities of Their Power over Developers
By Preserve LA
(24 June 2019) Every neighborhood in Los Angeles is threatened by two game-changing developer bills now moving quickly through the legislature in Sacramento. We are asking that you write separate opposition emails against both:
SB 330, authored by state Sen. Scott Wiener's leading Bay Area ally, Nancy Skinner.
Scott Weiner's "gut and amend" – an ugly surprise bill few people know of, SB 592.
We at Coalition to Preserve LA have just returned from Sacramento, where statewide allies from north and south met with a dozen legislative offices. You can read about our trip here.
Please share the below info IMMEDIATELY with your friends and neighbors. We urge YOU TODAY and TOMORROW to send opposition emails against these 2 bills, both of which strip cities of their planning powers and silence you, handing the power to for-profit developers. All areas are at risk.
SB 592 and SB 330 will be heard in committee July 3 and July 10, respectively. The address to send emails opposing these outrageous developer-takeover bills are below.
L.A. City Councilman Paul Koretz strongly opposes Nancy Skinner's SB 330 because it cripples the power cities have over developers. He asked for a report from City Planning, but SB 330 is moving faster through the legislature than City Hall is moving.
SB 330 kills many hearings on megaprojects and spot zoning, by allowing cities a TOTAL of just 5 public hearings, workshops, or continuances on controversial projects, a bizarre rule to cripple public testimony.
SB 330 invites developers to sue a city for $10,000 per unit if an outsized luxury project is rejected by a city.
Developers are free to invade residential areas with a freakish form of "mixed use" allowing restaurants, bars and businesses atop apartments on entirely residential streets.
Land-use/CEQA attorney Jamie Hall says "Neighborhood Council Land Use Committees will be undermined by SB 330, and the input of all residents and others affected by a project will be disenfranchised."
Wiener's other bill, SB 592, a sneaky last-minute "gut and amend" that until a few days ago was a bill about cosmetology, uses a different route to strip cities of power over developers:
Allows developers to override a city rejection by letting the developer argue that being asked to reduce the project's size or density isn't "economically viable" for them.
Imposes illegal Silicon Valley practices statewide: huge dormitory-style projects will be allowed in single-family and all residential areas of L.A.
Please write TWICE to the legislative "portal" below. You will write 2 separate letters to the "portal" — one, opposing SB 592 & the other, opposing SB 330. Feel free to use our language or your own words. https://calegislation.lc.ca.gov/Advocates/
RV Towing Bill is Up for Revision
It is Illegal to Ride or Park Scooters on Walk Streets! Sidewalks!
K.S. Bryan
I oppose SB 330 as an unacceptable and ill-advised "top down" approach to land use that favors big developers over taxpayers and residents. We want LOCAL land use control, not one-size-fits-all commands from Sacramento.
K. S. Bryan
I strongly oppose SB 592 on both content and procedure. This bill greatly favors big developers over residents and taxpayers whose lives will be affected by it. It was introduced in an underhanded way, and it goes much further to erode local land use control than it first appears. My husband and I have lived in California for decades, and we are stunned at what is now going on in our state legislature. Scott Wiener has sold out to the big developers. We don't want his kind of "solution" to housing, and we will fight to get this bill defeated one way or the other. SB 592 and any bills like it are completely unacceptable.


text:
Q: Can Intellij debug javascript code served by a local web server I am familiar with using IntelliJ integrated JavaScript debugging to debug JavaScript files.
However, in the web browser the start address is always file-based as in :
file:///W:/WORK/JQueryClient/src/index.html

I'm working on an application which is making REST calls to my own web server.  So if I start from a file address it won't work because of cross domain issues.  (I can't use JSONP because I will be using PUT and POST in addition to GET , and besides the deployed application will serve up everything from the same domain, I want to code the application identically to the development world).
In Chrome or Firefox I simply get round this by pointing at my web server
http://localhost:50036/src/index.html

Here the files served up by my web server are  my own local files.
Is there anyway I can configure IntelliJ  to start at local host
 in place of a file address?

A: Sure you can - you need using the JavaScript Remote debug configuration, set your 'http://localhost:50036/src/index.html' as 'URL to open' and specify remote URL mapping for your project folder (usually it's your web server root url + web path on server)
See http://wiki.jetbrains.net/intellij/Remote_JavaScript_debugging_with_WebStorm_and_PHPStorm#Installing_and_configuring_Apache_Web_server for more info
Note that as of WebStorm 7 there is only one run configuration for JS debugging, and the run configuration created from right-click menu  (action "Create/Debug" html file) uses the url on built-in http server instead of file url

redpajama_set_name: RedPajamaStackExchange


text:
Q: hand-coded table name works but dynamic name is not working in PHP This is the code That is supposed to delete the student from the table.
but it it not working.
it only works when the table name is static.
public function delete_student($student_class,$school_session,$id){
    $table_name = $student_class."_".$school_session."_student_record";
    $pdo = KITE::getInstance('pdo');
    $query = $pdo->prepare("DELETE FROM ".$table_name." WHERE `id` = ?");
    $query->bindValue(1,$id);
    $query->execute();

}

A: As I mentioned in a comment, a slash / is not permitted in the name of a table, column, function name, procedure name etc. Why then your query works when the name is statically typed is a mystery.
A quickly constructed demo that uses innodb tables with foreign keys and hopefully very little / no redundancy. If you have mysql running locally try running this in your gui ( such as heidi ) to get an idea of how it might be accomplished.
drop database if exists `demo_school_sessions`;
create database if not exists `demo_school_sessions`;
use `demo_school_sessions`;

drop table if exists `classes`;
create table if not exists `classes` (
  `id` int(10) unsigned not null auto_increment,
  `class` varchar(50) not null,
  primary key (`id`)
) engine=innodb default charset=latin1;

insert into `classes` (`id`, `class`) values
    (1, 'mathematics'),
    (2, 'physics'),
    (3, 'computing');

drop table if exists `sessions`;
create table if not exists `sessions` (
  `id` int(10) unsigned not null auto_increment,
  `session` varchar(50) not null,
  primary key (`id`)
) engine=innodb default charset=latin1;

insert into `sessions` (`id`, `session`) values
    (1, 'summer'),
    (2, 'winter'),
    (3, 'spring'),
    (4, 'autumn');

drop table if exists `students`;
create table if not exists `students` (
  `id` int(10) unsigned not null auto_increment,
  `student` varchar(50) not null,
  primary key (`id`)
) engine=innodb default charset=latin1;

insert into `students` (`id`, `student`) values
    (1, 'bobby droptables'),
    (2, 'sue select'),
    (3, 'david delete'),
    (4, 'valerie view'),
    (5, 'peter procedure'),
    (6, 'freddy function');

drop table if exists `year`;
create table if not exists `year` (
  `id` int(10) unsigned not null auto_increment,
  `year` varchar(9) not null default '2014/2015',
  primary key (`id`)
) engine=innodb default charset=latin1;

insert into `year` (`id`, `year`) values
    (1, '2014/2015'),
    (2, '2015/2016'),
    (3, '2016/2017'),
    (4, '2017/2018'),
    (5, '2018/2019'),
    (6, '2019/2020');

drop table if exists `master`;
create table if not exists `master` (
  `id` int(10) unsigned not null auto_increment,
  `student` int(10) unsigned not null default '0',
  `class` int(10) unsigned not null default '0',
  `session` int(10) unsigned not null default '0',
  `year` int(10) unsigned not null default '0',
  primary key (`id`),
  key `student` (`student`),
  key `class` (`class`),
  key `session` (`session`),
  key `year` (`year`),
  constraint `fk_year` foreign key (`year`) references `year` (`id`) on delete cascade on update cascade,
  constraint `fk_class` foreign key (`class`) references `classes` (`id`) on delete cascade on update cascade,
  constraint `fk_session` foreign key (`session`) references `sessions` (`id`) on delete cascade on update cascade,
  constraint `fk_stud` foreign key (`student`) references `students` (`id`) on delete cascade on update cascade
) engine=innodb default charset=latin1;

insert into `master` (`id`, `student`, `class`, `session`, `year`) values
    (1, 1, 3, 4, 1),
    (2, 1, 1, 4, 1),
    (3, 2, 2, 4, 1),
    (4, 2, 3, 4, 1);

/* example to select records */
select * from `master` m
  left outer join `students` s on s.id=m.student
  left outer join `classes` c on c.id=m.class
  left outer join `sessions` ss on ss.id=m.`session`
  left outer join `year` y on y.id=m.`year`
where m.`class`=3 or m.`student`=1;

/* Example to delete a student */
delete from `students` where `id`=1;

/*

*/

Because of Foreign Key Dependencies if you delete a student from the student table all associated records from the master table would also be deleted as there is a cascade set for both update and delete. Care MUST be taken when using foreign keys like this because if you delete a record accidentally and there is a cascaded delete set on the key then all the associated records disappear!