Linom Helper Tools

Quiz_questions Query :

SELECT DISTINCT quiz_questions.id,quiz_questions.title,quiz_questions.quiz_id,quiz_questions.descriptive_question,quiz_questions.descriptive_answer,quiz_questions.order,quiz_questions.level,quiz_questions.is_old FROM quizzes,quiz_questions,quiz_question_options WHERE quiz_question_options.quiz_question_id = quiz_questions.id AND quiz_questions.quiz_id = quizzes.id AND quizzes.description="فیزیک"

Quiz_question_options Query :

SELECT quiz_question_options.id, quiz_question_options.title, quiz_question_options.description, quiz_question_options.quiz_question_id, quiz_question_options.descriptive_answer, quiz_question_options.is_correct, quiz_question_options.order FROM quiz_question_options, quiz_questions, quizzes WHERE quiz_question_options.quiz_question_id=quiz_questions.id AND quiz_questions.quiz_id=quizzes.id AND quizzes.description='بافت';

Search Order by Order ID Query :

SET @order_id = 5878; SELECT orders.user_id, order_items.order_id, order_items.purchasable_id course_id, order_items.paid_teacher, order_items.course_price, site_payments.paid, site_payments.amount, site_payments.discount_amount, site_payments.from_wallet_amount, site_payments.pay_amount, orders.affiliate_id, site_payments.updated_at FROM orders,order_items,site_payments WHERE orders.id = @order_id AND order_items.order_id=orders.id AND orders.id = site_payments.order_id;

Search Order by User ID Query :

SET @user_id = 3628; SELECT orders.user_id, order_items.order_id, order_items.purchasable_id course_id, order_items.paid_teacher, order_items.course_price, site_payments.paid, site_payments.amount, site_payments.discount_amount, site_payments.from_wallet_amount, site_payments.pay_amount, orders.affiliate_id, site_payments.updated_at FROM orders,order_items,site_payments WHERE orders.user_id = @user_id AND order_items.order_id=orders.id AND orders.id = site_payments.order_id;

Videos Query :

SELECT videos.* FROM videos,topics,courses WHERE topics.id=videos.topic_id AND topics.course_id=courses.id AND courses.id=8

Video Description Query :

SELECT videos.id,videos.title,videos.description FROM videos,topics,courses WHERE topics.id=videos.topic_id AND topics.course_id=courses.id AND courses.id=8

Comment Query :

SELECT comments.id,comments.commentable_id,comments.user_id,comments.parent_id,comments.is_approved,comments.comment FROM comments,videos,topics,courses WHERE comments.commentable_id=videos.id AND topics.id=videos.topic_id AND topics.course_id=courses.id AND courses.id=8

Viewed Video By User Query :

SELECT DISTINCT video_progress.video_id,courses.id AS courses_id FROM video_progress,videos,topics,courses WHERE video_progress.user_id = 3628 AND video_progress.video_id = videos.id AND videos.topic_id = topics.id AND topics.course_id=courses.id